SQL 2000 and SQL 2008 Express side by side?
This question was asked in relation to 2005 but haven't seen anything since 2000. We have a new app that needs to be launched in 2005 or better, but everything else we have is targeting the year 2000. We could upgrade, but that is currently out of budget.
We thought we could run SQL Server 2008 Express on the same server as 2000 in the amount of time it takes before upgrading.
Does anyone do this? Do you have a problem? Is it okay to continue?
Thank you in advance
On our development server we have many versions, for example: 2000, 2005 Express, 2005, 2008 Express, we didn't have any major problems.
You will need to install them as named instances when you go through the installation procedure, for example:
MyServer \ SQL2000 MyServer \ SQL2005Express MyServer \ SQL2005 etc.
I wouldn't advise running this many versions or instances in a production window, but 2 instances until you update your other apps to 2005 won't be a problem.
source to share
I have a server that runs both sql2000 and 2005 and I haven't had any problems - sql2005 starts a separate instance.
I see no problem with the sequel. The only problem I ran into is express express 2005, has no DTS / SSIS, so getting the data is cumbersome, but it has nothing to do with running both :-)
source to share