Difference between revisions of "Database Manager"

Revision as of 11:45, 23 July 2013

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. 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, the database manager automatically selects all needed scripts to perform an 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.

Database Manager Dialog

Toolbar

Item	Purpose
Run Script...	Load and execute a SQL script on the connected database.

Revision as of 11:41, 23 July 2013 (view source) BMA (Talk \| contribs) ← Older edit		Revision as of 11:45, 23 July 2013 (view source) BMA (Talk \| contribs) Newer edit →
Line 1:		Line 1:
−	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. ~~If needed,~~ UBIK.Studio refuses database connections due to a version mismatch between the Studio version and the database version. ~~To solve this deficiency, the~~ database can be upgraded in this ~~dialog to enable~~ the ~~user to connect~~ to the ~~database and continue working once back in the Studio~~. ~~For this task~~, the database manager automatically selects all needed scripts to perform an upgrade. ~~Another~~ additional functionality is to execute any SQL script file, for example to perform specific changes in the database, applying corrections, cleanup etc.	+	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. 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, the database manager automatically selects all needed scripts to perform an 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]]		[[File:UI_DatabaseManager.png\|thumb\|right\|220px\|Database Manager Dialog]]