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 ont fait une offre moyenne de 31000 ₹ pour ce travail
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 .
Hello, I will provide you quality application as per your requirements within your budget.I have a professional experience in windows development.
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