Creating a DTS Package to Run Forced Replication

October 19, 2004

[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