[lug] [OT] grabbing the schema from an MS-SQL server

Sexton, George gsexton at mhsoftware.com
Tue Jul 16 18:07:35 MDT 2002

Open SQL Enterprise Manager. Expand out your server, and click on the
desired database.

on the MMC Menu, select Tools, Generate SQL Scripts... Click on the "Show
All" button, and then select "Script All Objects"

Give it a file name, and click OK.

-----Original Message-----
From: lug-admin at lug.boulder.co.us [mailto:lug-admin at lug.boulder.co.us]On
Behalf Of Hugh Brown
Sent: 16 July, 2002 5:33 PM
Subject: [lug] [OT] grabbing the schema from an MS-SQL server

I am sorry to post this here, but I am trying to coax SQL Server to give
me just a schema of all tables in a db and none of the data.

Google gets me lots of links on taking classes and buying books.

I want to do something similar to

mysqldump -d <dbname>

that would work with SQL Server.


Web Page:  http://lug.boulder.co.us
Mailing List: http://lists.lug.boulder.co.us/mailman/listinfo/lug
Join us on IRC: lug.boulder.co.us port=6667 channel=#colug

More information about the LUG mailing list