I just installed MSDE this weekend in order to start learning it. Is SQL Server 2005 Express an "upgrade" to MSDE, or are they two distinct programs which coexist with each other and can be installed side by side
Express 2005 is basically SQL 2005 with a 4Gb database limit and to enterprise services/replication etc.
It is not exactly an upgrade as a complete new version. If you are just wanting to learn sql then you can definetly do that with MSDE but if you are interested in the new features in 2005 then obviously you should install express. The two can (should) be able to live side by side. I have a SQL 2000 install running on the same box as 2005.
MSDE v. SQL Express 2005
BarendJ
It is not exactly an upgrade as a complete new version. If you are just wanting to learn sql then you can definetly do that with MSDE but if you are interested in the new features in 2005 then obviously you should install express. The two can (should) be able to live side by side. I have a SQL 2000 install running on the same box as 2005.