SQL Server Scripting Question

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.

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

>
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.comwrote in message
>
news:WeKdnemAjNbK6RXVnZ2dnUVZ8tfinZ2d@posted.plusn et...
>
>
>>>
- Show quoted text -

>
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.comwrote in message
>
news:WeKdnemAjNbK6RXVnZ2dnUVZ8tfinZ2d@posted.plusn et...
>
>
>>>
- Show quoted text -