In the Data Extractor, you can also check the database schema on the Extractor output tab. To do this, click the <Check Database Schema> button. ibaAnalyzer compares the tables configured in the database connection with the actual database schema.
The required tables and columns are determined by your settings in ibaAnalyzer, that is, by the extracted channels and their archive profiles. During the check, ibaAnalyzer compares this required schema with the schema of the existing database and displays the differences in a dialog. There, you select the changes to apply, and ibaAnalyzer updates the database accordingly.
User interface of the Check database schema dialog
The Check database schema dialog displays all the tables in the database connection on the left and indicates which changes are required for each table (e.g., create, modify, or delete) to align the tables with the configuration in ibaAnalyzer.
The right side of the dialog shows the columns of the selected table and the necessary changes for each one.
Columns
-
Table: Table names
-
Column: Column names in the selected table
-
Column with symbols: Required action for each change
Green
no change
yellow
optional change
red
required change
-
Data type: Data type of the column
-
Action: Type of required change
-
Apply: Tick the box to apply the change. If changes are required, the checkbox is always selected and cannot be deselected. For optional changes, the checkbox is not selected by default. You must actively decide whether you want to apply the change.
Buttons
At the bottom of the dialog box, you can find the following buttons:
-
<Save as SQL>: Saves the active changes as an SQL file. This file can be used independently of the data extractor, for example, in an SQL editor. There, you can also add instructions that are not possible in ibaAnalyzer, such as custom calculated columns. This feature is also useful if you want to pass the changes on to the database administrator.
-
<Start fresh>: Deletes all tables and recreates them. This will result in the loss of all data in the tables. The action is not executed immediately; instead, it first updates only the actions in the left area. It is not applied until you click <OK>.
Caution! |
|
|---|---|
 |
If you use this function, all existing data in the tables will be permanently deleted. Create a backup beforehand if necessary. |
-
<OK>: Applies all selected changes to the database tables.
-
<Cancel:> ibaAnalyzer discards all changed settings and closes the window.