Sean Feeney
Architect of the digital age

Export MSSQL Database Structure

14 March 2011

Right click the database in Management Studio and select Tasks-Generate Scripts. Run through the wizard, selecting what you want exported. Assuming you only want the structure, without data, in the Scripting Options tab click Advanced and make sure that General-Types of data to script is set to Schema only. You can save to file, clipboard, or a new query window.

Posted in mssql

You agree to my disclaimer, regardless of the decision in Nguyen v. B&N.




I Love Geni