Find Jobs
Hire Freelancers

One way sync from MSSQL (LAN) to MySQL (internet)

€30-250 EUR

Pågår
Lagt ut omtrent 6 år siden

€30-250 EUR

Betalt ved levering
We need a small piece of software, really lightweight that must run on Windows Server 2012 and do a ONE-WAY sync of an MSSQL View in the local network to a MySQL database in the internet. It is a product database. Right now we have something very similar that weighs 400Kb in total. It would ideally run in text mode, and output a file log with the results of each run. We take care of periodic execution. Some fields in the MSSQL have to be mapped to the MySQL fields (can be in different tables). It must perform datatype conversions if needed. It will be synced by a UniqueIdFieldName. If UniqueIdFieldName exists in MSSQL but not in MySQL, it will create a record in MySQL and store the rest of the record related to this UniqueIdFieldName, AND it will set the Visible_Field in MySQL to None, AND it will set Field_Cat to an XML parameter (Wait_Cat). This is because product will be flagged as hidden and Waiting to be published. If MSSQL UniqueIdFieldName already exists in MySQL, it will update the rest of fields accordingly. There is a special field in MSSQL that will trigger a special action: Wether or not the UniqueIdFieldName previously existed, or had to be created, if the MSSQL field is set to Discontnued_Code (constant given by XML setup file), in MySQL the Field_Cat must be set to Discontinued_Cat (constant given in XML) and depending on a global parameter in XML, it will set Visible_Field. An XML file (structure to be freely defined by developer) will be used as a config file, including: Wait_Cat Discontinued_Code Discontnued_Cat Discontinued_Visible MSSQL address (name or IP) MSSSQL user MSSQL password MSSQL database MSSQL Viewname MySQL address (name or IP) MySQL user MySQL password MySQL database MySQL Viewname Mapping of fields MSSQL UniqueIdFieldName MySQL UniqueIdFieldName MSSQL_FieldName, DataType to MYSQL_FieldName, DataType
Prosjekt-ID: 16290925

Om prosjektet

7 forslag
Eksternt prosjekt
Aktiv 6 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
7 frilansere byr i gjennomsnitt €181 EUR for denne jobben
Brukeravatar
I work with both mssql and mysql regularly and will be able to deliver a working program quickly. I can setup the same environment, demo it for you and then deploy it in your environment or hand it over with configuration and setup instructions.
€138 EUR om 4 dager
5,0 (4 omtaler)
3,6
3,6
Brukeravatar
Estimado, tengo amplia experiencia en bases de datos y desarrollando, puedo realizarle la sincronización que necesita desde la sql server hacia MySQL, para ello necesitaría un backup de la base de datos o por lo menos la estructura de la vista así como el acceso al servidor mysql de internet o por lo menos la estructura de dicha base de datos, puedo iniciar el trabajo inmediatamente, quedo atento a tus comentarios, saludos cordiales, Gustavo
€120 EUR om 2 dager
5,0 (8 omtaler)
3,6
3,6
Brukeravatar
Hello, I am interested, can develop an app in asp.net before transfer it will provide a facility of connection with database with its credentials. Let’s talk!
€244 EUR om 10 dager
5,0 (3 omtaler)
3,3
3,3
Brukeravatar
Hi! I've got your project proposal about an application, that must perform a syncronization from MSSQL to MySQL. I'm a professional software developer with 15 years of experience, have a large expertise in both mentioned databases. Have done several projects of the same type - syncing data in databases, so i'm interested in your project and will fullfill all your requirements. Please, message me for a detailed talk, thank you!
€133 EUR om 5 dager
5,0 (1 omtale)
3,4
3,4
Brukeravatar
We are interested in your project. Your requirements are well defined. We have lots of experience in this type project. We look forward to hearing from you.
€222 EUR om 10 dager
0,0 (0 omtaler)
0,0
0,0

Om klienten

SPAINs flagg
Barcelona, Spain
5,0
1
Betalingsmetode bekreftet
Medlem siden jul. 30, 2014

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.