SQL Script to Create DB Schema

SQL Script to Create DB Schema

Post by James A. S » Sat, 14 Feb 2004 05:02:35


How can I export a database schema to a script
that can be run on another server that will
recreate the database schema?

-- James
 
 
 

SQL Script to Create DB Schema

Post by Geoff N.Hi » Sat, 14 Feb 2004 05:10:28

From Enterprise Mangler, right click on the Database, select All Tasks...
Generate SQL Script.

Make sure you pick your options carefully so you get everything you want.

Also, no need to cross-post to the universe.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org