April 17, 2008 at 1:11 am
Hi,
We have three production servers running SQL 7.0 with hundreds of our own Stored Procedures. We want to upgrade these servers to SQL 2000 or SQL 2005. Are there any applications available in the market which will help us to upgrade and also indicate the SPs that will require changes.
Tks for your responses in advance
arsrini
April 17, 2008 at 9:05 am
I don't know about 2000, but 2005 has the SQL Upgrade Advisor tool which runs against the older DB and reports what things will need to be addressed for 2005. It may be downloadable free from Microsoft's site.
April 18, 2008 at 9:50 am
arsrini (4/17/2008)
Hi,We have three production servers running SQL 7.0 with hundreds of our own Stored Procedures. We want to upgrade these servers to SQL 2000 or SQL 2005. Are there any applications available in the market which will help us to upgrade and also indicate the SPs that will require changes.
arsrini
In addition to Mindy Hreczuck's response may I strongly recommend that you study the following:
http://msdn2.microsoft.com/en-us/library/ms178653.aspx
This link discusses and explains what compatibility levels are maintained as older revisions of SQL databases are moved to SQL 2005 and the effect of compatibility levels on various T-SQL actions and functions.. and last but not least how to change the compatibility level of the older revisions.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply