About the Replication Management form

The Replication Management form contains links to most replication-related forms, and buttons to handle replication triggers and view updates.

Drop replication triggers

Use the Drop Replication Triggers option when you want to drop replication triggers without regenerating them. If you plan to regenerate the triggers, do not use this option.

Note: Because clicking this button drops the T-SQL trigger code in the database, no other users should be in the database (logged into the system) when the administrator does this.

Regenerate replication triggers

Use the Regenerate Replication Triggers option to put any changes to your replication setup into play. For example, any time you change a rule or category, you must regenerate the triggers. Use the Regenerate All Triggers option to regenerate replication triggers either for all tables used for replication, when this option is selected, or regenerate replication triggers only for tables with modified database objects and settings used in data replication, when this option is cleared.

Note: Because clicking this button drops and re-creates the T-SQL trigger code in the database, no other users should be in the database (logged into the system) when the administrator does this. The regeneration of triggers must be done separately on each site.

For each site used in a transactional replication rule, the regeneration process checks that “linked servers” are set up before regenerating the replication triggers. If this validation fails for any linked server, an error message displays and the regeneration cannot continue until the linked server is set up.

Note: Should you need to limit the replication generation traffic, you can use the Skip Replication Noisy Columns field on the Application Schema Tables Metadata form to specify which columns should be limited. See <new topic>.

Regenerate views to the Master Site

To realign the SQL views at all user sites in a shared tables intranet with the corresponding _all tables at the master site, click Regenerate Views to Master Site. You must be logged into the master site to perform this operation.

Note: Because clicking this button drops and re-creates T-SQL code in the database, no other users should be in the database (logged into the system) when the administrator does this.