Database Schema copy

18 Nov 2005 4:18 PM

Dave H

I want to a DB, and create an empty DB with the same schema. This was
preety easy with Enterprise Manager, how can I do it with the new suite?

20 Nov 2005 4:36 AM

mark sullivan

Using Management Studio, right click on the database name and select "Script
Database as".

Mark

Show quote

"Dave H" <DaveH@noemail.nospam> wrote in message
news:BZmdnbmZgJx5Y-DeRVn-tQ@comcast.com...
>I want to a DB, and create an empty DB with the same schema. This was
> preety easy with Enterprise Manager, how can I do it with the new suite?
>
>

21 Nov 2005 5:41 PM

Dave H

I want the whole schema, that only does the DBCreate?

--
Dave

Show quote

"mark sullivan" wrote:

> Using Management Studio, right click on the database name and select "Script
> Database as".
>
> Mark
>
>
> "Dave H" <DaveH@noemail.nospam> wrote in message
> news:BZmdnbmZgJx5Y-DeRVn-tQ@comcast.com...
> >I want to a DB, and create an empty DB with the same schema. This was
> > preety easy with Enterprise Manager, how can I do it with the new suite?
> >
> >
>
>
>

21 Nov 2005 6:58 PM

Rick Byham [MS]

Use the Generate Scripts Wizard: Right-click the database, point to Tasks,
and then click Generate Scripts.

--
Rick Byham
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.

Show quote

"Dave H" <Da***@discussions.microsoft.com> wrote in message
news:BBC90ED6-8824-4731-B29A-2B1F3A83B680@microsoft.com...
>I want the whole schema, that only does the DBCreate?
>
> --
> Dave
>
>
> "mark sullivan" wrote:
>
>> Using Management Studio, right click on the database name and select
>> "Script
>> Database as".
>>
>> Mark
>>
>>
>> "Dave H" <DaveH@noemail.nospam> wrote in message
>> news:BZmdnbmZgJx5Y-DeRVn-tQ@comcast.com...
>> >I want to a DB, and create an empty DB with the same schema. This was
>> > preety easy with Enterprise Manager, how can I do it with the new
>> > suite?
>> >
>> >
>>
>>
>>