Using the M3 DMP Migration Tool

The migration process starts with the M3 DMP Migration Tool. This tool performs the conversion of existing OP databases to ensure compatibility with M3 DMP MT services.

Complete these steps before installation:

  • You must ensure that all users sign out of the system.
  • Back up the existing OP database.
  • Locate and copy the DmpServer.ini filename from the currently installed OP M3 DMP service.
  • Verify the DmpServer.ini configuration. Open the filename in a text editor. Ensure that the filename contains these variables and corresponding values:
    • DBPREFIX
    • LPSSQLVersion
    • LPSSQLADMIN
    • LPSSQLCENTRAL
Note: The migration process is required one time. The database update requires less than 10 minutes and does not cause downtime.
  1. Open the M3Dmp On-Prem to Migration Tool.
  2. In Upload Dmp Server .ini file, specify this information:
    Select File
    Select the configuration file. Browse to select the verified DmpServer.ini filename.
  3. In Provision Database SQL Paths, specify this information:
    DB Name
    Specify a name for the new provision database. The database stores connection information and credentials, replacing the traditional .ini file usage.
    Note: If the provision database already exists in the SQL Database instance, it ignores the values in steps 4 and 5. This occurs if the process is repeated.
    DB Data
    Select the data file location. Specify the file path where the provision database data files (.mdf) are stored.
    DB Log
    Select the log file location. Specify the file path where the provision database log files (.ldf) are stored.
  4. In Connection, select Enter Connection Details or Enter Connection String. For Enter Connection Details, you must specify the SQL user name and password. For Enter Connection String, specify the SQL Server connection string.
  5. In Enter Connection Details, specify this information:
    Instance
    Specify the instance hosting the provision database.
    Login
    Specify the user account.
    Password
    Specify the password.
    Port
    Specify the port used.
  6. In Connection String, specify the SQL Server connection string with a user account that has sufficient privileges to create databases.
  7. Click Test Connection to verify SQL Server access. You must ensure the connection is successful before proceeding.
  8. After all inputs are validated, click Migrate to run the migration process.
    The system displays a success message if the migration completes without issues. If errors occur, use Show Logs to review details and troubleshoot.