Creating a DTS Package to Run Forced Replication

Tuesday Oct 19th 2004 by DatabaseJournal.com Staff
Share:

If you need to synchronize a large number of tables (more than 10), it is more efficient to create a DTS package that runs the forced replication process.

[From SQL Server Magazine]

If you need to synchronize a small number of tables, you might be able to do the job by running in Query Analyzer a simple batch that contains for each table one UPDATE command that replaces, but doesn't change, the table values on the Publisher server and kicks off the data synchronization process. But if you need to synchronize a large number of tables (more than 10), it is more efficient to create a DTS package that runs the forced replication process. Figure A shows the DTS dialog box where you can create the package.

The article continues at http://www.windowsitpro.com/SQLServer/Article/ArticleID/44149/44149.html

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved