Need advice -- sql server replication

Chris
1/31/2006 9:55:26 PM

Hi,
I have a few offices accross the country running MSDE and my HQ SQL 2000. I
need to port the data nightly to the HQ. Should I consider Replication?
Whatever is done on the MSDE at the offices are not needed after copied to
the HQ. I was thinking of creating an app (running at all offices) to copy
the data nightly to the HQ but I am worried if the connection goes down
during the copy?

Please advice.

Michael Hotek
2/1/2006 1:58:17 AM

I would do this with DTS instead of replication since you don't have a
requirement to maintain the data in MSDE after it is transferred and it
doesn't appear you are sending anything from HQ back to any of the offices.

--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.

[quoted text, click to view]

sql server replication : Need advice