Configuring a SQL Publication to Replicate a Catalog

  • Article

Preparing the server running SQL Server to participate in a replication environment is outside the scope of this document; however, the following configurations were made to support transactional replication between the staging server and the production servers:

  • The staging server was set up as the publisher and the distributor.

  • The distribution database was configured on the staging server.

  • The two production servers were added as subscribers.

    Ee796659.note(en-US,CS.20).gifNote

  • It is recommended that a qualified SQL Server administrator provide guidance in configuring replication for your environment.

Configuring the publication to support a one-way replication of the product catalog involves the following steps:

  1. Creating a Replication Publication of all the tables, the catalog-specific stored procedures, and user-defined functions.
  2. Generating the Pre-Snapshot.sql script to support the initial snapshot replication to subscribers.
  3. Modifying the Pre-Snapshot.sql script to support specific workarounds to ensure a successful, ongoing replication.
  4. Updating the publication with the Modified Script.
  5. Adding Subscribers to the Publication.
  6. Updating full-text Indexes in production.
  7. Refreshing the catalog cache.
  8. Invoking catalog replication on demand.

Copyright © 2005 Microsoft Corporation.
All rights reserved.