Difference between revisions of "Meet Manager:Database Connections"
(Created page with "(Enterprise Edition only) here it comes...") |
|||
Line 1: | Line 1: | ||
(Enterprise Edition only) | (Enterprise Edition only) | ||
− | + | Instead of opening an '''.mdb''' file you can open a '''.ini''' file with a description of a connection to any common database. But there are some differences compared to MS Access files: | |
+ | * Meet databases have to be created manually | ||
+ | * Backup / restore only works with concurrent backups | ||
+ | |||
+ | The main advantage is, that you can run Meet Manager in a network on a real database server. The following documentation expects, that you are familiar with the installation of a database server, user setup and basic managment tasks like creating an empty database. | ||
+ | |||
+ | The first time you connect to a database with Meet Manager, the application will automatically create the necessary tables and indices. You should always use an empty database in order to avoid conflicts with table names. Once a database is initialized with Meet Manager, you can backup and restore it with your database in order to use it for a different meet. | ||
+ | |||
+ | ===The .ini file=== | ||
+ | The .ini file needs the following sections | ||
+ | |||
+ | =====[Database]===== | ||
+ | In this section you can define the following keys: | ||
+ | * BSDatabaseType: Values are '''FIREBIRD''', '''MSSQL''', '''MYSQL''', '''ORACLE''' and '''POSTGRESQL'''. | ||
+ | * Database: Generally the value has the format "Servername:Databasename". The format in detail depends on the selected database type | ||
+ | * User_Name: The username used to connect to the database | ||
+ | * Password: The password for the database user | ||
+ | |||
+ | |||
+ | ===Supported databases=== | ||
+ | ====Firebird==== | ||
+ | http://www.firebirdsql.org is a good page to start with Firebird. We recommend to use the latest version of Firebird (2.5). In addition to the regular keys you have to define the following |
Revision as of 09:57, 5 October 2012
(Enterprise Edition only)
Instead of opening an .mdb file you can open a .ini file with a description of a connection to any common database. But there are some differences compared to MS Access files:
- Meet databases have to be created manually
- Backup / restore only works with concurrent backups
The main advantage is, that you can run Meet Manager in a network on a real database server. The following documentation expects, that you are familiar with the installation of a database server, user setup and basic managment tasks like creating an empty database.
The first time you connect to a database with Meet Manager, the application will automatically create the necessary tables and indices. You should always use an empty database in order to avoid conflicts with table names. Once a database is initialized with Meet Manager, you can backup and restore it with your database in order to use it for a different meet.
The .ini file
The .ini file needs the following sections
[Database]
In this section you can define the following keys:
- BSDatabaseType: Values are FIREBIRD, MSSQL, MYSQL, ORACLE and POSTGRESQL.
- Database: Generally the value has the format "Servername:Databasename". The format in detail depends on the selected database type
- User_Name: The username used to connect to the database
- Password: The password for the database user
Supported databases
Firebird
http://www.firebirdsql.org is a good page to start with Firebird. We recommend to use the latest version of Firebird (2.5). In addition to the regular keys you have to define the following