Unanswered: [help] Upgrade from MSDE to SQL Server 2000
I am planning an upgrade from MSDE to SQL Server 2000 for the instance of a Mini SAP R/3 system (a scaled-down version of SAP for development).
MSDE is installed by default during the installation of Mini SAP. I'd like to upgrade MSDE to a full SQL Server with more manageability.
This involves migrating existing SAP databases from MSDE to SQL Server 2000. As you may know, all SAP databases are huge and complex.
Before migrating MSDE to SQL Server, how much impact should I expect on the existing databases and the SAP system and what are the rollback procedure that should be followed if the migration fails?