Summary

This chapter began with a high-level overview describing the many challenges developers face working with databases during the development process. Through hands-on exercises, you then saw how the new SQL Server Data Tools (SSDT) provides features that can help you tackle those challenges.

You worked through a number of scenarios using SSDT for connected development, offline development with the local database runtime (LocalDB), source control, debugging, and testing—and then deployed to a local environment as well as the cloud—all from within Visual Studio. Along the way, you learned how to use many important SSDT features, such as schema compare, refactoring, snapshot versioning, and multi-platform targeting. Although you can always learn ...

Get Programming Microsoft® SQL Server® 2012 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.