Generating migrations in SSMS
Published 15 August 2019
SQL Change Automation projects contain a representation of the schema of your development database. Whenever you make a change to your development database, SQL Change Automation can automatically capture those changes. Learn about SQL Change Automation projects.
1. Make a change to the database
In this example we will add a new stored procedure:
CREATE PROCEDURE sprTest AS BEGIN SELECT 1 END
2. Navigate to the Generate migrations page
If you were previously on this screen and the migration does not show, click Refresh.
3. View the migration differences
Clicking on the script will show the differences between the development database and the SQL Change Automation Project.
4. Generate the migrations
Click the Generate migrations button in the top-right corner. This will capture the changes in the project.
5. View the summary
When the migrations have been generated the summary page will show. You can view and manage all generated scripts by navigating to the Migrations page.