Creating a Destination Table for Replication

When creating a DTS package using the DTS Import or DTS Export wizards, you can specify that the destination will be a replication publication. This provides a simple mechanism for creating a publication from heterogeneous data sources such as Microsoft® Access, DB2, or Oracle.

If you intend to continue maintaining the source data at its heterogeneous data site, consider saving the DTS procedure as a package, and executing it on a scheduled basis to replicate the data. When you save the DTS package, you can then schedule it to refresh the publication periodically. If you intend to migrate data from its heterogeneous data site, and will perform future modifications to the data using SQL Server, do not choose the option to save the package.

When you specify Create DTS package for replication, the Create Publication Wizard starts after the import or export wizard completes operation. Using the Create Publication Wizard, you then specify:

• The server to use as a Distributor.
• The type of publication (snapshot, transactional, or merge) if you do not choose the Save DTS Package option. Otherwise, you can only create a snapshot publication.
• The source table and any other tables in the destination database to publish.
• A descriptive name for the publication.

See Also

Implementing Replication from Heterogeneous Data Sources