Hi. I was creating an enrollment system for my Thesis, and my adviser told me that I must have a Code in my program that Synchronize database from client and server so that if the terminal connection is "Up" the data will go to the server and if the connection is "Down" the data will go to the installed server on the the local machine. and every 20 mins or 30 mins will sync the database. can somebody help me. Any Idea how to do this Sync thing. thank you. :) have a nice day.
Jump to Post
As this is a project for a tesis, i will suggest the following:
Tables on both databases must have a global unique identifier field and also a synchro time field, and a row status (syncronized, updated, inserted or deleted).
In order to optimize the access to this info this can …
Jump to Post
the biggest problem you will have is establishing a unique primary key. They cannot be set from the server because if the server is down you will not be able to add new rows. Possibly the most practical solution is for each client machine to have a unique id. the …
All 5 Replies
We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.