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 |
|
Blin
Starting Member
36 Posts |
 Posted - 2005-11-02 : 15:30:42
|
| I'd like to know what would be the best way of moving more than 300 stored procedures from one database to another database. The databases are in two different servers. Try to avoid using copy and paste since it would take long time to move 300+ stored procedures. Any input will be appreciated.Thanks. |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2005-11-02 : 15:34:27
|
| Generate scriptsDaniel, MCP, A+SQL Server DBAwww.dallasteam.com |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2005-11-03 : 09:34:16
|
quote:
Originally posted by X002548
Enterprise Manager>Right Click on the DB>All Tasks>Generate SQL ScriptBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
You can also CTRL-Click the ones you want and then Right Click>Generate SQL Script.  Daniel, MCP, A+SQL Server DBAwww.dallasteam.com |
|
|
|
|
|
|
Copying stored procedures