By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,467 Members | 1,308 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,467 IT Pros & Developers. It's quick & easy.

SQL Server Scripting Question

P: n/a
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
Jul 24 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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" <ab****@NOSPAMvanputer.comwrote in message
news:We******************************@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

Jul 25 '08 #2

P: n/a
On Jul 25, 8:15*am, "Dan Guzman" <guzma...@nospam-
online.sbcglobal.netwrote:
* *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.comwrote in message

news:We******************************@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).
Jul 25 '08 #3

P: n/a
That looks like what I want to do - thanks.

Andy Baker

"nidaar" <ni****@gmail.comwrote in message
news:dd**********************************@a6g2000p rm.googlegroups.com...
On Jul 25, 8:15 am, "Dan Guzman" <guzma...@nospam-
online.sbcglobal.netwrote:
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.comwrote in message

news:We******************************@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).
Jul 28 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.