Script Entire Database

7 Apr 2006 5:07 PM

Bill Cohagan

SQL Server Management Studio Express allows you to script a table or a view,
etc.; however I've not found a way to generate a script for the entire
database schema. What I want is a script that will reconstruct the entire
schema (not including the data.)

Is this possible with SSMS Express (or SSMS for that matter?)

Thanks,
Bill

8 Apr 2006 8:40 AM

Tibor Karaszi

With Management Studio, you right-click the database, All Tasks, and there you have it. I don't know
about SSMS Express.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

Show quote

"Bill Cohagan" <cohagan@nospam.nospam> wrote in message
news:e0zjSXmWGHA.3740@TK2MSFTNGP03.phx.gbl...
> SQL Server Management Studio Express allows you to script a table or a view,
> etc.; however I've not found a way to generate a script for the entire
> database schema. What I want is a script that will reconstruct the entire
> schema (not including the data.)
>
> Is this possible with SSMS Express (or SSMS for that matter?)
>
> Thanks,
> Bill
>
>

8 Apr 2006 10:45 AM

Andrea Montanari

hi Tibor,
Tibor Karaszi wrote:

> With Management Studio, you right-click the database, All Tasks, and
> there you have it. I don't know about SSMS Express.

with SSMSE is (fortunately) the same :D

--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

9 Apr 2006 4:06 AM

Bill Cohagan

Tibor/Andrea
Thanks. I was led astray by the "Script Database As..." item which of
course only scripts the top level, not the contained objects of the
database.

Regards,
Bill

Show quote

"Andrea Montanari" <andrea.sql***@virgilio.it> wrote in message
news:49pihfFpm1ovU1@individual.net...
> hi Tibor,
> Tibor Karaszi wrote:
>> With Management Studio, you right-click the database, All Tasks, and
>> there you have it. I don't know about SSMS Express.
>
> with SSMSE is (fortunately) the same :D
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
> DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> --------- remove DMO to reply
>

10 Apr 2006 2:56 AM

Wei Lu

Hi Bill,

Welcome to use MSDN Managed Newsgroup Support.

You may try to right-click the schema in Management Studio and click Script
schema as .

Hope this will be helpful!

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

12 Apr 2006 7:21 PM

Bill Cohagan

Unfortunately that is *exactly* what I was doing and of course it doesn't
provide the functionality I'm looking for. Instead (as pointed out by
Andrea) the solution is under "All Tasks.."

Show quote

"Wei Lu" <we***@online.microsoft.com> wrote in message
news:VGrXRpEXGHA.932@TK2MSFTNGXA01.phx.gbl...
> Hi Bill,
>
> Welcome to use MSDN Managed Newsgroup Support.
>
> You may try to right-click the schema in Management Studio and click
Script
> schema as .
>
> Hope this will be helpful!
>
> Sincerely,
>
> Wei Lu
> Microsoft Online Community Support
>
> ==================================================
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
>
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>