Migration of the internal UCServer database from Microsoft Access to SQL Server
State of knowledge
October 2020
The following instructions are intended to assist you in transferring a Microsoft Access database to SQL and require expert knowledge of database support.
Please understand that there is no right to support from estos in case of problems.
In UCServer Administration, switch the server database to Microsoft SQL Server and createa completely new database here without entries.
Stop the UCServer service and backup all *.mdb files from the directory "C:\Program Files (x86)\ESTOS\UCServer\database".
On SQL Server, please perform the following steps for each table:
Example screenshot: Import Data...
Example screenshot: SQL Server Import and Export Wizard – Choose a Data Source
In the next step, connect to the SQL Server and the empty database according to your settings.
Example screenshot: SQL Server Import and Export Wizard – Choose a Destination
Example screenshot: SQL Server Import and Export Wizard – Copy data...
Example screenshot: SQL Server Import and Export Wizard – Column Mapping
Example screenshot: SQL Server Import and Export Wizard – Conversion
Example screenshot SQL Server Import and Export Wizard – Successful execution
Now Startthe UCServer service again.
Now Checkin a journal or the journal browser whether the data has been successfully transferred and starta test call whether new entries are also written.
If there are problems with the Microsoft Access Database Engine, please select the Microsoft Jet Database Engine.
