Move SQL Databases to a new SQL Server

Move SQL Databases to a new SQL Server

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.


  1. 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.

  2. 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...
     
  3. Then it's just a matter of modifying the DB objects in webAdmin to point to the new server's address.
    1. Open webAdmin Dashboard.
    2. Expand Report Admin.
    3. Select the DB Object.
    4. Change the Server Address for the database.
    5. Click the Save button.

  4. You will then need to restart webNetwork for all the services to start up using the new DB server.
     
  5. 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
 

    Can't find the KB

    Unable to find the KB to address your issue ?  

      • Recent Articles

      • Lenovo Unified Workspace End-of-Life Questions and Answers

        Will the shutdown of LUW servers and access to downloads affect my server licensing? No, the shutdown of the customer servers and access to the product and licensing downloads will not affect your server licensing. This license is downloaded and ...

      • How do I determine my Unified Workspace license expiration date?

        The best method for determining the licensing information including the expiration date of your Unified Workspace license: Login to your 8090 management console on each server This may take remoting into each LUW server and relay, opening a browser, ...

      • Lenovo Unified Workspace 7.0.2.13 Released

        Highlights of Unified Workspace 7.0.2.13 Before you install: Please view the installation notes here. 7.0.2.13 requires a 7.0 license file. Below is a list of enhancements and fixes released in Unified Workspace 7.0.2.13 Fixed external storage ...

      • LanSchool Documentation Guides

        LanSchool Classic Teacher Console The LanSchool Teacher Console is the interface teachers will use to manage their classroom and students. It contains all the tools necessary for a teacher to effectively interact with students and create a ...

      • Lenovo Unified Workspace 7.0.1.41 Released

        Highlights of Unified Workspace 7.0.1.41 Before you install: Please view the installation notes here. 7.0.1.41 requires a 7.0 license file. Below is a list of enhancements and fixes for Unified Workspace 7.0.1.41 Updated Log4j Updated Java Updated ...

      • Related Articles

      • Move webNetwork to different server

        *** If you are moving to a different OS, please see : https://helpdesk.lenovosoftware.com/portal/kb/articles/migrate-webnetwork-to-windows-linux-22-8-2017 *** Keeping the same OS / version / IP As long as you are keeping the same OS/ version/IP then ...

      • Move database logging to SQL server.

        Changing / migrating the Logging Database from HSQL to MySQL , MSSQL. By default, the Stoneware Relay logs all transactions to a Java database called HyperSonic SQL. This database is installed as part of the portal installation and automatically ...

      • Move Unified Workspace to a new path

        Many customers have webNetwork / Unified Workspace (UW) installed in c:\stoneware which has been the default for many years. With 6.4.7.x the default has been changed to c:\UnifiedWorkspace. Some customers have asked how do I move c:\stoneware to ...

      • MS SQL Transaction Logs full

        MS SQL defaults to only truncating the transaction logs once the database and transaction log have been properly backed up. At that point the server will clean truncate and compact the log files.  Obviously, this requires having a backup system in ...

      • How to setup Analytics in dedicated SQL

        Problem:  Need to move Analytics database to a dedicated SQL server.  It is highly recommended you move this database to a separate dedicated SQL server on any production installations. Cause:  The included Hypersonic SQL (HSQL) is not designed for ...