Posted by Tahir on 02/27/06 13:57

HelpTopic: Import/Restore/Transfer, Only Updated/Changed/New Values
Between Two SQL Servers Over Dialup Connection.
--
Hi All,
I need a little helping hand/Tips:

The Problem & Situation: One of the client have 7 Branches in different
parts of country. Now on Month End Closings, database backups are sent
on CDs through Express Mail, which usually gets to the head office a
bit late and due to that, many Post-Month-End Process in head office
remain Pending.

Is there any way we can get ALL or Updated/New/Changed Values between
Two SQL Servers (from source to head office) Once-or-Twice A Week
through DIAL-UP/TELEPHONIC Connection, as few branches can only be
accessed Online through Telephone Line.

We are using MS SQL Server 7 & 2000. And there are around 350 tables in
a single database.

Any Help/Hints/Tools, etc will highly be appreciated

Thanks In Advance
Regards
Tahir
BaqarTahir@GMail.COM
+92(304)ADD-ALL-7 (+92(304)233-255-7)

• Next in forum: Re: DELETE FROM - Somethings not right
• Prev in forum: workgroup information file does not exist
• Thread view: Import/Restore/Transfer, Only Updated/Changed/New Values Between Two SQL Server Over Dialup Connection.

[Reply to this message]