Geeks With Blogs
Paul Mehner blog

I had become so accustomed to modifying my stored procedures from within my Visual Studio environment with 2003 that I couldn’t imagine living without this feature. The first time that I tried adding a database project in Visual Studio 2005, I was surprised to see C# managed procedures, but no place to place TSQL. After adding my stored procedure creation scripts to the project, I was stunned to learn that I couldn't execute them like I could in Visual Sutdio 2003!

 

It turns out that I was too quck to jump to conclusions: the TSQL Database project is present under “Other Projects” and I simply had not probed far enough. If you add a database project from there it will support the execution of your scripts allowing you to keep your database stored procedure and table scripts fully in sync and under source code control!

Posted on Sunday, February 12, 2006 10:54 PM | Back to top


Comments on this post: Database Projects In Visual Studio 2005

# re: Database Projects In Visual Studio 2005
Requesting Gravatar...
Database Projects In Visual Studio 2005
Left by ebrahim on Aug 27, 2007 4:21 AM

# re: Database Projects In Visual Studio 2005
Requesting Gravatar...
Yes, thanks for bringing this post up to date. These project types were not included at the time of blog entry (Feb 12, 2006); as I recall, they were added with SP1 for VS 2005.
Left by Paul Mehner on Aug 27, 2007 8:19 AM

# re: Database Projects In Visual Studio 2005
Requesting Gravatar...
Hi, the same is for VS 2008 also.
you can try out.
Left by Ankit on May 18, 2008 10:05 AM

# re: Database Projects In Visual Studio 2005
Requesting Gravatar...
data base project in visualbasic 2005
Left by dilruk on May 29, 2008 10:22 PM

# re: Database Projects In Visual Studio 2005
Requesting Gravatar...
Hi, I want to know if its possible to display the output of an executed sql script file in a grid format (same as it displays in Management Studio) instead of the default text format.

Thanks
Left by Tadeu Braganza on Nov 25, 2008 8:26 PM

# re: Database Projects In Visual Studio 2005
Requesting Gravatar...
I would like to learn more about Database projects
Left by George on Feb 07, 2009 11:33 PM

# re: Database Projects In Visual Studio 2005
Requesting Gravatar...
SEND Software
Left by Hemanta Phukan on Aug 03, 2009 9:05 AM

Your comment:
 (will show your gravatar)


Copyright © Paul Mehner | Powered by: GeeksWithBlogs.net