Database Manager - Revision history

KNO: /* Add a number of Languages */

2015-08-25T07:38:49Z

‎Add a number of Languages

KNO: /* Upgrade the Database */

2015-08-25T07:38:14Z

‎Upgrade the Database

KNO: /* Run SQL Script */

2015-08-25T07:37:54Z

‎Run SQL Script

KNO: /* Run SQL Script */

2015-08-25T07:37:35Z

‎Run SQL Script

KNO: /* Upgrade the Database */

2015-08-25T07:36:11Z

‎Upgrade the Database

KNO at 07:34, 25 August 2015

2015-08-25T07:34:53Z

KNO at 15:38, 2 February 2015

2015-02-02T15:38:56Z

BMA at 14:22, 8 May 2014

2014-05-08T14:22:10Z

BMA: /* Upgrade the Database */

2014-05-08T14:11:50Z

‎Upgrade the Database

BMA at 08:25, 3 March 2014

2014-03-03T08:25:26Z

@@ Line 30: / Line 30: @@
 ==Add a number of Languages==
-To add a certain number of new languages to the database, the number of languages to be added has to be selected first. Pressing the Button "Add" then adds the languages with a neutral name which can be edited by double clicking in the language list.
+To add a certain number of new languages to the database, the number of languages to be added has to be selected first. Pressing the Button {{key press|Add}} then adds the languages with a neutral name which can be edited by double clicking in the language list.
 ==Run SQL Script==

@@ Line 22: / Line 22: @@
 ==Upgrade the Database==
-The list shows all scripts that are executed in the upgrade task. After the upgrade has been executed, it shows the success or error status for each SQL script file in the column "Status". Double-clicking the line of an executed script shows 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...". By pressing the upgrade button, all shown scripts contained in the list are excuted. The progress and the final results will be visualized to the user.
+The list shows all scripts that are executed in the upgrade task. After the upgrade has been executed, it shows the success or error status for each SQL script file in the column ''Status''. Double-clicking the line of an executed script shows 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...''. By pressing the upgrade button, all shown scripts contained in the list are excuted. The progress and the final results will be visualized to the user.
 When all database upgrade scripts have been executed successfully it is necessary to execute several additional maintenance tasks to the structures in the database. In this case the application window will be closed automatically and a status window will appear. After maintenance is finished, {{UBIK}} Studio will restart and connect to the database again.

@@ Line 33: / Line 33: @@
 ==Run SQL Script==
-By pressing the '''Open''' toolbar button, a SQL script can be loaded into the code editor. Once loaded, the script then can be executed by pressing the '''Run SQL Script''' (green arrow) toolbar button. After executing the script, a success message is displayed. In case of an Error, the error information will be displayed in another dialog window.
+By pressing the ''Open'' toolbar button, a SQL script can be loaded into the code editor. Once loaded, the script then can be executed by pressing the ''Run SQL Script'' (green arrow) toolbar button. After executing the script, a success message is displayed. In case of an Error, the error information will be displayed in another dialog window.
 [[Category:Database|Database Manager]]
 [[Category:Studio tools|Database Manager]]

@@ Line 33: / Line 33: @@
 ==Run SQL Script==
-By pressing the "Open" toolbar button, a SQL script can be loaded into the code editor. Once loaded, the script then can be executed by pressing the "Run SQL Script (green arrow) toolbar button. After executing the script, a success message is displayed. In case of an Error, the error information will be displayed in another dialog window.
+By pressing the '''Open''' toolbar button, a SQL script can be loaded into the code editor. Once loaded, the script then can be executed by pressing the '''Run SQL Script''' (green arrow) toolbar button. After executing the script, a success message is displayed. In case of an Error, the error information will be displayed in another dialog window.
 [[Category:Database|Database Manager]]
 [[Category:Studio tools|Database Manager]]

@@ Line 24: / Line 24: @@
 The list shows all scripts that are executed in the upgrade task. After the upgrade has been executed, it shows the success or error status for each SQL script file in the column "Status". Double-clicking the line of an executed script shows 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...". By pressing the upgrade button, all shown scripts contained in the list are excuted. The progress and the final results will be visualized to the user.
-When all database upgrade scripts have been executed successfully it is necessary to execute several additional maintenance tasks to the structures in the database. In this case the application window will be closed automatically and a status window will appear. After maintenance is finished, UBIK Studio will restart and connect to the database again.
+When all database upgrade scripts have been executed successfully it is necessary to execute several additional maintenance tasks to the structures in the database. In this case the application window will be closed automatically and a status window will appear. After maintenance is finished, {{UBIK}} Studio will restart and connect to the database again.
 ==Add a number of Languages==

@@ 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, but also if it is not connected. In this case, the database manager tries to establish a temporary connection using the current [[UBIK Studio Basics#Options|Options]] 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. Other functionalities are the management of supported languages and executing SQL scripts (e.g. used for individual maintenance issues).
+The Database Manager is basically used for maintenance tasks in {{UBIK}} databases. These tasks can be executed whether there is already a database connected, but also if it is not connected. In this case, the database manager tries to establish a temporary connection using the current [[UBIK Studio Basics#Options|Options]] 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. Other functionalities are the management of supported languages and executing SQL scripts (e.g. used for individual maintenance issues).
 [[File:UI_Database_Manager_01.png|thumb|right|220px|Database Manager Dialog - Upgrade]]
@@ Line 32: / Line 32: @@
 By pressing the "Open" toolbar button, a SQL script can be loaded into the code editor. Once loaded, the script then can be executed by pressing the "Run SQL Script (green arrow) toolbar button. After executing the script, a success message is displayed. In case of an Error, the error information will be displayed in another dialog window.
-[[Category:Studio tools]]
+[[Category:Database|Database Manager]]
-[[Category:Database]]
+[[Category:Studio tools|Database Manager]]

← Older revision		Revision as of 15:38, 2 February 2015
Line 31:		Line 31:
	==Run SQL Script==		==Run SQL Script==
	By pressing the "Open" toolbar button, a SQL script can be loaded into the code editor. Once loaded, the script then can be executed by pressing the "Run SQL Script (green arrow) toolbar button. After executing the script, a success message is displayed. In case of an Error, the error information will be displayed in another dialog window.		By pressing the "Open" toolbar button, a SQL script can be loaded into the code editor. Once loaded, the script then can be executed by pressing the "Run SQL Script (green arrow) toolbar button. After executing the script, a success message is displayed. In case of an Error, the error information will be displayed in another dialog window.
		+
		+	[[Category:Studio tools]]
		+	[[Category:Database]]

@@ Line 2: / Line 2: @@
 [[File:UI_Database_Manager_01.png|thumb|right|220px|Database Manager Dialog - Upgrade]]
 [[File:UI_Database_Manager_02.png|thumb|right|220px|Database Manager Dialog - Languages]]
 [[File:UI_Database_Manager_03.png|thumb|right|220px|Database Manager Dialog - SQL Scripts]]