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,
LorenzoIn 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|||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
