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.
20 freelance font 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
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
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
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
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
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 .
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
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
Hi, client. I have understood your demand and could do surely. But I have some questions. - localDB is MS-SQL? or MySQL? -onlineDB?
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
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
Hello, I will provide you quality application as per your requirements within your budget.I have a professional experience in windows development.
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
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