Friday, March 9, 2012

Need advice

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.
Thanks
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.
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:574D914C-55A2-48B3-B606-55DD5D9E02BC@.microsoft.com...
> 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.
> Thanks

No comments:

Post a Comment