Upgrading SQL 2000 to SQL 2005

We are looking to upgrade our Intranet database from Microsoft SQL 2000 to SQL 2005. We wanted to know if we have to worry about deprecated datatypes in our coding or that should not be an issue going from 2000 to 2005?

Any assistance offered would be greatly appreciated.
regsampAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
plusone3055Connect With a Mentor Commented:
from 2000 to 2005 ?
no it is not an issue :)
0
 
plusone3055Commented:
I think what you should do is have a look at microsofts Technet page. Here is a link to it. This will address any concerns that you have :)

http://technet.microsoft.com/en-us/library/ms144245(v=sql.90).aspx
0
 
regsampAuthor Commented:
I started looking at that but I did not see any mention of deprecated datatypes. Does that mean it is not an issue?
0
Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

 
regsampAuthor Commented:
Right. This is our Intranet database that has SQL, ASP.NET, VB.NET and some HTML written into it. We should not have any SQL deprecated datatypes when we upgrade just from SQL 2000 to SQL 2005 on the save server?
0
 
plusone3055Commented:
you are correct :)
0
 
regsampAuthor Commented:
Thank you :)
0
 
plusone3055Commented:
your very welcome Please award points :)
0
All Courses

From novice to tech pro — start learning today.