Step 1: Creating a Replication Publication

Use the following procedure to create a replication publication.

To create a replication publication

1. In SQL Enterprise Manager, right-click the catalogs database you want to replicate, click New, and then click Publication.

   The Create Publication Wizard starts. For detailed information about this wizard, see SQL Server Books Online.

2. Click Next.

3. In the Choose PublicationDatabase dialog box, select retail_commerce_catalog, and then click Next.

4. In the Select Publication Type dialog box, select Transactional Publication, and then click Next.

5. In the Specify Subscriber Types dialog box, select Servers running SQL Server 2000, and then click Next.

6. In the Specify Articles dialog box, select the following articles:

   • All tables except CatalogStatus and <Catalog Name>_CatalogDeletedProducts.

7. Click Article Defaults.

8. In the Default Article Type dialog box, select Table Articles.

9. In the Default Table Article Properties dialog box, on the Commands tab, clear the following three check boxes:

   • Replace INSERT commands with this stored procedure call

   • Replace UPDATE commands with this stored procedure call

   • Replace DELETE commands with this stored procedure call

     Note

   • If you do not perform this step, errors may occur during replication if you have catalogs with spaces or hyphens in the catalog name.

10. Click OK.

11. Click Next.

12. In the Article Issues dialog box, verify that the following are displayed:

    The following published tables contain IDENTITY columns:

 [dbo].[CatalogDefinitions]
 [dbo].[CatalogGlobal]
 [dbo].[AdventureWorksCatalog_CatalogProducts]

This warning message can be ignored.

1. In the Article Issues dialog box, click Next.
2. In the Select Publication Name and Description dialog box, type a name for your new publication, and a description, or accept the default name and description, and then click Next.
3. In the Customize the Properties of the Publication dialog box, select No, create the publication as specified, and then click Next.
4. In the Completing the Create Publication Wizard dialog box, click Finish.

SQL Server 2000 creates the new publication using the information you entered. If this is the first publication, it also creates the appropriate agents to monitor and notify you that it has finished configuring the publication.

Proceed to the next step, Step 2: Generating the Pre-Snapshot.sql Script.

Copyright © 2005 Microsoft Corporation.
All rights reserved.