CODEWITHSUNDEEP
visual-studio-2015sql-server-2014sql-server-data-tools
Allan Xu
Allan Xu

Reputation: 9288

SSDT vs VS2015 Database Projects

Out of scope: Azure Database Development.

I am trying to decide between Visual Studio 2015 Database projects and SSDT.

I am using Visual Studio 2015 Database projects to develop and source control my SQL 2014 database application.

I understand that SSDT also provides a comprehensive and rich set of SQL database development features.

Which one of the VS15 DB Projects or SSDT are more powerful to developer SQL 2014 application.

I wish there was a comparison table that compares the two tools.

Conclusion

Based on the answers I understand that the two are very similar. Before this post, I was confused and I though they have a different set of capabilities, which is not correct.

Upvotes: 1

Views: 535

Answers (2)

David Atkinson
David Atkinson

Reputation: 5899

SSDT database projects and VS2015 database projects are the same. "SSDT" used by itself refers to all the SQL Server features and tooling in Visual Studio, database projects included.

It would be great if you could also describe what problem you're hoping to solve by asking this question.

Upvotes: 3

Brendan Duck
Brendan Duck

Reputation: 11

The two are not mutually exclusive, so you could always try SSDT and see if there are features you value and if they fit into your workflow?

I am working with SQL Server every day, and have SSDT installed (I also have the SSDT-BI tools installed as I often use SSIS). In my experience the standard SSDT tools are a poor man's SSMS, so I tend to do the majority of my database dev work in SSMS, syncing updates with a database project for version control and deployment script generation.

Upvotes: 1

Related Questions