Can't Find "DataBase Project"

This article:

To create a database project
From the File menu, click New Project.
Expand the Other Projects folder, and click Database Projects.
Under Templates click Database Project.
Enter the name for your new project and select a directory location.
Choose either Add to Solution (to add the database project to the currently open solution), or Create New Solution, and click OK.

In my VS2005, Under File>New Project>"Other Project Types"
I see only
>  Setup and Deployment
>  Extensibility
>  Visual Studio Solutions

I've got

Microsoft Visual Studio 2005, Version 8.0.50727.42  (RTM.050727-4200), Microsoft .NET Framework Version 2.0.50727

What do I need to do to get at and use Database Projects in my VS implementation?

Any help with this would be appreciated.


Who is Participating?
Shakti109Connect With a Mentor Commented:

This has to do with the version of Visual studio you are working with.

To see a list of versions of the studio and their features check out the following link :

The database project designer is part of the Professional Version of VS2005 and not others (such as standard).

Also, when you install the SQL 2005 management studio, this will also add things to your Visual Studio interface (business intellegence designer and others).
Carl TawnConnect With a Mentor Systems and Integration DeveloperCommented:
Which Edition of VS2005 are you using ?
codequestAuthor Commented:
Thanks for inputs.

Ah, I'm using VS Standard, and using SQL Express (and Management Studio Express)

Any workarounds?
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

codequestAuthor Commented:
Purpose for wanting Database Project....I was trailing a thread on creating User Defined Types;  was investigating the possibility of using Alias data types.
codequestAuthor Commented:
Work with Database Projects
 Yes  Pro
 No  Std
Open or Debug SQL CLR Database Objects
 Yes   Pro
 No    Std
 Run Database Objects
 Yes  Pro
 Yes Std

Does this mean I'm unable to revel in the joys of SQL CLR technology, with my pitiful copy of VS2005 Standard?   ;-)
(May be good news...since I'm over my head on learning curve already....)
codequestAuthor Commented:
(When I was trying to decide between Standard and Professional, the SQL CLR was the one thing I couldn't figure out....karma, I guess)
Shakti109Connect With a Mentor Commented:

Hehe, unfortunately there is no workaround that I know of that will get you the extended functionality of the (more expensive) other versions.

And yes, unfortunately, using the (less expensive) standard version will leave you out of the new and sometimes exciting world of SQL CLR objects. I say sometimes exciting because you can really cause all kinds of havoc by using custom components in an automated database project.

codequestAuthor Commented:
Thanks for the clear (CLR?) message.  Well, it probably IS good news, since as far as I can tell I'll can get all the functionality I need from within the app code anyway, no doubt saves me from creating the havoc you suggest is possible, and it takes away another rationale for putting off the actual coding... :0)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.