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?