In this lesson Kendra shows how SQL Prompt can help you quickly improve TSQL scripts for programmable objects and table changes in Visual Studio with SQL Change Automation.

In this video:

00:20 – Overview of programmable objects in SQL Change Automation

01:15 – Overview of the offline schema model in SQL Change Automation

02:10 – Demo of refactoring a stored procedure (a programmable object) begins. This demo includes reformatting SQL, renaming aliases/variables, and qualifying object names with SQL Prompt

07:30 – Saving the “offline edit” to the programmable object triggers option to deploy to development database

09:14 – Demo of editing an index on a table with SQL Server Data tools and generating a migration script begins. This demo shows the “offline schema model” and SQL Prompt snippets

16:11 – Deploy the edited migration script