Validate Replications Dialog

The Validate Replications dialog can be used to:

  • Check that a replication has the transactional objects required in the source database for the replication to run, generate a SQL script to create the objects as needed, or create missing objects in the database.

  • Check that the actual source database schema match the schema saved in the Syniti DR metadata. This is useful if schema changes are suspected and may cause replications to fail. The schema saved in the metadata can be updated using the Rebuild option.

Click in the checkbox to the left of each replication you want to validate. All checked replications are validated for the above two purposes.

Validate Replications for Transactional Objects

This option allows you to check that a replication has all the necessary transactional objects set up and running correctly in the source database. For example, if  triggers for trigger-based replications, or articles and publications for replications from Microosft SQL Server are missing or modified, or you set the EnableTransactionalObjects property to False to create transactional objects directly on the database (instead of from Syniti DR), you can validate the replication using the right mouse button on the replication name in the Metadata Explorer.

No transactional objects are created using this option, but if any of the transactional objects exist, and the replication does not have the association established in the metadata (e.g., the log trigger tag for the replication is blank even if a trigger and log file exist), then the correct association is made and saved in the metadata.

Generate SQL Script

The Validate Replications dialog allows you to generate SQL statements to create or remove the transactional objects needed for a replication. This option is helpful when you need to modify the database directly (perhaps via your database administrator) instead of from Syniti DR.

Validate Replications for Schema Changes

This feature works in conjunction with the Stop on Schema Change property in the Replication Properties dialog for mirroring and synchronization Click Validate to check if the schema stored in the Syniti DR metadata for both the source and target tables match the current table schema. If the schemas do not match, an error is displayed in the Validate Replications dialog:

If the Stop on Schema Change property in the Replication Properties dialog is set to True, in the Replication Monitor, the ValidationResult field of the replication is set to Fail. The validation fail status prevents the Replication Agent from enabling or executing the replication.

To repair the replication status, click Rebuild. This updates the table schema after prompting whether to proceed and sets the replication validation status to Success.

Rebuild

This option allows you to:

  • Build transactional objects in the database if they do not exist or to re-create them if they are invalid. This option requires the Connection propertyEnableTransactionalObjects to be set to True.

  • Update the source table schema saved in the Syniti DR metadata to match the actual source table schema.

The Rebuild confirmation message provides information on exactly which operations will be performed, and give details in the case of any schema changes. Rebuild does not re-enable a replication.

NOTE: Following schema updates, it is advisable to check the field mapping between source and target tables using the Fields Mapping dialog available in the Replication Properties.

Opening the Validate Replications Dialog

  1. In the Management Center Metadata Explorer, select a replication.

  2. From the right mouse button menu, choose Validate Replication.