Geek Answers Handbook

Integrate or link to a SQL Server Management Studio project using Visual Studio

While most of the work for my .NET projects is done in Visual Studio, I prefer working in SQL Server Management Studio [SSMS] (I am currently using the 2005 version) when editing stored procedures and other DB-related projects.

I just opened a ton of Windows query, passed my alter s and switched, but I recently discovered projects and solutions in SSMS and found them a great way to encapsulate multiple requests / scripts that are bound to the same project.

I tried to add an SSMS project to my Visual Studio 2010 solution, but it seems like this is not possible. I would like to include an SSMS project and / or a link to it from my VS 2010 solution so that everything is neatly grouped in one place. What a good way to do this?

+4
source share
1 answer

The answer depends on the type of scripts you are running.

If you are working with scripts that work with an SQL instance or database, you can add a new SQL Server database project to Visual Studio 2010. Then simply copy the scripts to the project. (SQL Server projects are included in Visual Studio 2010 Premium and Ultimate.)

Any elements of business intelligence are not supported (and not supported) in Visual Studio 2010.

+1
source

More articles:


All Articles