Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
whodunnit
Starting Member
1 Post |
 Posted - 2006-04-27 : 03:24:08
|
| Hi,I have developed a small system, using VB 6.0 and SQL 2000. This system is installed on a server.I wish to run parallel database, replicas, as some of the users could be traveling and updating their own data. Need to know how to synch both the stand alone and the server data. I understand that I can use diff ids of the database, but then the whole data base needs to be transferred, but sometimes it could be a very lengthy procedure as the remote server could be in traveling and then transferring huge data via mail could be really tough. Is there any way where only the updated fields from the last synch date is the only data sent via mail? The size decreases drastically. Please suggest. Would really appreciate quick response.ThanksWhodunnit |
|
|
|
|
|
sync data bet remote and main server