V3.5 14/08/19
UD0089
Page 136
This Document is uncontrolled unless over stamped "CONTROLLED DOCUMENT"
2.5.5.2.4.2
ACCESS TO SQL MIGRATION
This topic describes how to import data to a Traka SQL Database from a single Traka Access Database. It assumes the
reader is already familiar with the Traka32 software, SQL Server Enterprise Manager and SQL Server security.
Before You Start
If you wish to import multiple Access databases to one SQL database please contact Traka as this topic does
NOT cover this scenario.
The version of the Traka32 software that is used with the Access database MUST be the exact same version
as that being used with the SQL database. If the versions are different, upgrade the Traka32 software that is
used with the Access database to the same version as going to be used with SQL prior to migrating. You must
also run the Traka32 software so the database checks are made. This is to ensure the Access and SQL
database structures are the same.
When upgrading from Access to SQL server you will receive another 90 days evaluation period to cover the
time needed to get another unlock code.
Installation
1.
During the initialisation of the database as described in the
will appear. Tick the option to Import all Data from Access database after Database Initialisation.
2.
Click the (...) button to browse to and select the existing Access Database. Once selected click OK.
3.
Select Initialise Database.
4.
Continue with the process in the
topic to configure Traka32 to point to the new
database.