In Progress

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.

Skills: Database Programming, ASP, MySQL, Microsoft SQL Server, Database Design, Database Development

See more: 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

About the Employer:
( 7 reviews ) Horsley, NSW, Australia

Project ID: #26834905

Awarded to:

tutulsoft

-- 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 More

$650 AUD in 7 days
(26 Reviews)
5.4

24 freelancers are bidding on average $698 for this job

(139 Reviews)
9.1
(58 Reviews)
8.5
(192 Reviews)
7.8
jayantavkumar

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 / More

$500 AUD in 5 days
(28 Reviews)
5.0
topdeveloper000

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 in 7 days
(4 Reviews)
4.8
TEKSCENT

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 in 15 days
(17 Reviews)
4.1
angnut

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 More

$1000 AUD in 20 days
(19 Reviews)
4.2
vw2235702vw

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 in 3 days
(5 Reviews)
3.0
taunokont

Hi, I just reviewed your project description and interested in your job now. I am a skillful database manager who has rich experience in DB management, especially in SQL, NoSQL, PostgresSQL, MSSQL, API development & in More

$500 AUD in 7 days
(3 Reviews)
3.6
lazrodrigue

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 More

$500 AUD in 7 days
(2 Reviews)
1.5
gnrupesh

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 More

$556 AUD in 10 days
(1 Review)
0.8
AbhishekSingh08

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, More

$750 AUD in 7 days
(2 Reviews)
2.1
fabiosantiago

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 More

$500 AUD in 7 days
(0 Reviews)
0.0
wahmad1983

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. More

$833 AUD in 21 days
(0 Reviews)
0.0
amitmeher2010

.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 More

$650 AUD in 7 days
(0 Reviews)
0.0
$611 AUD in 20 days
(0 Reviews)
0.0
kavitapattanaik1

Dear Prospective Customer, This is Chinmayee, from Blue Digital Media and Web Solutions. a leading IT company having 15 years of experience in the field of digital marketing associated with creativity and dynamism s More

$749 AUD in 9 days
(0 Reviews)
0.0
j0cramos

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

$556 AUD in 15 days
(0 Reviews)
0.0
pandyamunjal

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 More

$600 AUD in 10 days
(0 Reviews)
0.0
olayajorge

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 More

$250 AUD in 2 days
(0 Reviews)
0.0