Verifying a project allows you to validate the SQL in your scripts and check the integrity of the project by deploying it against the shadow database.

Each time you use SQL Change Automation to generate migrations from a database, it will create a migration script. It is possible to edit these migrations to give greater control over how your changes will be deployed. To ensure that the project will successfully be deployed to other environments, it is recommended that you perform a local verification of the project.

Verifying a project will:

• Check each of your migrations scripts and programmable objects for valid SQL and alert you to any errors
• Deploy your project to the shadow database to ensure that the scripts will run successfully

Verify

To verify your project, navigate to the Verify page.

Viewing results

Once the verification has completed, you can view any errors or warnings:

• Errors indicate issues with the project that must be resolved before it can be deployed
• Warnings indicate potential issues that can cause unexpected behavior

If the issues are due to one of the files in your project, you can double-click on the message to start editing the file, and look at the table to see which line number the error resides on.

Once you have resolved the errors, you can re-verify to see if it is now successful.