Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: replaced reference to RR with SCA

...

When you click Refresh (Verify Script), SQL Change Automation validates the script by running it against the shadow database. This identifies problems before the script is deployed.

...

If you continue to receive errors, in spite of having fixed the problems in the affected scripts, try forcing a rebuild of the shadow database. This can be done by executing the Build... Clean Solution command in Visual Studio (which will drop the shadow db from your development instance) and then clicking Refresh within the ReadyRoll tool-window.

...

Warning

Although it is technically possible to use the above method to exclude DDL statements from the verification process, we would not recommend excluding database-level objects (such as CREATE/ALTER TABLE statements) within the shadow database deployment. Doing so may impact the integrity of the script generation process, as it may lead ReadyRollSQL Change Automation's comparison engine to make incorrect assumptions about the current state of your schema model.

...