How To Migrate The Trend Micro Control Manager Database

Posted on by

IT Support Forum › Forums › Antivirus › Trend Micro › Control Manager › Installation › How To Migrate The Trend Micro Control Manager Database

Tagged: 

Viewing 5 reply threads
  • Author
    Posts
    • July 1, 2014 at 9:15 am #288
      Webmaster
      Keymaster

      If you’re decomissioning a SQL server, you might need to migrate the Trend Micro Control Manager database (db_ControlManager). To migrate the Trend Micro Control Manager database:

      1. Log onto the Trend Micro Control Manager server
      2. The database settings are actually stored in C:\Program Files (x86)\Trend Micro\COMMON\TMI, under the CFG_DM_DB_DSN setting. By default, this will point to a System DSN called ControlManager_Database. You don’t need to change the TMI.cfg file
      3. Click Start -> Control Panel -> Administrator Tools and launch Data Sources (ODBC)
      4. Click on the System DSN tab
      5. Select the ControlManager_Database DSN
      6. Click Configure…
      7. This will tell you where your Trend Micro Control Manager database is currently stored
      8. Stop the Trend Micro Control Manager services on the server
      9. Navigate to the SQL server and take a copy of the SQL database (either by backing it up or detaching it and copying the files)
      10. Navigate to the SQL server that you wish to migrate the Trend Micro Control Manager database to and restore or attach the database, depending on the copy method you used in the previous step
      11. Go back to the ODBC configuration on the Trend Micro Control Manager server
      12. Change the Server to the SQL server instance that you migrated the Trend Micro Control Manager database to
      13. Start the Trend Micro Control Manager services that you stopped
      14. Log onto the Trend Micro Control Manager website to make sure that everything is working and that the database has been successfully migrated

    • July 1, 2014 at 9:24 am #289
      Webmaster
      Keymaster

      If your TMI.cfg file specifies:

      CFG_DM_DB_DSN=Server=<>

      Then you need to change the parameter to the name of the new SQL server as well.

    • July 1, 2014 at 10:12 am #290
      Webmaster
      Keymaster

      It’s also best practice to run the Database Upgrade Adviser against the database you are migrating, if moving to a different version of SQL.

    • July 18, 2014 at 9:17 am #495
      McLovin
      Participant

      When I run the SQL 2008 R2 Upgrade Advisor prior to migrating the Trend Micro Control Manager database, I get Column Aliases In ORDER BY Claus Cannot Be Prefixed By Table Alias.

      Is it safe to continue migrating the database with this error?

    • July 18, 2014 at 11:09 am #499
      Webmaster
      Keymaster

      In that case, you can’t migrate the Trend Micro Control Manager database using the above method. According to Trend Micro Support, you need to do the following:

      1. Backup Trend Micro Control Manager
      2. Uninstall Trend Micro Control Manager
      3. Restore Trend Micro Control Manager
    • February 12, 2015 at 1:21 am #1058
      cw72
      Participant

      thank you

  • Author
    Posts
Viewing 5 reply threads
  • You must be logged in to reply to this topic.