Moving MSDE to MSSQL
As the Aurea List Manager MSDE database grows, or as your performance requirements increase, you may need to migrate the data in Aurea List Manager's MSDE database to Microsoft SQL Server.
These instructions show how to do so when installing MS SQL on the same machine currently used by Aurea List Manager. If you are moving Aurea List Manager, follow the steps here: For more information refer to Moving ListManager on Windows (with MSDE).
Although Aurea List Manager may use Microsoft SQL, Aurea List Manager does not support the Microsoft SQL database itself. These instructions are provided for the convenience of those using Aurea List Manager with Microsoft SQL. They are not a substitute for Microsoft's documentation.
Uninstalling MSDE and Installing MSSQL>
- Shut down Aurea List Manager.
- Open a command prompt.
- Detach the Aurea List Manager database by entering the following at the command prompt:
osql -S localhost -E sp_detach_db ListManager go
- Use the service manager to stop MSDE.
- Copy the following files to another location:
C:\Program Files\Microsoft SQL Server\MSSQL\Data\ListManager_Data.MDF
C:\Program Files\Microsoft SQL Server\MSSQL\Data\ListManager_Log.LDF
C:\Program Files\ListManager\lmcfg.txt
Note
The first two files are a backup of your Aurea List Manager database. The third file contains information Aurea List Manager uses to connect to the database.
Be sure you have backup copies of these files in another location; if they are lost or corrupted, you cannot restore your Aurea List Manager database.
- Uninstall Aurea List Manager and MSDE (Microsoft SQL Server Desktop Engine) using the Windows Add or Remove Programs utility (Start > Control Panel > Add or Remove Programs).
- Install Microsoft SQL server (or at a minimum, the Client Network Tools) on the Aurea List Managerserver.
- On the SQL server, create an initial database to be used for installation. This database is to be used for installation purposes only.
- Download Aurea List Manager for MSSQL
- When prompted by the installer to specify the type of installation, select New Install.
- Proceed with the installation as prompted, specifying the database you created.
- Shut down Aurea List Manager if you started it after the installation.
- Attach the Aurea List Manager database backup files using SQL Server Enterprise Manager:
- Right-click on Databases.
- Click All Tasks.
- Click Attach Database.
- Specify the path where you copied Aurea List Manager_Data.MDF (For example C:\Program Files\Microsoft SQL Server\MSSQL\Data\ListManager_Data.MDF)
- By default, the database is attached as Aurea List Manager change the database name in Attach as: if desired.
- Specify the database owner. You may need to create an owner through the Security option in Enterprise Manager.
- Click OK to attach the database.
For MSSQL 2000
- Right-click on Databases.
- Click All Tasks.
- Click Attach Database
- Specify the path where you copied Aurea List Manager_Data.MDF (For example C:\Program Files\Microsoft SQL Server\MSSQL\Data\ListManager_Data.MDF)
- By default, the database is attached as Aurea List Manager change the database name in Attach as: if desired.
- Specify the database owner. You may need to create an owner through the Security option in Enterprise Manager.
- Click OK to attach the database.
For MSSQL 2005:
- Copy the MDF and LDF file into the MSSQL database directory. By default : C:\Program Files\Microsoft SQL Server\MSSQL\Data
- Right-click on databases and choose Attach.
- Then click the Add button and choose the MDF file of the old database.
- Under the database details, edit the current file path by clicking the ... button.
- Edit the path to match the new file directory where the MDF is now located (where we copied it to).
- Click OK to attach the database.
- Copy the lmcfg.txt file created before deleting the original Aurea List Manager installation to C:/Program Files/Aurea List Manager, overwriting the copy of lmcfg.txt created by Aurea List Manager during installation.
- Open the lmcfg.txt file using a plain-text editor such as Notepad and edit it to use the database name, owner, and password you specified when you attached the Aurea List Manager database using SQL Server Enterprise Manager. Save.
- Open a command prompt and change to the Aurea List Manager directory.
- If upgrading Aurea List Manager, run the following command to upgrade the database: lm dbupgrade
Note
Upgrading the database may take several hours, depending on the size of your data.
- Start Aurea List Manager and the Aurea List Manager web server.