Using SQL Server Enterprise Manager,
how do I export a database schema?
Thanks.
JoeDz wrote:
> Using SQL Server Enterprise Manager,
> how do I export a database schema?
> Thanks.
Right Click Database - All Tasks - Generate SQL Scripts - Click Show
All - Click Script All Objects (or the ones you want) - Under Formatting
Tab check CREATE / DROP / and possibly Dependent Objects if you're not
selecting everything - Under Options Tab click Script Indexes / Triggers
/ Database (if needed) / users (if needed), etc.
Select file format ANSI or UNICODE
Click OK.
David Gugick
Imceda Software
www.imceda.com
No comments:
Post a Comment