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.
maccinelyro 0 Newbie Poster
Recommended Answers
Jump to PostAs 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@ChrisPadgham: using a GUID column accomplishes this according to this MSDN article.
Hope this helps
All 5 Replies
lolafuertes 145 Master Poster
ChrisPadgham 113 Posting Whiz
lolafuertes 145 Master Poster
maccinelyro 0 Newbie Poster
lolafuertes 145 Master Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.