SQL Server Developer Tools, or SSDT (code-named “Juneau”), represents Microsoft’s continued commitment to providing integrated tools for developers targeting Microsoft SQL Server. This Project system and its related features provide the tools to edit, compile, refactor and publish databases to specific versions of SQL Server and SQL Azure. In Juneau, there’s one database project for all versions of SQL Server, and it can include both Transact-SQL (T-SQL) scripts and code that defines SQL CLR objects.
A database development team would move to project-based development to enjoy the benefits that this type of development affords the team over developing against a shared live database, including:
- · Isolation of developer changes
- · Rich T-SQL editing support
- · Verification of source prior to deployment and enforcement of team coding standards through code analysis rules
- · Automated migration-script generation