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 |
|
citrixnl
Starting Member
1 Post |
 Posted - 2004-11-01 : 17:06:24
|
| I have an existing SQL 7 Database server and a new SQL 7 Database server with the exact same computer name. On the original SQL 7 server there are two customer databases and further the original default installed databases (master). I did a backup of the customer databases in two steps, Full Backup and Transaction Log Backup. And on the new server i restored both. All the data is migrated now. But on the old server there are a lot of stored procedures needed to edit the database with the client.Is there an easy way to backup and restore the Stored Procedures from the old server to the new Server ? |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-11-01 : 17:28:45
|
| If they are in the same database (which you backup'd and restore'd) then they will be there.Kristen |
 |
|
|
|
|
|
Backup Stored Procedures