Difference between revisions of "Meet Manager:Database Connections"

From Swim Wiki
Jump to: navigation, search
(Created page with "(Enterprise Edition only) here it comes...")
 
Line 1: Line 1:
 
(Enterprise Edition only)
 
(Enterprise Edition only)
  
here it comes...
+
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