To move the contents of the Apex One database to SQL server, use a standalone tool called SQLTxfr.exe. To use this tool, follow the document about Using the SQL Server Database Configuration Tool.
There are minimum required permissions before performing a database migration. Refer to this article for the list of 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 Apex One server to SQL database. Without this permission, importing the client logs to the SQL database will fail.
- db_owner - This allows Apex One 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 Apex One 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 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).