October 7, 2001 at 9:02 pm
Hi Guys!
I am a true newbie to the term Replication. Can anyone elaborate for me or provide me any articles on Data Replication?
I need to know more about this because my company hopes to have a batch update(on a periodic basis) of data records from our external SQL Server to our intranet SQL Server. Would this be considered as data replication?
Thanks a million! 🙂
October 8, 2001 at 7:44 am
Replication is definitely one way to approach that problem. Depending on the complexity, a simple update statement or DTS package might be just as good. I'd suggest reading through BOL about transactional replication, it's going to be the type you'd want to use for this situation. You'll definitely want to experiment with it before trying in production. Overall it's very easy to use and very effective.
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply