MS-SQL & MySQL Data 2 Way Data Synchronisation Tool

I have 1 database in SQL which works offline. I want a data synchronisation utility to run in background of my application which will keep syncing data from local database to online cloud database as and when internet connection is available.

The system should be so robust that there is no issues if internet connect gets lost in-between synchronisation.

The utility should always check first for fields and table mismatch and update database accordingly before starting the data synchronisation.

The utility will keep running in background and ensure local and server database are exactly replica of each other.

Here’s the process I want in the tool.

1. There will be 2 identical database. 1st on local server will be SQL-Express and 2nd will be on internet -MySQL.
2. The tool will keep running in background and sync schedule will be by default 5 minutes. User can reduce or increase this time.
3. There are flags for new data, updated data, deleted rows in each table.
4. There is another table which has order of all the tables mentioned for sync purpose.
5. Utility will fetch first table from sync table.
6. Utility will get all new records for table no. 1 in local database (sender), and insert them to online MySQL database (receiver database).
7. Utility will then get all updated rows and update them online MySQL database.
8. Utility will then update all delete marked rows and make them deleted on online MySQL Database.
9. Utility will repeat process no. 6-8 for all tables in Sync-Table one by one. (Code should be standardised for each table).
10. Once local to online job is completed, Utility will reverse connections. Now sender connection will be remote MySQL & Receiver connection will be local db SQL-Express.
11. Repeat process from 5-9 after changing sender and receiver connections.

Alerts & Checks:

1. If there is no internet connection.
2. If there is mismatch in table structures. Continue syncing other table and skip only tables where fields mismatch.
3. Create log of sync process (start time & end time for each table for add,edit,delete update). Also enter number of rows added, updated, delete marked in log for each table and each process.

Compétences : Programmation C#, Programmation de bases de données, MySQL, SQL

Voir plus : sql hierarchical data mysql, transfer data mysql sql server visual studio, mysql sql server data transfer, transferring data mysql sql server, transfer data mysql sql, simple mysql php show data dropdown, date php mysql booking tool examples, php mysql sort form data, php mysql booking tool, transfer data mysql sql server

Concernant l'employeur :
( 4 commentaires ) Ahmedabad, India

N° du projet : #8466221

20 freelance ont fait une offre moyenne de 31000 ₹ pour ce travail


Hello sir, Ref your project description we would like to inform you that we are a team of experts working in the field of website and software development services, we have reviewed your requirements and would lik Plus

44736 ₹ INR en 10 jours
(9 Commentaires)

A proposal has not yet been provided

33333 ₹ INR en 10 jours
(23 Commentaires)

Hi. I propose using SymmetricDS [url removed, login to view] It is very robust, reliable tool that develop and use more years. It will work offline, do bidirectional synchronization and fullfil mostly your request. Plus

88888 ₹ INR en 20 jours
(4 Commentaires)

Hi, I have already developed a 2 Way Data Synchronisation Tool. I can show you the demo of it. Let me know when you will be available

30000 ₹ INR en 3 jours
(40 Commentaires)

Dear Sir. I checked your descriptions. I have rich experiences like your project. I am very happy to have a chance to have contact with you, and this would be a great turning point for success in your business. Th Plus

36842 ₹ INR en 10 jours
(5 Commentaires)

Hello, I have been working with a MNC based company since last ~ 5 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in Plus

27777 ₹ INR en 10 jours
(19 Commentaires)

A proposal has not yet been provided

26315 ₹ INR en 10 jours
(14 Commentaires)

Can you provide more details of this task ? Is the database mysql or any other ? Is the website ready ? I can do this synchronization task for you .

26315 ₹ INR en 20 jours
(4 Commentaires)

A proposal has not yet been provided

27777 ₹ INR en 12 jours
(1 Commentaire)

A proposal has not yet been provided

27777 ₹ INR en 10 jours
(2 Commentaires)

SINCERE | 15 Years Exp. | Software, Services, Training | Need ratings, thus quality guarantee | Working for customer delight | Additional work at no extra cost | 24/7 on Phone, Skype, Mail | [url removed, login to view] NOTE: The Plus

37500 ₹ INR en 10 jours
(4 Commentaires)

What is the version of the MS-SQL that runs offline? and the online? How big are the two databases? How often and how much do data change? Do data actually change, or are only new data added to the existing? I w Plus

12500 ₹ INR en 3 jours
(1 Commentaire)

Hi, client. I have understood your demand and could do surely. But I have some questions. - localDB is MS-SQL? or MySQL? -onlineDB?

27777 ₹ INR en 10 jours
(1 Commentaire)

Hi, I have a team of expert database and C# developers. We have done this kind of work earlier in which we have to implement the single sign on for different sites and if main server is down, due to any reason, then Plus

38888 ₹ INR en 15 jours
(1 Commentaire)

Hello Sir, We have gone through the details you have provided and we have already worked on a similar project before and can deliver as u have mentioned and would be pleased to work on this with you to deliver the resu Plus

27777 ₹ INR en 10 jours
(1 Commentaire)

New on FL. Need resumè builders.

21111 ₹ INR en 5 jours
(0 Commentaires)

Hello, I will provide you quality application as per your requirements within your budget.I have a professional experience in windows development.

22222 ₹ INR en 10 jours
(0 Commentaires)

I provide you following Qualities in Web site 1- Usability (easy to use) 2- Utility (proper working) 3- Guidelines (I guide you about advance qualities) 4- Latest Functionality 5-Fast-loading pages 6- Consistent Plus

16666 ₹ INR en 50 jours
(0 Commentaires)

A proposal has not yet been provided

27777 ₹ INR en 30 jours
(0 Commentaires)

I have already develop this tool, for a company. This tool is sync the data from ms access to oracle database as every day it will sync. If you want this tool then contact me on debasis.freelance#[url removed, login to view] or call me Plus

33333 ₹ INR en 12 jours
(0 Commentaires)