Issue
Customer would like to move their UW SQL Databases from older hardware to new hardware.
Solution
The easiest method is to use the same SQL database type, as this only requires exporting/importing the existing database from the old server to the new server, then adjusting the server address UW uses to find the databases.
- Get the new DB server up and running. Then use your database tools to export the databases from the current server, and import it to the new one.
- Make sure the same userid/password is configured for the databases, with the same permissions.
This allows you to maintain all the current info, as well as get it all ready for the switch over. Obviously, if wait a super long period of time between the export/import and switch over, you would lose any info added to the databases during that time period...
- Then it's just a matter of modifying the DB objects in webAdmin to point to the new server's address.
- Open webAdmin Dashboard.
- Expand Report Admin.
- Select the DB Object.
- Change the Server Address for the database.
- Click the Save button.
- You will then need to restart webNetwork for all the services to start up using the new DB server.
- You will then want to run the Analytics Migration Wizard, to make sure the reports are all setup using the correct built in functions for your database type:
https://helpdesk.lenovosoftware.com/portal/kb/articles/running-analytics-migration-wizard-22-8-2017