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. Using SQL Server

Log on to the computer where the Manager is installed as a user with administrator privileges.

Start the tool.

Double-click the following file.

%ProgramFiles%\Canon\EMC\Manager\SQLite2SqlServerGui.exe

Enter the information of the SQL Server to change to.

In [Database Name], select [Use the current database].

In [Server Name], enter the server name of SQL Server.

If SQL Server is installed a different computer to that of the Manager of this software, enter the IP address and port number of that computer.

Example: 192.168.100.200,1433

If SQL Server is installed in the same computer as the Manager of this software, enter 'localhost'.

Enter [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.

Click [Connect].

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.

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.

If necessary, delete the SQLite database files that are no longer required.

Delete the following files.

%ProgramFiles%\Canon\EMC\Manager\App_Data\managementconsole.db

IMPORTANT
If you delete "managementconsole.db", you can no longer restore this software to the state it was in before the database was changed.