Tackle real database changes with SQL projects in VS Code | Data Exposed
Microsoft Developer demonstrates how SQL projects in VS Code help teams make deployable database changes with more safety and repeatability.
Overview
In this Data Exposed episode, the presenter focuses on practical database change scenarios using SQL projects in VS Code, including refactoring and deployment workflows.
What SQL projects help with in day-to-day work
- Handling real schema changes (not just initial project setup)
- Catching issues earlier via IntelliSense while editing
- Making refactors (renames/moves) safer by propagating changes across dependent objects
- Producing deployable outputs (publish scripts) and targeting multiple environments
Demo topics covered (from the chapter list)
- Database changes and how SQL projects can help
- Altering a view
- IntelliSense inside a SQL project (disconnected editing)
- Renaming a table (“new and improved” workflow)
- Reviewing the refactor log file
- Generating a publish script for the changes
- Using publish profiles to remember custom settings per environment
- Tips and tricks
Resources
- Refactor your database with SQL projects in VS Code: https://devblogs.microsoft.com/azure-sql/refactor-your-database-with-sql-projects-in-vs-code/
- SQL projects: https://aka.ms/sqlprojects