Migrating WhatsUp Gold database files

Use the following procedures to migrate the WhatsUp Gold database from an instance of Microsoft SQL Server installed on the same computer as WhatsUp Gold to a local or remote instance of Microsoft SQL Server.

Migrate WhatsUp Gold databases:

1. Launch SQL Management Studio on the destination SQL Server, then log in using an account with sysadmin rights.
2. Restore the WhatsUp database by specifying the applicable .bak file generated previously.
3. Repeat the restore procedure for the NetFlow and NFArchive .bak files.
4. After all database backup files have been migrated, create a limited rights user account with dbo rights used to connect from the WhatsUp Gold application. The name and password of the new limited rights account created should match the limited rights account name used on the previous server initially. The password may be changed following migration and RemoteDBconfig execution in order to appropriate rehash the new limited rights user account password.

Update database connections:

1. For 32-bit and 64-bit servers, launch the 32-bit ODBC Data Source Administrator from the Windows Control Panel on the machine where WhatsUp Gold is installed. WhatsUp Gold uses the 32-bit ODBC System DSN Settings.
2. Under System DSN, select the WhatsUp DSN, then launch the configuration wizard.
3. Verify the SQL Server authentication information displayed is correct and proceed.
4. Enable the option for SQL Server to verify the authenticity of the login ID using SQL Server credentials as opposed to Windows authentication and proceed.
5. Change the default database to WhatsUp, or alternately your non-standard database name if you are not using WhatsUp, for the WhatsUp Gold database and proceed through the remainder of the configuration wizard.
6. Repeat the System DSN configuration procedure for the NetFlow and NFArchive databases. Again, if you are using non-standard database names in place of NetFlow and NFArchive, configure the System DSN to use the applicable database names.
7. Click Test Data Source to verify WhatsUp Gold uses the updated username and password for the database.

Finalize database migration:

1. Navigate to \Program Files (x86)\Ipswitch\WhatsUp on the WhatsUp Gold server.
2. Right-click RemoteDBConfig, then click Run as Administrator to launch the Database Connection dialog.
3. Select the new SQL Server instance from the Browse for Server drop-down menu.
4. Click the applicable radio button to enable Use SQL Server Authentication, then enter the SQL Server credentials used to access the database.
5. Click Connect.
6. Disable the option to Create backups for existing databases if you already have a valid backup, then click Continue to finish running the utility.
7. Navigate to \Program Files (x86)\Ipswitch\WhatsUp on the WhatsUp Gold server.
8. Right-click NMConfig, then click Run as Administrator to launch the Database Connection dialog.
9. Select the new SQL Server instance from the Browse for Server menu.
10. Enable the Use SQL Server Authentication option, then enter the SQL Server credentials used to access the database.
11. Click Connect.
12. When the utility has completed running, click Save.

Important: If you are using WhatsUp Gold to monitor applications with one or more iDrones (EUM Pollers), in addition to migrating your WhatsUp Gold database, you also need to update the iDroneService database location after migrating the other WhatsUp Gold database files. Please see Migrating the iDrone Service Database for additional information.

See Also Database and Application Migration Migrating WhatsUp Gold using a local database