Importing stored procedures to new database

• Goalie35

  SSC Eights!

  Points: 871

  More actions

  November 8, 2005 at 4:38 pm

  #188257

  I've created a bunch of stored procedures (about 100) for my application that are all located in the same database.

  Now however, I need to create a copy of all of these stored procedures so I can move them to our new database.

  Does Enterprise Manager have some sort of feature to allow me to import all of my stored procedures to this new database?

   

  Thanks in advance.

  -Goalie35 

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  November 8, 2005 at 5:27 pm

  #602932

  Script then out, then execute the script on the other database. You can also use the dts transfer objects wizard to do this.