September 12, 2002 at 6:03 am
Urgent ... thanks.
Using SQL 7, I need to merge several tables in 2 distant DB. This has to be done using a standard modem 2 or 3 time per a day. Of course it has be light in terme of Kb.
How can I do that and where can I find some documentation about it.
Just one thing (you guessed), I nether did it before.
Thanks a lot for your help.
September 12, 2002 at 6:14 am
I would suggest that the first thing to do is ensure that all sites know about the data at the other locations...this will dramatically cut down the network traffic because you will be able to instantly identify table rows that do not exist at the far end. During the copying process, you need to flag the new rows at each location so they are not included in this comparison the next time you synchronise. I would suggest that a script should be written that is then scheduled outside of SQL by using AT and OSQL. This then gives you the opportunity of initiating the modem dialling and testing the connection in a batch file before attempting to copy data.
I am sure some others will jump in and tell me of better ways...
Simon
September 12, 2002 at 6:33 am
Merge replication does what you want. May take a while to sync, but it should get there. Worth testing anyway.
Andy
September 12, 2002 at 7:29 am
OK ... I'll try.
One more stuff, how and where do I declare the "adress" of the distant DB from each over on each SQL server site. I'm asking that it is a modem so ...
Do I need to do a special VB or C++ programm or can configure all that in SQL Svr 7 ?
Thanks a lot any way
quote:
Merge replication does what you want. May take a while to sync, but it should get there. Worth testing anyway.Andy
http://www.sqlservercentral.com/columnists/awarren/
September 12, 2002 at 7:32 am
OK ... I'll try.
One more stuff, how and where do I declare the "adress" of the distant DB from each other on each SQL server site. I'm asking that it is a modem so ...
Do I need to do a special VB or C++ programm or can configure all that in SQL Svr 7 ?
Thanks a lot any way
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply