SQL Server Scripting Question

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Andy Baker
    #1

    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


    Tags: None
    • Dan Guzman
      #2
      Re: SQL Server Scripting Question

      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
      Dan Guzman Blog
      http://weblogs.sqlteam.com/dang/


      "Andy Baker" <abaker@NOSPAMv anputer.comwrot e in message
      news:WeKdnemAjN bK6RXVnZ2dnUVZ8 tfinZ2d@posted. plusnet...
      >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
      >
      >

        Comment

        • nidaar
          #3
          Re: SQL Server Scripting Question

          On Jul 25, 8:15 am, "Dan Guzman" <guzma...@nospa m-
          online.sbcgloba l.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...@NOSPAMv anputer.comwrot e in message
          >
          news:WeKdnemAjN bK6RXVnZ2dnUVZ8 tfinZ2d@posted. plusnet...
          >
          >
          >
          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.micros oft.com. It's an easy to use tool
          which can be used to recreate a database (both schema and/or data).

            Comment

            • Andy Baker
              #4
              Re: SQL Server Scripting Question

              That looks like what I want to do - thanks.

              Andy Baker

              "nidaar" <nidaar@gmail.c omwrote in message
              news:dd146617-ad32-4e00-b360-9450b7ad2ed7@a6 g2000prm.google groups.com...
              On Jul 25, 8:15 am, "Dan Guzman" <guzma...@nospa m-
              online.sbcgloba l.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...@NOSPAMv anputer.comwrot e in message
              >
              news:WeKdnemAjN bK6RXVnZ2dnUVZ8 tfinZ2d@posted. plusnet...
              >
              >
              >
              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.micros oft.com. It's an easy to use tool
              which can be used to recreate a database (both schema and/or data).


                Comment

                Previous template Next
                Working...