Using SQL Prompt with SQL Change Automation in Visual Studio

Learn how SQL Prompt can help you quickly improve TSQL scripts in Visual Studio with SQL Change Automation. The PowerShell script shown is available at: http://bit.ly/2IfgmUK 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 2:10 - Demo of refactoring a stored procedure (a programmable object) begins 7:30 - Saving the "offline edit" to the programmable object triggers option to deploy to development database 9:08 - Test full build and deploy of first committed change in VS Code with PowerShell components 13:15 - 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" 20:19 - Deploy the edited migration script 22:40 - Perform build and deploy with PowerShell cmdlets 24:00 - Review release artifact