SQL Server Scripting Question 
July 24th, 2008, 12:25 PM
| | |  SQL Server Scripting Question
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
|
July 25th, 2008, 12:25 PM
| | | Re: SQL Server Scripting Question
I found the option 'Script Triggers', which defaults to false, by Quote:
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.comwrote in message
news:WeKdnemAjNbK6RXVnZ2dnUVZ8tfinZ2d@posted.plusn et... Quote:
>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
>
>
| |
July 25th, 2008, 02:05 PM
| | | Re: SQL Server Scripting Question
On Jul 25, 8:15*am, "Dan Guzman" <guzma...@nospam-
online.sbcglobal.netwrote: Quote: Quote:
* *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:WeKdnemAjNbK6RXVnZ2dnUVZ8tfinZ2d@posted.plusn et...
>
>
> Quote:
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.
| > Quote: |
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). |
July 28th, 2008, 03:55 PM
| | | Re: SQL Server Scripting Question
That looks like what I want to do - thanks.
Andy Baker
"nidaar" <nidaar@gmail.comwrote in message
news:dd146617-ad32-4e00-b360-9450b7ad2ed7@a6g2000prm.googlegroups.com...
On Jul 25, 8:15 am, "Dan Guzman" <guzma...@nospam-
online.sbcglobal.netwrote: Quote: Quote:
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:WeKdnemAjNbK6RXVnZ2dnUVZ8tfinZ2d@posted.plusn et...
>
>
> Quote:
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.
| > Quote: |
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). |
| Thread Tools | Search this Thread | | | |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is Off | | |
| | | What is Bytes?
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 220,989 network members.
|
