Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 To replicate or not to replicate

Author  Topic 

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2003-07-21 : 05:27:10
Hello

I am using SQL server 7 and wish to setup a second server for reporting etc. The data for the reports can probably withstand being up to an hour or so out of date. My question is this - do I replicate or do I setup a job to DTS the data? Perhaps more importantly what sort of criteria should I consider in choosing.

thanks in advance

steve

Steve no function beer well without

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2003-07-21 : 05:53:58
Think that replication is better.

- Vit
Go to Top of Page
   

- Advertisement -