Changing the Database to SQL Server

This section describes the method for changing the database of this software from SQLite to SQL Server.
A tool is used to change from SQLite to SQL Server.
IMPORTANT
Configure the required settings in SQL Server before changing the database. For details, see the following.
Configuring SQL Server
1.
Log on to the computer where the Manager is installed as a user with administrator privileges.
2.
Start the tool.
Double-click the following file.
%ProgramFiles%\Canon\EMC\Manager\SQLite2SqlServerGui.exe
3.
Enter the information of the SQL Server to change to.
Enter [Server Name] and [Instance Name].
Select [Authentication Mode].
If you selected [SQL Server Authentication], enter the user name and password used by this software to connect to SQL Server.
4.
Click [Connect].
5.
Click [OK].
NOTE
If you change the database, the "ManagementConsoleService.exe.config" file before changing the database is renamed to "ManagementConsoleService.exe.config.sqlite".
The content of the "ManagementConsoleService.exe.config.sqlite" file can be copied to the "ManagementConsoleService.exe.config" file to restore this software to the state before the database was changed. When copying the content of the file, stop the following services of this software.
Canon Management Console Manager
After copying the content of the file, start the services to restore this software to the state before the database was changed.