Upgrading SQL 2000 to SQL 2005

regsamp
regsamp used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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

Author

Commented:
I started looking at that but I did not see any mention of deprecated datatypes. Does that mean it is not an issue?
from 2000 to 2005 ?
no it is not an issue :)
Should you be charging more for IT Services?

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

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?
you are correct :)

Author

Commented:
Thank you :)
your very welcome Please award points :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial