April 25, 2009 at 11:15 am
Hello,
We used to migrate stored procedures from dev to prod servers in sql 2000. How do I migrate them in sql 2005? Please let me know.
Thank you,
SRK
April 25, 2009 at 11:37 am
Hello,
If you don’t already have scripts of your SPs then you can use a tool such as SSMS (SQL Server Management Studio) to generate them. (Preferably then store the scripts in a safe place e.g. Source Control). After which you can execute the scripts on your Production Server.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
April 25, 2009 at 12:06 pm
Shahrukh Khan (4/25/2009)
We used to migrate stored procedures from dev to prod servers in sql 2000. How do I migrate them in sql 2005?
Assuming you are talking about promoting code from a Development to a Production environment as opposed to migrating code I'm in full agreement with John.
Best practices say your code must be stored in a version control repository then you just apply the scripts to the environment where you want to compile the new version of the code. Please *always* take a timestamped backup of the code you are planning to replace.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.April 27, 2009 at 6:39 am
But, prior to attempting to run 2000 scripts on 2005, you need to be sure that they're compatible. Certain TSQL behaviors that worked in 2000 no longer work in 2005. I'd suggest running the Upgrade Advisor against your 2000 system to see if the procedures there have any issues. Then, you follow the advice listed above.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply