|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
October 17th, 2003, 05:40 AM
|
||||
|
||||
|
restore problem
Hi,
I have created a SQL 2000 test system to test accounting software. When trying to do a restore of the accounting software the restore fails because in cannot find specific stored procedures. In order for the restore to work I think I will need to copy all the stored procedures from the live system into the test system before attempting the data restore. How can I export just the stored procedures from the live system into the test system? Is this possible? Thanks.
|
|
#2
October 17th, 2003, 05:50 AM
|
||||
|
||||
|
Enterprise manager -> Select database -> Right click -> All tasks -> Generate SQL script .. -> (select "Show all" and then choose the stored procedures you want to export)
|
|
#3
October 17th, 2003, 06:09 AM
|
||||
|
||||
|
Hi Pabloj,
Thanks for that. I chose all the stored procedures and the script was created successfully. How do I now import this into my test server? I tried just running the script in query analyzer on the test server but the stored procedures are not there. How do you get them into a specific db's stored procedure folder? Thanks.
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > restore problem |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
