Step 4: Updating the Publication with the Modified Script

In this procedure, you update the publication with the script that you modified in Step 3: Modifying the Pre-Snapshot.sql Script.

To update the publication

In SQL Enterprise Manager, right-click the publication created in Step 1: Creating a Replication Publication, and then click Properties.
In the Publication Properties – retail_commerce_catalog dialog box, on the Snapshot tab, in the Additional scripts section, add the full path and location of the Pre-Snapshot.sql script you just modified, and then click Apply.
On the Articles tab, modify the default Table Article Properties.
In the Table Article Properties – CatalogCustomCatalogs dialog box, select Keep the existing table unchanged.

If you do not select this option and leave the setting in the default configuration, all the work done by the script during the initial snapshot replication will be removed. Since these tables are scripted to be created during the initial snapshot, leaving the setting to DROP the existing table and recreate it will recreate the table according to the default configuration schema in the staging environment, which must be changed using the pre-snapshot script for replication to work properly.
Click OK, and then save all the configuration changes.

You are now ready to add the subscribers to the publication.

Additional resources