Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
usernamed
Starting Member
2 Posts |
 Posted - 2006-04-05 : 07:23:58
|
| I have a large DB with 200+ stored procedures in. I need to move the stored procedures from one instance of SQL Server to another. How can I get the Stored Procedures from one SQL Server instance to another, and have them automatically associated with the correct DB? |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-04-05 : 07:26:35
|
| Script them from the Source Database, and execute the script on the Target Database?Kristen |
 |
|
|
usernamed
Starting Member
2 Posts |
Posted - 2006-04-05 : 07:33:40
|
| Can you script from one instance to another? (I've only had to work with single DB's before) |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-04-05 : 08:15:02
|
| Its not so much "to another" as just generating a script from a "source database" and then executing that script on [any] "target database"Kristen |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-04-05 : 09:24:26
|
| Make use of Generate SQL Script feature from Enterprise ManagerMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Bulk move of Stored Procedures