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

Create a technical support case if you need further support.

Migrating OfficeScan server database to an SQL Server

    • Updated:
    • 2 Nov 2021
    • Product/Version:
    • Apex One
    • Apex One
    • Apex One All
    • OfficeScan 11.0
    • OfficeScan 11.0
    • OfficeScan XG
    • OfficeScan XG
    • Platform:
    • Windows 2003 Enterprise
    • Windows 2003 Standard
    • Windows 2008 Enterprise
    • Windows 2008 Standard

The OfficeScan server uses an internal database to store OfficeScan client configuration, logs, and information. In certain environments, centralized database storage may be required, which involves a full-blown relational database server, such as Microsoft SQL Server.

You want to know if it is possible to migrate the OfficeScan internal database to a full-blown SQL database server.


By default, OfficeScan 11.0 and XG use Codebase (same as the previous versions) to store OfficeScan agent configuration, logs, and information. This is recommended for small to mid-sized deployments in maintaining an all-in-one OfficeScan server to minimize the cost and administrative efforts. Using or migrating to SQL database should be considered due to the following reasons:

  • Higher reliability, security, and performance is required.
  • Database corruption issues may occur when using Codebase database.
  • You can take advantage of SQL database backups such as full backups and incremental backups.
  • There is a necessity to have a centralized database for multiple OfficeScan servers that can be managed by the SQL DB administrator.
    Each OfficeScan server will be using one instance inside the SQL database.

To move the contents of the OfficeScan database to SQL server, use a standalone tool called sqltxfr.exe. To use this tool, follow the document about using the SQL Server Migration Tool.

Before making any changes, back up the HTTPDB database folder from one local disk to another. Follow this article: Disaster Recovery-Files to back up before upgrading, migrating, or uninstalling the OfficeScan server.

After migrating to the SQL server, go to Administration > Settings > Database Backup to check if you are running on an SQL Server.

SQL server

If you want to move from one SQL server to another SQL server using the sqltxfr tool, the bulkadmin, dbcreate, and db_owner roles are the minimum required permissions.

After migration, the dbcreator permission can be removed from the account privilege. However, the following permissions should be retained:

  • bulkadmin - This handles the log transfer from the OfficeScan server to SQL database. Without this permission, importing the client logs to the SQL database will fail.
  • db_owner - This allows OfficeScan to modify the tables within the database.

In addition, the user roles below should be kept in the account privilege. Removing these user roles causes OfficeScan Master server to fail.

  • logon as a service
  • logon as a batch job
  • Log on locally

When you change the account name or password after the SQL database migration, you can update the account credentials using the Switching to an existing database option from the SQLtxfr.exe tool. This tool will help you modify the account credentials even when the account name and password are already encrypted in a configuration file.


Passwords must meet the following minimum strength requirements:

  • Minimum length: 8 characters
  • Must contain at least 3 of the following:
    • Uppercase letters: A - Z
    • Lowercase letters: a - z
    • Numbers: 0 - 9
    • Special characters: !@#$^*?_~-();.+:

    Please avoid using special characters not listed here (e.g language special Turkish characters).

Configure; Migrate
Solution Id:
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.