Changes
The Database Manager is basically used for maintenance tasks in UBIK databases. These tasks can be executed whether there is already a database connected or not connected but already defined in the UBIK.Studio options. For the second case, the database manager tries to establish a temporary connection to work with. UBIK.Studio refuses database connections due to a version mismatch between the Studio version and the database version if they are not compatible to each other. The database can be upgraded in this place by selecting the desired target version number (which is set to the highest available by default). Therefore, it automatically selects all needed scripts to perform the upgrade. An additional database manager functionality is to execute any SQL script file, for example to perform specific changes in the database, applying corrections, cleanup etc.
[[File:UI_DatabaseManager.png|thumb|right|220px|Database Manager Dialog]]
| Run Script... || Load and execute a SQL script on the connected database.
|}
==Script list==
The list shows all scripts that are executed on the upgarde task. After the upgrade has been executed, it shows for each script file if an error occured or not. Double-clicking an executed script show the results of the execution run. This is useful for identifying problems that lead to the upgrade fail. The same applies when a manually provided SQL file has been executed by "Run script...".
==Upgrade button==
By pressing the button, all shown scripts are excuted. Then, the progress and the final results will be visualized.
==Statusbar==
The status bar informs the user about the connection status. If this worked, the current version of the database is shown otherwise the provided credentials have to be checked in the options.
