SQL Server Data Tools help with the deployment
Change the development flow from scripts to develop-compile-publish like OOO languages in an IDE.
The project name is the default database name for the debug and publish databases
Development Sequence
- Create and Edit objects
- Add data using post deployment scripts
- Verify no DDL errors
- Deploy to the debug database (F5)
- Publish to test and production databases
Rogge Heflin 