Upgrade Desktop Engine (MSDE 2000) to standard edition 2005
While reading through books online I found that the supported upgrade for Desktop edition (MSDE) 2000 is to SQL Server 2005 workgroup and express edition.
I am looking at upgrading just the database that resides on Desktop edition (MSDE) 2000 to SQL Server standard edition 2005. Is that supported? I can uninstall MSDE 2.0 and install standard edition all I need is a way to upgrade the database tah use to reside on MSDE 2.0
[434 byte] By [
VivSas] at [2008-2-24]
This setup-based upgrade path is
not supported up through and including the June CTP. At RTM we will support setup-based upgrades from MSDE to SQL Server 2005.
You can attached the MSDE Databases to SQL Server 2005 and they will automatically be upgraded.
Dan
