Two way Data synchronization mssql 2008 express
-
Hi all, I have developed an window base application using vb.net and mssql 2008 express.It is working fine. now i have installed it on my client's machines, But i am facing a problem. my client has two pc One at home and another at his office. One person working on the home pc and another on office pc at the same time. my client wants to synchronize data when ever he wants by using Internet. In response i have an idea in my mind as following step 1 Take backup of one pc(say office pc) and send it to second pc(say home pc) step 2 ask to person working at home pc to download backcopy and restore it on the his pc. step 3 after updating home pc he also take backup of the home pc and same send it to office pc. step 4 at office the person working download the backupcopy and restore the same on his pc. but fear it takes long time and usage of internet. Kindly suggest me the best way in details. Thanks Rm
rmshah Developer
-
Hi all, I have developed an window base application using vb.net and mssql 2008 express.It is working fine. now i have installed it on my client's machines, But i am facing a problem. my client has two pc One at home and another at his office. One person working on the home pc and another on office pc at the same time. my client wants to synchronize data when ever he wants by using Internet. In response i have an idea in my mind as following step 1 Take backup of one pc(say office pc) and send it to second pc(say home pc) step 2 ask to person working at home pc to download backcopy and restore it on the his pc. step 3 after updating home pc he also take backup of the home pc and same send it to office pc. step 4 at office the person working download the backupcopy and restore the same on his pc. but fear it takes long time and usage of internet. Kindly suggest me the best way in details. Thanks Rm
rmshah Developer
Well, thats not going to work as you overwrite the database on the home pc with the one from the office pc, so you lose the work done on the home pc. One way is to add columns to your tables with the update time and action (add/change/delete) and use that those determine which records to update on the other system.
Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP