Products Affected

All ELM Products 5.5 and 6.5

Issue

Need to move the ELM Database(s) to a different SQL server.

General Observations

  • An ELM database from an earlier version of SQL can be moved to a newer version of SQL.

Procedure

Use Microsoft’s SQL detach and attach method.

  1. On the ELM Server, Stop all ELM services
  2. Detach the ELM database
    ◦In SQL Server Management Studio, connect to the instance of the SQL Server Database Engine and then expand the instance.
    ◦Expand Databases, and select the name of the ELM database you want to detach.
    ◦Right-click the database name, point to Tasks, and then click Detach. The Detach Database dialog box appears.
    ◦The Databases to detach grid displays the name of the selected database in the Database Name column. Verify that this is the database you want to detach.
    ◦Before you can detach the database, you must disconnect any active connections by selecting the Drop Connections check box.
    ◦When you are ready to detach the database, click OK.
  3. Copy the physical database files over to the new server
    ◦In ELM 5.5 and ELM 6.0, the physical files will have the same name as the database and have file extensions of .mdf, .ldf
    ◦In ELM 6.5, there are multiple physical files to copy over. All of the files start with the name of the database and have file extensions of .mdf, .ldf, and .ndf.
    Note:In SQL Server Management Studio, go to the Properties of the ELM database|Files page to find the path to the physical files.
  4. Attach the ELM database
    ◦In SQL Server Management Studio, connect to the instance of the SQL Server Database Engine and then expand the instance.
    ◦Right-click Databases and click Attach.
    ◦In the Attach Databases dialog box, to specify the database to be attached, click Add; and in the Locate Database Files dialog box, select the disk drive where the database resides and expand the directory tree to find and select the .mdf file of the database.
    ◦When you are ready to attach the database, click OK.
    Note: A newly attached database is not displayed in the Databases node of Object Explorer until the view is refreshed. To refresh the view at any time, click in Object Explorer, and then click Refresh on the View menu.
  5. Walk through the DB Wizard for ELM located on the Database tab on the ELM Server service
  6. On the ELM Server, Start all ELM services

Revision: 1.0

Last Modified:  9/21/2011

Last Reviewed: 9/21/2011

Article Type:  Informational