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 |
|
Kurmanc
Yak Posting Veteran
92 Posts |
 Posted - 2010-07-16 : 09:15:10
|
| HiI need to restore a database (db1) from a backup file (db2) but at the same time the procedures in db1 should not be overwritten by the procedures in db2. Is there a smooth solution for this? I know I could script the procedures from db1 one by one but that would take a long time since there are a lot of procedures.Any help would be appreciated,Regards |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-07-16 : 09:17:51
|
| You can script them all out from Management Studio with a few clicks. Right-click and choose Tasks->Generate Scripts. The wizard will walk you through the rest. |
 |
|
|
Kurmanc
Yak Posting Veteran
92 Posts |
Posted - 2010-07-16 : 09:26:01
|
| robvolkThanks a lot! :) |
|
|
|
|
|
|
Restore db, keep old procedures