Supporting CopyEvolve

The CopyEvolve procedure evolves, or changes, a schema and can modify tables by adding or removing columns.

The CopyEvolve procedure can also be used to change whether or not XML documents are valid. Handling CopyEvolve requires more coordination. Use the following procedure if you are issuing CopyEvolve on the source database.

  1. Quiesce changes to dependent tables on the source database.
  2. Execute the CopyEvolve on the primary or source database.
  3. Wait for Replicat to finish applying all of the data from those tables to the target database.
  4. Stop Replicat.
  5. Apply the CopyEvolve on the target database.
  6. Restart Replicat.