I have an SQL Server 2005 database that is populated with a customer's data.
I want to create a new database, in exactly the same format, so that I can
set up a system for a potential new customer to start converting his data.
Initially I want to create a 'blank' database, so I went into SQL Server
Management Studio - Databases. Right-click on database name and click
Tasks - Generate Scripts. I selected 'Script all objects in Selected
Database' and then Finish. I got the script as exepected, but when I
executed it I got no database triggers.
I found the option 'Script Triggers', which defaults to false, by
clicking Next instead of Finish straight away, so there is no problem with
that but my question is - what about the other options such as 'Vardecimal',
'Full-Text Indexes', 'Extended Properties', 'Collation'? I don't know
whether I need them or not - I just want to script the database exactly as
the existing (working) one is. Thanks in advance.

Andy Baker

> I found the option 'Script Triggers', which defaults to false, by
> clicking Next instead of Finish straight away, so there is no problem with
> that but my question is - what about the other options such as
> 'Vardecimal', 'Full-Text Indexes', 'Extended Properties', 'Collation'? I
> don't know whether I need them or not - I just want to script the database
> exactly as the existing (working) one is. Thanks in advance.

If you want to script an exact schema replica and the target is the same (or
greater) version and service pack, then you should select these options too.
Additional scripting options will make the scripts more verbose so you might
want to be selective depending on your environment and the purpose of the
script. For example, if you always use the same collation, you can omit the
collation option.

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"Andy Baker" <abaker@NOSPAMvanputer.com> wrote in message
news:WeKdnemAjNbK6RXVnZ2dnUVZ8tfinZ2d@posted.plusn et...
>I have an SQL Server 2005 database that is populated with a customer's
>data. I want to create a new database, in exactly the same format, so that
>I can set up a system for a potential new customer to start converting his
>data. Initially I want to create a 'blank' database, so I went into SQL
>Server Management Studio - Databases. Right-click on database name and
>click Tasks - Generate Scripts. I selected 'Script all objects in Selected
>Database' and then Finish. I got the script as exepected, but when I
>executed it I got no database triggers.
> I found the option 'Script Triggers', which defaults to false, by
> clicking Next instead of Finish straight away, so there is no problem with
> that but my question is - what about the other options such as
> 'Vardecimal', 'Full-Text Indexes', 'Extended Properties', 'Collation'? I
> don't know whether I need them or not - I just want to script the database
> exactly as the existing (working) one is. Thanks in advance.
>
> Andy Baker
>
>

On Jul 25, 8:15*am, "Dan Guzman" <guzma...@nospam-
online.sbcglobal.net> wrote:
> > * *I found the option 'Script Triggers', which defaults to false, by
> > clicking Next instead of Finish straight away, so there is no problem with
> > that but my question is - what about the other options such as
> > 'Vardecimal', 'Full-Text Indexes', 'Extended Properties', 'Collation'? I
> > don't know whether I need them or not - I just want to script the database
> > exactly as the existing (working) one is. Thanks in advance.
>
> If you want to script an exact schema replica and the target is the same (or
> greater) version and service pack, then you should select these options too.
> Additional scripting options will make the scripts more verbose so you might
> want to be selective depending on your environment and the purpose of the
> script. *For example, if you always use the same collation, you can omit the
> collation option.
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVPhttp://weblogs.sqlteam.com/dang/
>
> "Andy Baker" <aba...@NOSPAMvanputer.com> wrote in message
>
> news:WeKdnemAjNbK6RXVnZ2dnUVZ8tfinZ2d@posted.plusn et...
>
>
>
> >I have an SQL Server 2005 database that is populated with a customer's
> >data. I want to create a new database, in exactly the same format, so that
> >I can set up a system for a potential new customer to start converting his
> >data. Initially I want to create a 'blank' database, so I went into SQL
> >Server Management Studio - Databases. Right-click on database name and
> >click Tasks - Generate Scripts. I selected 'Script all objects in Selected
> >Database' and then Finish. I got the script as exepected, but when I
> >executed it I got no database triggers.
> > * *I found the option 'Script Triggers', which defaults to false, by
> > clicking Next instead of Finish straight away, so there is no problem with
> > that but my question is - what about the other options such as
> > 'Vardecimal', 'Full-Text Indexes', 'Extended Properties', 'Collation'? I
> > don't know whether I need them or not - I just want to script the database
> > exactly as the existing (working) one is. Thanks in advance.
>
> > Andy Baker- Hide quoted text -
>
> - Show quoted text -

You might also want to check the database publishing wizard, which can
be downloaded from download.microsoft.com. It's an easy to use tool
which can be used to recreate a database (both schema and/or data).

That looks like what I want to do - thanks.

Andy Baker

"nidaar" <nidaar@gmail.com> wrote in message
news:dd146617-ad32-4e00-b360-9450b7ad2ed7@a6g2000prm.googlegroups.com...
On Jul 25, 8:15 am, "Dan Guzman" <guzma...@nospam-
online.sbcglobal.net> wrote:
> > I found the option 'Script Triggers', which defaults to false, by
> > clicking Next instead of Finish straight away, so there is no problem
> > with
> > that but my question is - what about the other options such as
> > 'Vardecimal', 'Full-Text Indexes', 'Extended Properties', 'Collation'? I
> > don't know whether I need them or not - I just want to script the
> > database
> > exactly as the existing (working) one is. Thanks in advance.
>
> If you want to script an exact schema replica and the target is the same
> (or
> greater) version and service pack, then you should select these options
> too.
> Additional scripting options will make the scripts more verbose so you
> might
> want to be selective depending on your environment and the purpose of the
> script. For example, if you always use the same collation, you can omit
> the
> collation option.
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVPhttp://weblogs.sqlteam.com/dang/
>
> "Andy Baker" <aba...@NOSPAMvanputer.com> wrote in message
>
> news:WeKdnemAjNbK6RXVnZ2dnUVZ8tfinZ2d@posted.plusn et...
>
>
>
> >I have an SQL Server 2005 database that is populated with a customer's
> >data. I want to create a new database, in exactly the same format, so
> >that
> >I can set up a system for a potential new customer to start converting
> >his
> >data. Initially I want to create a 'blank' database, so I went into SQL
> >Server Management Studio - Databases. Right-click on database name and
> >click Tasks - Generate Scripts. I selected 'Script all objects in
> >Selected
> >Database' and then Finish. I got the script as exepected, but when I
> >executed it I got no database triggers.
> > I found the option 'Script Triggers', which defaults to false, by
> > clicking Next instead of Finish straight away, so there is no problem
> > with
> > that but my question is - what about the other options such as
> > 'Vardecimal', 'Full-Text Indexes', 'Extended Properties', 'Collation'? I
> > don't know whether I need them or not - I just want to script the
> > database
> > exactly as the existing (working) one is. Thanks in advance.
>
> > Andy Baker- Hide quoted text -
>
> - Show quoted text -

You might also want to check the database publishing wizard, which can
be downloaded from download.microsoft.com. It's an easy to use tool
which can be used to recreate a database (both schema and/or data).