[lug] [OT] grabbing the schema from an MS-SQL server
gsexton at mhsoftware.com
Tue Jul 16 18:07:35 MDT 2002
Open SQL Enterprise Manager. Expand out your server, and click on the
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.
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