Wednesday, March 21, 2012

Moving Stored Procedures in SQL 6.5 to 2000

Hi All

How do I export/copy the stored procdures I have on SQL Server 6.5 to my new SQL 2000 installation?

Are there any big (or small) differences I need to know about between the two installations with regard to Stored Procedures?

Many Thanks

TaddubThe easiest way would be to script them from 6.5, you are probably going to have to change a fair amount to get them to perform well.

-Euansql

No comments:

Post a Comment