Generating Scripts

[jfradley]

I'm working with Visual Studio .NET. I've used the IDE to create my database tables and stored procedures. I want to generate a script that has all SQL statements to create all the tables and stored procedures. In SQL Server 7, all I had to do was right-click 'generate scripts'. But when using the Visual Studio .NET IDE I don't have that option. Any ideas?

 

[DLSQL]

Open up Enterprise Manager and drill down to your database and it will work just as before.

DL
MCDBA, MCSD, MCT, etc.

 

[jfradley]

I'm sorry, I failed to give this piece of info. I don't have all those SQL Server tools anymore. Those tools came with VB 6 for free. But they didn't work with SQL Server 2000. So, I'm just using the tools built into Visual Studio .NET. I don't have Enterprise Manager.

 

[JamesLean]

I have VS.NET and in the Server Explorer if I right-click on the DB or the individual object then I get a "Generate Create Script..." option.

Having said this, I also have all the SQL client tools installed so I don't know whether it is reliant on those to give it this functionality?

Why can't you just get the SQL client tools installed on your machine? If you need to do SQL admin stuff like this then it would probably be better to use the proper tools and have access to the full functionality.

--James

 

[jfradley]

What are these SQL Client tools? Did they come with Visual Studio .NET or did you have to purchase them seperately?

I actually see the 'Generate Script' option when I right-click the DB but it's always greyed out.

 

[JamesLean]

The client tools come with SQL Server and include Enterprise Manager and Query Analyzer among others. They are what you use to administer and manage SQL Server.

BTW, have you expanded the DB before right-clicking on it? When I first expanded the SQL Server in the list the option was greyed out - I had to drill down into the DB before the option became available.

--James

 

[jfradley]

I expanded it all the way and it was still greyed. I guess that functionality is not included with SQL Client.

Thanks for your help any ways.

 

[bigfoot]

You can load them from the sql server cd. They are called client tools.