Visual Studio 2003 SQL 2000 issue

We have a small intranet site that functions as a Rolodex which resides in a SQL 2000 database and was created with Visual Studio .NET 2003 Enterprise Edition. We seldom make any updates to it and it has been up and running for years.
We have noticed that end of life support for Visual Studio .NET 2003 Enterprise in October. The question is should we upgrade our Visual Studio .NET 2003 Enterprise version to 2005 and our SQL 2000 database to 2005 just in-case we have any issues?
Is this possible without any conflicts or technical issues and what is the best way to do this? Any assistance offered would be greatly appreciated.
regsampAsked:
Who is Participating?
 
CodeCruiserCommented:
It is possible but will depend on your project.

One thing though, if you are upgrading, why not upgrade to the latest versions or previous to latest versions? Otherwise, you will be panicking and doing this exercise again in couple of years time.
0
 
Asim NazirCommented:
If you have all the code with you then it can be done by simply opening solution to latest/desired visual studio and going through the conversion wizard. Just in case you find any issues, they need to resolved manually.

I am not sure if Microsoft in also ending support for SQLServer or not but if this is the case then you can upgrade to a better version - latest the best.
0
 
regsampAuthor Commented:
So you can open a solution that was created in 2003 with the latest one and there will be a conversion window to do this? And it is fairly easy to go from SQL 2000 to a later issue?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
upgrading to 2005 does not worth the effort since you will have to buy extended support soon.  I would advise directly moving to 2012.
0
 
regsampAuthor Commented:
Okay Racimo. It looks like SQL 2000 support ended 4/19/13 so will have to upgrade to SQL 2005 or so too.
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
SQL 2005 SP4 support will expire in 2016.
0
 
regsampAuthor Commented:
I saw that. At least that will give us a little while.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.