Solved

Upgrading SQL 2000 to SQL 2005

Posted on 2014-03-03
7
336 Views
Last Modified: 2014-03-03
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.
0
Comment
Question by:regsamp
  • 4
  • 3
7 Comments
 
LVL 22

Expert Comment

by:plusone3055
ID: 39900440
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
 

Author Comment

by:regsamp
ID: 39900470
I started looking at that but I did not see any mention of deprecated datatypes. Does that mean it is not an issue?
0
 
LVL 22

Accepted Solution

by:
plusone3055 earned 500 total points
ID: 39900525
from 2000 to 2005 ?
no it is not an issue :)
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 

Author Comment

by:regsamp
ID: 39900542
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
 
LVL 22

Expert Comment

by:plusone3055
ID: 39900547
you are correct :)
0
 

Author Comment

by:regsamp
ID: 39900556
Thank you :)
0
 
LVL 22

Expert Comment

by:plusone3055
ID: 39900559
your very welcome Please award points :)
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now