SQL 2000 Database Export as SQL Statement 2

[ermora]

I have a need of exporting/saving a database schema (this includes; tables, views, sp, etc) as a standard text file that is essentially SQL commands that would recreate the schema. I've been trying to figure out how to do this on MS SQL 2000.

I can do this same thing very easily in MySQL with it's export feature. Why is it so difficult in MS SQL?

Anyhow, if anyone could give me a hand, I'd appreciate it.

 

[bborissov]

You could:
Run Enterprise Manager, Right Click on the DataBase name and choose All Task. Then Select Generate SQL Script. Follow the wizard.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[ptheriault]

Right click on the database you want to script and select all tasks -> generate SQL script

- Paul
- Database performance looks fine, it must be the Network!

 

[ermora]

Excellent!

I guess you learn something new every day.

Thanks!