Menu
With the upcoming release of Visual Studio 2012, are there project templates for managing SQL Server scripts?
i.e. I have tables, views, stored procedures that I want to store and maintain in TFS by including them in a database project which maintains scripts.
Looking at the RC version of 2012 I do not see this type of project template any more. Any workarounds or information on how to manage scripts?
458
You can use Visual Studio to create and update a local database file in SQL Server Express LocalDB. You can also create a database by executing Transact-SQL statements in the SQL Server Object Explorer tool window in Visual Studio.
Visual Studio installs SQL Server Express LocalDB on your machine as part of the Data storage and processing workload. This LocalDB instance is useful for developing data-connected applications quickly and easily.
The new SQL Server Data Tools should be installed with the RC out of the box. It should provide you the ability to connect to an existing DB via SQL Server Object Explorer (open in the "views" menu), as well as the ability to import an existing DB into a project, or create a new DB project. this link to MSDN gives a very thorough overview of how to use SSDT. Hope that helps!
EDIT: SQL Server projects are in File -> New -> Project -> Templates -> Other Languages -> SQL Server
101
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
