Upgrading the database engine

New features in Ipswitch WhatsUp Gold v12 mandate an update of the original database engine from Microsoft SQL Server 2000 Desktop Engine to SQL Server 2005 Express Edition. The WhatsUp Gold installation program will automatically upgrade the database engine, provided the database is in the default configuration. A default configuration is one that meets the following conditions:

• Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is installed on the same computer on which you are installing WhatsUp Gold.
• The instance name for the MSDE 2000 installation is WhatsUp.
• A WhatsUp database instance exists in this MSDE 2000 instance.
• A DSN named WhatsUp is configured to point to the WhatsUp database in this MSDE 2000 instance.

All other configurations are considered non-default configurations. The WhatsUp Gold installation program will notify you, during the installation, if you have a non-default configuration. This will necessitate a manual upgrade of the database schema before the WhatsUp Gold application will function correctly. If you prefer, you may also upgrade your database engine to SQL Server 2005 before upgrading the database schema.

Warning: An SQL Server 2005 Express Edition database cannot be imported to Microsoft SQL Server 2000. You may continue to use Microsoft SQL Server 2000 as your database engine, but only if you were already using it before upgrading to WhatsUp Gold v12. Beginning with WhatsUp Gold v12, users that want to move from the SQL Server 2005 Express Edition Database Engine must migrate to Microsoft SQL Server 2005. For more information, see Using an alternative database setup.