Developer needed for linking two databases

We need to synchronize data across databases with difference schemas and on different platforms: MS SQL database and MySQL. The connection does not need to be in real-time. Any updates to one database must be replicable to any other database conforming to one of the two supported schemas.

Specific Requirements:

• Records are uniquely identified in each schema.

• All data in the source database will be replicated to the target database.

• Any existing data in the target database(s) will be updated.

• Any conflicts (changes in the target base not present in the source database) will be identified and reported.

• Any data inconsistencies (incomplete data that does not conform to the target schema) will be reported and abort the updates

• The target database must always be in a consistent state

• The process should report all changes applied to the target database.

Quality and reliability is more important than speed. A large proportion of the work has already been completed by a previous programmer which may be useful.

We are happy to provide further information (e.g. database dumps, schematic etc)to to interested parties before they apply or accept, so please ask for whatever you require to determine if you can carry out the task. Preference will not be given to early applicants but for whoever, can best complete the task.

Please do not apply for this job if you are not confident that you have the necessary skills and experience.

Taidot: Tietokantaohjelmointi, ASP, MySQL, Microsoft SQL Server, Database Design, Tietokantakehitys

Näytä lisää: mysql query multiple databases different servers, how to get data from multiple databases in sql server, sql use statement multiple databases, sql access multiple databases, query across multiple databases on different servers, how to join two tables from different database in oracle, query across multiple databases sql server, mysql query across multiple databases, qbfc freelance developer needed, iphone developer needed, outsource developer needed, cakephp developer needed, php oscommerce developer needed, ajax developer needed, emails needed existing databases, flash games developer needed, delphi developer needed, magento website developer needed, mmorpg developer needed, aspnet developer needed

Tietoa työnantajasta:
( 7 arvostelua ) Horsley, NSW, Australia

Projektin tunnus: #26834905

Myönnetty käyttäjälle:


-- Last 20 years I am Database Expert Specially also for linking Database to database , for Example an ERP System Few module into Oracle Enterprise Suite and Sales Automation MS SQL Database System, Regular data sync f Lisää

$650 AUD 7 päivässä
(26 Arvostelua)

23 freelanceria on tarjonnut keskimäärin 707$ tähän työhön

(140 arvostelua)
(59 arvostelua)
(193 arvostelua)

Proposal - I would recommend you to go with ETL tool to synchronize your data between 2 database and that will be best for future. Let me know if you want to discuss further. I am a database / Business Intelligence / Lisää

$500 AUD 5 päivässä
(28 arvostelua)

Hello I am very interested in your project since i have rich experience on it. I am sure i can deliver the perfect result as you want on time. Looking forward to hearing from you. Best regards

$500 AUD 7 päivässä
(4 arvostelua)

hi I have around 10 years of professional experience in sql development and worked in more than 200 [login to view URL] discuss your [login to view URL] there and database link

$556 AUD 15 päivässä
(17 arvostelua)

Hi, I am an italian backend developer. I have a lot of experience on databases and I like your project. To have a good job I need time and budget, and of course more informations. 1) db schema 2) do you want a windows Lisää

$1000 AUD 20 päivässä
(19 arvostelua)

Dear sir, Your task seems to be easy I just want to make sure about these requirements please provide me with two databases ERDs' To understand what should I do? Thanks E

$278 AUD 3 päivässä
(5 arvostelua)

I have read your project description in detail and it seems just like that you posted this for me. I have 10 years of IT programming. My Technical background Database/Datawarehouse - SQL Server, Oracle, MySQL, Postgre Lisää

$500 AUD 7 päivässä
(2 arvostelua)

Hi, I have gone through the requirements document and the 5 scenarios of data replication. I can deliver this for you efficiently. I have many years of experience with Data Replication and Data Integration. I'm a SQL Lisää

$556 AUD 10 päivässä
(1 arvostelu)

Developer needed for linking two databases 8.8 years experience in Reactjs / Redux / Angular / flutter / Nodejs / PHP / Django / Backned - Frontend development! All of our programming skills: *Front-end: - HTML, Lisää

$750 AUD 7 päivässä
(2 arvostelua)

Hello, I have several years of experience with relational databases. Could you provide me the database shcemas and models, so I could estimate the work to be done ? Is it possible to modify the schemas for replication Lisää

$500 AUD 7 päivässä
(0 arvostelua)

Hi Team, Hope you are doing good. I am having around 11 years of IT experience which Includes mainly in the area of Database development,Design,Maintenance,Management along with worked on many data Warehouse projects. Lisää

$833 AUD 21 päivässä
(0 arvostelua)

.NET (Web Application & desktop application) ============================================ Hello. I'm a .NET ,asp.net,Razor,C#,sql server,web service expert and have built hundreds of websites. I have 5+ years of experi Lisää

$650 AUD 7 päivässä
(0 arvostelua)
$611 AUD 20 päivässä
(0 arvostelua)

I have experience in this type of development, in these projects I would make a layer that manages the different databases in a dynamic way, thus making access to data easier and more dynamic in searches and other func Lisää

$750 AUD 7 päivässä
(0 arvostelua)

I have a lpt of experience working qith mysql and mssql. Recentrly i develop a sync between mssql and mysql

$556 AUD 15 päivässä
(0 arvostelua)

Dear Sir, First of all thanks for providing this opportunity. Looking at your requirements document, seems that you require a service which will act as an interface between 2 different database for synchronization. I Lisää

$600 AUD 10 päivässä
(0 arvostelua)

Hi there, I read your job details carefully and then I think I am suitable for this job. I have worked similar project with client before. If you hire me the project, I am very happy and get started as soon as possible Lisää

$250 AUD 2 päivässä
(0 arvostelua)

I am database expert and web developments. contact me to solve problem now. You will get a satisfactory result.

$450 AUD 10 päivässä
(0 arvostelua)