470,631 Members | 1,572 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,631 developers. It's quick & easy.

Cannot use Server Explorer to produce Create/Change Scripts

I am using Visual Studio.NET 2003 Enterprise Architect Edition
(according to my IT guy... how do I actually check what version of it I
am using?) and SQL Server Developer Edition (8.00.194 for you who
care).

In the documentation it says:
To generate create scripts
1. In Server Explorer, right-click the database object for which you
want to generate create scripts. This might be the entire database, a
specific table, stored procedure, or user-defined function.

2. Choose Generate Create Script on the shortcut menu.

That item, Generate Create Script does not exist in my menu. It's not
greyed out either, it just doesn't exist.

Moreover, it also says:

Note You must be using SQL Server 7.0 or SQL Server 2000 to generate
create scripts. To use this feature you must also install the client
tools for SQL Server on the same machine as Visual Studio .NET.

I read somewhere else that this might not be the case - in fact you
would need Enterprise Architect to be able to do this - is this so?

I find it difficult to find information about this topic. Searched KB
on microsoft.com, couldn't find anything that related to:

1. Having the correct versions of the software
2. Not being able to perform any action related to Database Projects

This is very frustrating - surely someone else than me must have had
this problem - or am I just exceptionally stupid?

My questions in point-form:

1. How do I check what version of Visual Studio.NET I have? The about
box only tells me the version number, I want to know if this really is
Enterprise Architect.

2. How do I get this to work? What I want to do is to create a Create
Script for an existing database. Everything else is working normally,
this is an existing project and database, complete with working web etc
on my machine - nothing, I repeat nothing, is out of the ordinary
except for the fact that things that should be "click this button" are
far from it - the button is not there... So, if I have the correct
versions of the software involved etc - what could my problem be?

Cheers,
Tommie

Apr 6 '06 #1
0 1345

This discussion thread is closed

Replies have been disabled for this discussion.

By using this site, you agree to our Privacy Policy and Terms of Use.