How to transfer Stored Procedures

[paulray]

Creating a new SQL2000 server. Maybe I'm missing something, but how do I transfer Stored Procedures from SQL7 production server? Everything seems to transfer except the SP.
Thanks

 

[ecobb]

When you say "Transfer", what exactly is it you're trying to do? Are you taking your entire database and moving it to a new server (with data, procedures, triggers, and all)? Are you creating a duplicate of the database with no data? Are you trying to transfer procedures only without the rest of the database?

If you're trying to get everything, I would suggest doing a complete backup of your database and then restoring that backup on the new server. If you don't want all of the data, just script the database and procedures and run the script on the new server to create a replica of the database without any data. If you only need the procedures, you can just script procedures only.


Hope This Helps!

Ecobb

"Alright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer." - Homer Simpson