February 15, 2006 at 11:12 am
I am currently using SQL 2000 for all web application databases and all are at level 80 except for one. This one database is still at version 65 due to the web application not functioning properly after we upgraded to 70 and then to 2000 (with sp3a). I would like to eventually upgrade to 2005, but don't have the resources to modify all existing stored procedures in this v65 database. My question is does SQL 2005 have backward compatibility to 65?
February 15, 2006 at 1:29 pm
AFAIK the only db-level for SQL2005 to support are 70, 80 and 90.
Try the SQL2005 Upgrade Advisor to check your database.
You may even want to download sqlserver 2005 express edition to test if the db would still work with the new db-engine but without the cost of a new version $$, or download the trial version (enterprise edition !)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 16, 2006 at 6:41 am
You must upgrade a 6.5 database to 7 or 2000 first.
Scott
February 16, 2006 at 11:04 am
Thanks for the information.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply