Upgrading ASP.Net Intranet and SQL database

Our company runs an Intranet that functions as a rolodex. The database his SQL 2000 and the coding for the Intranet is mostly in ASP.Net that was created in Microsoft Visual Studio.net.
We are looking to move to a new server for the Intranet as the current one is eight years old.

Our question or issue is should we install a new SQL version (2008/2012) on the new replacement server or will the coding have a problem and we will have some conflicts? Do we need to update the ASP.Net coding and Studio version as well?

 What is the best way to go about transferring this data over to a new server without major glitches?
regsampAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Surendra NathTechnology LeadCommented:
My opinion

1) take a look at sharepoint and see if it solves your problem, if that is the case you stop all your asp.net intranet application and migrate to the new richer framework.

2) if sharepoint is out of option that upgrading every thing to the latest one will be the good choice.
regsampAuthor Commented:
1) I will look into sharepoint and see if it could meet our needs.

2) You don't think that upgrading to the newest version say SQL 2000 to SQL 2014 and Visual Studio 2003 to Visual Studio 2014 will have major glitches or conflicts?
Carl TawnSystems and Integration DeveloperCommented:
Are you upgrading purely because you want a newer, higher spec server, or are you planning to add features/rewrite any of your existing systems?

Newer versions of software will provide newer/better features, but upgrading to them just for the sake of it is a lot of effort for no real benefit. If you plan to update your systems, or need to improve performance, then upgrading to newer versions would be a good option.

Whether or not you'll have any issues upgrading will depend on whether or not you use any features that have been made obselete, or have been deprecated, in later versions.
Get Blueprints for Increased Customer Retention

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

regsampAuthor Commented:
We are upgrading purely to have a new server and that is the only reason. It is not that we are looking for newer features but just worried that our server is eight years old and we want a reliable platform for the Intranet to be on.  This is just a company rolodex that is an Intranet. It might even be that SharePoint could make it this obsolete. We are trying to see which direction we want to go and avoid any glitches if we upgrade.
Carl TawnSystems and Integration DeveloperCommented:
Then if it were me, i'd just look at upgrading the hardware and infrastructure. Moving to new versions of all of your software would be an unnecessary expense in my opinion.

The cost of SQL Server 2012 licences by themselves are going to set you back at least £2500. Plus there is no direct upgrade path from SQL 2000 to 2012, so you would have to go to 2005 or 2008R2 first as well.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
regsampAuthor Commented:
So you think that getting the new server, and just keep it SQL 2000 and the coding that was created all the same in Visual Studio 2003 would be the best if we are not adding new features and for cost reason?
Carl TawnSystems and Integration DeveloperCommented:
Pretty much. If you don't intend, or have a specific requirement, to use any of the features provided by the newer versions then you'd be spending time and money you don't really need to.
regsampAuthor Commented:
Okay, thank you for that. That is what I was thinking. I am just now considering the alternative of SharePoint. Thoughts?
Carl TawnSystems and Integration DeveloperCommented:
It depends on what you need really. Sharepoint provides a lot of functionality out of the box - document management, workflows, data lists, calendars, etc. And it provides a lot of flexibility in that you could create separate sites for different departments and allow them to control their own content, and control access at a granular level.

On the flipside, there would be a learning curve involved as you will need to configure and maintain it.

But as I said, it depends entirely on what services your current intranet provides and if Sharepoint can replicate them in a way that suits you.
regsampAuthor Commented:
Our Intranet now is a straight rolodex that brings up some client information, very little reporting and some permit information. Could that kind of information that is pulled from a SQL Database in your opinion be carried over into SharePoint?  

From everything I am reading it claims to offer database like performance and data retrieval but then again, this is new for us.
Carl TawnSystems and Integration DeveloperCommented:
You could recreate that in Sharepoint certainly, although Sharepoint deals with what it calls "lists" rather than directly exposing the database to you. From what you are describing I think Sharepoint would be overkill.

Although, if you can find a spare machine to try it on, it would be worth grabbing a copy of Sharepoint and having a play around. You may find there are a lot of features in there that you might want to use if you had them :)
regsampAuthor Commented:
Okay. Thank you so much for your input and opinion. I am going to contemplate the information and do a little more research. Thank you again.
Carl TawnSystems and Integration DeveloperCommented:
No problem. Good luck with your research.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.