SQL Server Data Tools

Q: How deeply does 100 SQL Server Mistakes and How to Avoid Them cover SQL Server Data Tools?

Introduces SSDT and schema comparison, but does not detail installation, project structure, or deployment procedures.

As explained in 100 SQL Server Mistakes and How to Avoid Them

SQL Server Data Tools is Microsoft's Visual Studio tooling for developing and managing SQL Server data solutions.

SQL Server Data Tools (SSDT) extends SQL Server development beyond SQL Server Management Studio (SSMS). It supports advanced T-SQL work through Visual Studio and the SQL Server Database Project template. section 7.0

Avoid treating database backups and handcrafted deployment scripts as a complete source-control and deployment strategy:

Keep T-SQL code in a source-control repository to preserve version history, enable rollback, and support multiple developers. section 7.0 section 7.7
Use Visual Studio Database Projects for built-in SQL schema comparison, then use SSDT Schema Compare to understand changes and affected functionality before deployment. section 7.7
Treat SSDT as part of a modern development and deployment workflow rather than a replacement for understanding deployment impact. section 7.0 section 7.7

How 100 SQL Server Mistakes and How to Avoid Them covers it

Cover of 100 SQL Server Mistakes and How to Avoid Them

liveBook manning.com

Read 100 SQL Server Mistakes and How to Avoid Them on liveBook Get the book at manning.com

Related concepts

schema compareimplements · Schema Compare is a database-development tool that compares database schemas and identifies or generates changes needed to synchronize them.
SQL Server Database Projectalternative to · A SQL Server Database Project is a Visual Studio project template for developing, validating, versioning, and publishing SQL Server database objects.

This explainer was generated by Manning's knowledge graph from the text of 100 SQL Server Mistakes and How to Avoid Them. The section links point to the parts of the book it draws on.