00197725-12_GS_SE3.11_EN.pdf - 第59页
Getting Started SIPLACE Explorer 3 SIPLACE Explorer Runtime Envi ronment from 3.11 (R20-2) Edition 11/2020 EN 5 9 3 Fig. 3 - 38 Convert database S pecify th e access d ata for the database a dministrator and enab le th…
3 SIPLACE Explorer Runtime Environment Getting Started SIPLACE Explorer
Edition 11/2020 EN from 3.11 (R20-2)
58
3.7.2 Converting the Database
Due to the changed data structure in the SIPLACE Explorer 3.11 database, existing databases
with data from SIPLACE Explorer 2.0 - 3.10 need to be converted. 3
Always perform the conversion when you need to access a database which does not yet have the
SIPLACE Explorer 3.11 database format. This could occur in the following cases: 3
– Using the SE database
– Runtime Environment:
Step 5 - Configure System Database page 38
– Development Environment:
Step 7 - Configure System Database page 38
– Using the factory database
– Factory Configuration Utility
Loading the DB settings on Factory Configuration Utility start, page 78
Database conversion can only be performed if a connection has already been established to the
database. 3
The Convert database dialog box will open.
NOTE
Consider the following for database conversion:
- You will need database administrator rights.
- If you have started the conversion, this process can not be stopped.
- The conversion time depends on the size of the database and on the performance of the
computer. It may take up to an hour. 3
Getting Started SIPLACE Explorer 3 SIPLACE Explorer Runtime Environment
from 3.11 (R20-2) Edition 11/2020 EN
59
3
Fig. 3 - 38 Convert database
Specify the access data for the database administrator and enable the Backup database
option.
Confirm your entries with OK. The DB backup location dialog box will open.
3
Fig. 3 - 39 DB backup location
Before performing the conversion, the system creates a backup file of the database. Specify
the folder for this file in the Folder for database backup field. Click on the Browse ... button
to select an existing folder.
Confirm your choice with OK. The database will be converted. This may take up to one hour.
The conversion time depends on the size of the database and on the performance of the
computer.
After successful conversion of the database, the following information window will open:
3 SIPLACE Explorer Runtime Environment Getting Started SIPLACE Explorer
Edition 11/2020 EN from 3.11 (R20-2)
60
3
Fig. 3 - 40 Success
Click OK. The database has been converted accordingly.
3.7.3 Compressing the Database
We recommend compressing the database, when the user has restored the SIPLACE Explorer
line database or has moved the raw database files to another disk or to another computer. 3
With the DB compression it is possible to avoid extended access times of the websites. 3
The DB compression can be started in the following cases: 3
– Using the SE database
– Runtime Environment:
Step 5 - Configure System Database page 38
Enabling the DB maintenance functionality or building the website.
– Using the factory database
– Factory Configuration Utility
Enabling the DB maintenance functionality or building the website.
Database compression can only be performed if a connection has already been established to the
database. 3
Dependent of starting the DB compression, the following information window will open:
3
Fig. 3 - 41 Database compression
Click Yes to select the compress options, the Compress System Database dialog box will
open.