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

Create a technical support case if you need further support.

Migrating a local SQL database to a remote SQL server database from Apex One

    • Updated:
    • 19 Nov 2021
    • Product/Version:
    • Apex One 2019
    • Platform:
Summary

This article describes how to transfer a local SQL database of Apex One to an SQL server on a remote machine.

Details
Public

To move the SQL database:

  1. Turn off Firewall.
     
    This is optional. You may contact your Firewall Administrator if you encounter issues related to SQL connectivity.
     
  2. Turn on Network Discovery on both the local Apex One server machine and the target SQL machine. Make sure that the machines are connected.
  3. Use SQL Server Management Studio (SSMS) to back up the local Apex One SQL database to a backup file.
  4. Go to the target remote SQL server.
  5. Restore the backup file generated in Step 3 to a new database and set the file name. The database should now be on the remote SQL server.
  6. Go to the local Apex One server.
  7. Navigate to <Server installation folder>\PCCSRV\Admin\Utility\SQL, and run SQLTXFR.EXE.
  8. Specify the Server name as follows: <host name or IP address of the SQL Server>,<port_number> or <instance name>.
  9. Specify the database authentication of the remote SQL server.
     
    Make sure that the account has the required roles and permission. For more information, you can refer to Required permissions to migrate Apex One database using SQL migration tool.
     
  10. Set the database name to match the restored database name in the target remote SQL server.
  11. Click Test Connection to verify the authentication credentials of the remote SQL server.
  12. Click Start to apply the configuration changes.

If you encounter an issue when switching the database, please contact Trend Micro Technical Support.

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

Thank you for your feedback!


*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.