|
Home > Archive > Microsoft SQL Server forum > September 2005 > Export Schema in SqlServer 2005
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Export Schema in SqlServer 2005
|
|
| lbolognini@gmail.com 2005-09-01, 3:23 am |
| Hi all,
sorry for the rather trivial question but I couldn't figure this out by
myself.
How do you export a db schema either from the commandline or from the
GUI (if I remember correctly it's called Management Studio in the new
version).
Thanks in advance,
Lorenzo
| |
| vjdileo 2005-09-01, 8:23 pm |
| In Enterprise Manager:
1) open the databases folder
2) highlight the database you want to generate a SQL script for
3) right-click and select "All Tasks..."
4) select "Generate SQL Script"
the "Generate SQL Script" window pops-up.
At this point, I usually just click on the "select all" button near the
top-right corner. You can select objects individually for scripting at
the bottom-left sectio of the window or, at the top-left section, you
can select "all tables", etc.
hth,
victor dileo
| |
| lbolognini@gmail.com 2005-09-01, 8:23 pm |
|
vjdileo wrote:
> In Enterprise Manager:
> 1) open the databases folder
> 2) highlight the database you want to generate a SQL script for
> 3) right-click and select "All Tasks..."
> 4) select "Generate SQL Script"
> the "Generate SQL Script" window pops-up.
Hi Victor,
thanks for your reply... guess that All Tasks didn't say anything good
to me! ;)
Lorenzo
|
|
|
|
|