Installing SQL 2005 Express on top of SQL 2000
I'm going to install the VS 2005 beta on one of my lab boxes here, and this machine already has SQL 2000 on it. What happens if I check to install SQL 2005 Express during the VS 2005 installation? Will it upgrade 2000 to 2005 or what?
I'm sure people has tried this out there, but if I don't get any response I'll just go ahead and try and see what happens :)
EDIT 1: Brilliant... Ok, first I installed VS 2005 and all the MSDN stuff, then I rebooted the machine and tried to add SQL 2005 Express. Problem is that it hung in the end (progress meter near 100%) and refused to finish. So I killed the setup process and had a look at the box. It looks like SQL 2005 was installed properly and everything. Just one thing I wonder now... and this sounds stupid maybe, but how do I know which database service I'm running against?? *confused*
EDIT 2: Ok, I'm almost there! I downloaded the SQL Server Express Books Online and I'm following the walkthrough to create a database app. To be cont.
EDIT 3: Right, I'm in! It was very easy once I got into it (as usual). 1) Install SQLExpress 2) Make sure SQLExpress service is started and you may also want to start the SQL Browser service and enable some of the other network protocols if you're not running locally only 3) Use your favourite SQL manager (like the server browser in VS 2005) and access the database instance by calling it .\SQLExpress or <computername>\SQLExpress.
*running off to try some of the new features*