Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

Migrating the Apex One DB from one MS SQL DB Server to another

    • Updated:
    • 29 Jul 2020
    • Product/Version:
    • Apex One All
    • Platform:
    • N/A
Summary

This article provides instructions for migrating a standalone Apex One database from one Microsoft SQL database server to another Microsoft SQL database server, using the following simulation:

Apex One ServerRDG-APEXONE
Old SQL DB ServerRDG-SQL
Old Apex One DB NameRDG-APEXONE-ApexOne
New SQL DB ServerRDG-APEXONE-2
New SQL DB InstanceREGAPEX
New Apex One DB NameRDG-APEXONE
Apex Central ServerRDG-APEXCENTRAL
Details
Public
  1. Log on to the Apex One server.
  2. Stop Apex One Services:
    • From Services:
      • Apex One Master Service
      • World Wide Web Publishing Services
      • Trend Micro Endpoint Sensor Service
    • From Application Pool:
      • Officescan_iATAS_AppPool
      • Officescan_iESConsole_AppPool

      Migrate Apex One MS SQL DB

  3. Create a full backup of the MS SQL DB of the Apex One server.
     
  4. In the current SQL DB server, set the Apex One DB as offline by executing “Take Offline” under Task.
     
    Use sa to perform the task.

    Migrate Apex One MS SQL DB

  5. In the new SQL DB, create a new database using the sa account.
     
    Note the instance and Database name. For this instance, the Database name is RDG-APEXONE and the instance name is REGAPEX.

    Migrate Apex One MS SQL DB

  6. Copy the backup of the Apex One DB in the backup folder of your MS SQL Server 2016.

    In this example, the directory of MS SQL 2016 backup folder is shown in the image below:

    Migrate Apex One MS SQL DB

    Migrate Apex One MS SQL DB

  7. Restore the backup of Apex One DB to the new SQL DB server.

    Below is an image of when the backup was restored:

    Migrate Apex One MS SQL DB

  8. Run the Apex One SQL Transfer on the Apex One Application server by going to <Server installation folder>\PCCSRV\Admin\Utility\SQL.

    Migrate Apex One MS SQL DB

  9. Run SqlTxfr.exe as administrator.

    Apex One SQL Server Database Configuration will appear.

  10. Note the following information of Apex One SQL Server Database Configuration:
    • Server name of the new SQL DB server
    • SA Account in the new SQL DB server and its password
    • Database Name in the new SQL DB server
     
    Server Namenew SQL DB server and DB instance where the new Apex One DB was restored
    Authentication TypeSQL Server Account
    Usernamesa of the new SQL DB server
    PasswordPassword for sa account of the new SQL DB server
    Database Namecreated database name in the new SQL DB Server

    Migrate Apex One MS SQL DB

  11. Click Test Connection to test the Apex One server connection to the new SQL Db server.
  12. Once completed, click Start to begin the migration of SQL DB Connection Settings.

    This will prompt to stop the Apex One services, as shown in the image below:

    Migrate Apex One MS SQL DB

  13. Click Yes to proceed.

    Migrate Apex One MS SQL DB

    Once completed, the Apex One Master Service in Apex One Server will start automatically.

  1. Log on to the Apex One server.
  2. Verify if Apex One Master Service is running in the services applet.
  3. Go to [Installation folder of Apex one]\Trend Micro\Apex One\PCCSRV\Private and open config.xml using an editor then look for the following info under DBServer and INI-DNE_ENGINE_SECTION:

    Server
    Database
    DBE_Engine

     
    1002 means SQL Server.

    Migrate Apex One MS SQL DB

  4. Log on to the web console.

    You will see a prompt for Apex Central in the Dashboard.

    Migrate Apex One MS SQL DB

Premium
Internal
Partner
Rating:
Category:
Migrate
Solution Id:
000240754
Feedback
Did this article help you?

Thank you for your feedback!

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.