Database migration from Microsoft Access to SQLite

Databases

Since ProCall Enterprise 8.0, Microsoft Access is no longer supported as a journal database. In ProCall 8 Enterprise  required database updates are only for SQL-based databases performed. 

It is essential to convert the UCServer to use a SQL-based database.
This article describes how to convert to "SQLite" as database.

If you plan to switch to Microsoft SQL Server, please follow the instructions at Best practice: Conversion of the UCServer database to Microsoft SQL server.
Please also refer to Limitations when using Microsoft SQL Server Express

The content of the Microsoft Access database can be transferred with the tool "ConvertUCServerMDB2SQLite.exe".

The porting of databases between two database systems is the responsibility of a database administrator.

The following instructions and the toolConvertUCServerMDB2SQLite.exe  provided by estos are intended as non-binding assistance for the transfer of a database from Microsoft Access to SQLite and require specialist knowledge in the management of databases.

• Please understand that this tool ConvertUCServerMDB2SQLite.exe is generally excluded from estos support.

When does the database need to be converted?

The conversion must must be performed with version 8.3.5 as there are changes for writing in the database..

The changeover can be made with any ProCall 8 Enterprise version.

How can I check which database is in use?

You can see which database is used in the UCServer administration under General - Database.

If "Access & SQLite" is still set here, the data must be transferred and the database converted .

Data transfer from Microsoft Access

To transfer the data, carry out the following steps:

Stop the UCServer service.

Save the directory "....\UCServer\database".

Copy the "ConvertUCServerMDB2SQLite.exe" from the directory "...\UCServer\Supportfiles" into the directory "....\UCServer\database".

Execute the "ConvertUCServerMDB2SQLite.exe" .

You have the following options here:

• via double-click
  You will not receive any information about errors.
• in an administrative CMD
  Messages about the process and errors are displayed.

With successful data transfer, two new files are created:

• CtiServerDatabasejournal.db
• CtiServerDatabasetask.db

Start the UCServer service.

Log in to the UCServer Administration and set the database to "SQLite" under General - Database . 

Restart the UCServer service.

The data transfer and conversion to SQLite is now complete.

Further parameters and logging

ConvertUCServerMDB2SQLite.exe [-h] [-i INPUTFILE] [-o OUTPUTFILE] [--verbose] [--version]

optional arguments:
  -h, --help            show this help message and exit
  -i INPUTFILE, --inputfile INPUTFILE
                        MS Access database filename
  -o OUTPUTFILE, --outputfile OUTPUTFILE
                        SQLite database filename
  --verbose             Print some more info while processing
  --version             show program's version number and exit

To activate extended logging, use the parameter --verbose.

The estos guideline for the support of third-party products - interoperability information.

Further information

Migration of the internal UCServer database from Microsoft Access to SQL Server

ProCall 8.0 Enterprise Release Notes

Best practice: Conversion of the UCServer database to Microsoft SQL server

Limitations when using Microsoft SQL Server Express

ProCall 8 Enterprise system requirements