Overview

You would like to move your Lyris LM data from its existing database to a new database without upgrading the database or migrating or updating the Lyris LM application.

Prerequisites

• You have 2 database servers - "Existing DB" and "New DB" are used in this article to describe the migration from an Existing DB to a New DB
• You have administrative access to the database server

Solution

1. Stop the ListManager and ListManager Web services
   
   
2. Take a full backup of the Existing DB
   
   
3. On the New DB server, restore the Existing DB backup file
   
   
4. On the Lyris LM server, modify the lmcfg.txt file:

   $sql_server="NewDB";
   $sql_user="DBServiceAccount";
   $sql_password="xxxxxxxxx";

   Note: If the New DB uses the same SQL Username and Password as the Existing DB, sql_usr and sql_password do not need to be modified.
   
   

5. Start the ListManager and ListManager Web services

Lyris LM starts normally using the New DB after making these changes.