SQL Server 2000 and 2005 Compatibility

Question

Hi all,

Im an SQL Server Developer.....

Can anyone give me a good link which has the compatibility stuff among SQL Server Versions SAY FOR e.g. like SQL 2000 & Sql 2005...in specific????

Thanks in Advance

Shaun

Answer 1

Hi Shaun,

I'm not exactly sure what you're looking for, so I'm going to suggest a few topics.  If these don't meet your needs, please provide additional details to help narrow this down a bit.

In Books Online, see

sp_dbcmptlevel (Transact-SQL).  

Look for the heading "Differences Between Earlier Compatibility Levels and Level 90" .  The table in this section lists specific compatibility differences between SQL Server 2000 (compatbility level 80) and SQL Server 2005 (level 90).

SQL Server 2005 Database Engine Backward Compatibility

Take a look at all four topics linked in this overview topic.

You might also want to consider using the Upgrade Advisor tool. See http://www.microsoft.com/downloads/details.aspx?familyid=451FBF81-AB07-4CCB-A18B-DA38F6BCF484&displaylang=en  for more details and the download link.

Regards,

Gail

 

Answer 2

Hi,

 The specified link is not found.
 Can you specify new link for the related to that topic.

Thanks.

Answer 3

Try this link for the SQL Server 2008 Upgrade Advisor:
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=802d0632-5de7-4efd-ae43-ebe3fc078886

---

Alan Brewer [MSFT] SQL Server Documentation Team This posting is provided "AS IS" with no warranties, and confers no rights.