|
My SQL Database |
  
|
|
My SQL Database |
|
It is possible to use a MySQL database for Untis MultiUser as well. The installation is based on the MS Access database. Untis copies all tables including structure and content automatically from MS Access to the MYSQL database. The following steps are necessary:
| 1. | In case you have worked with MultiUser version 2007, convert your Access database according to the description in chapter " Database Conversion from Version 2007 ". |
| 2. | In case you have worked already with Untis MultiUser and you want to switch to MySQL then download the latest update from www.grupet.at and log in the database once. Thus you can ensure that the structure of your gpUntis.mdb is updated. Afterwards rename the ODBC connection into "gpUntis0". |
Otherwise create a new data source for MS Access, named gpUntis, via "Control panel | Administration | Data Source (ODBC)" which points to the delivered gpUntis.mdb. Open Untis once and activate "File | Login". Afterwards rename the ODBC connection into "gpUntis0".
| 3. | Create a new ODBC data source named gpUntis which points to an empty (i.e. without any tables) MySQL database. If there is no MySQL driver provided then you can download one for free e.g. at www.mysql.com . |
Hint: Data access via internet
As you can see in the figure above, you can, when you define your ODBC connection, indicate the server via an IP address. Every server connected to the internet has a unique IP address therefore you can easily place your database on a web server and access it via internet.
| 4. | Now start Untis and choose "File | Login". The processing starts after the prompt if the conversion to MySQL shall be performed. This may last a few minutes depending on the size of the database. |
If the conversion is unsuccessfully aborted during the run, you have to delete all potential tables from the database and restart the process.
Caution!
To allow this process you have to convert the structure of the data to the latest version. This conversion is described in the chapter " Database Conversion from Version 2007 ".