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