Installing on existing databases

Servoy can connect to any type of database that supports JDBC connections.

By default, Servoy comes bundled with the Sybase SQL Anywhere engine and a set of sample databases, but the installation of the engine and sample databases is optional in the installer.

Using the bundled Sybase SQL Anywhere engine i.c.w. existing databases

When the installation of the Sybase SQL Anywhere database engine is required, keep the Database option in the All-In-One installer checked.

After installing the Servoy Application Server, the following steps are required to remove the sample databases and connect the Sybase SQL Anywhere engine to existing Sybase SQL Anywhere databases:

• Open the <servoy>/application_server/database directory and remove the files there
• Open the sybase.config file located in the <servoy>/application_server/sybase_db directory using a text editor and:
  -remove the links to the sample databases:
  Links to sample databases in sybase.config

  database/servoy_repository.db
  database/user_data.db
  database/example.db
  database/log_data.db
  database/udm.db
  database/pdf_forms.db
  database/bug_db.db

  -add the links to the existing database files. For example:
  Example links to existing database files

  c:/myOwnDatabases/crm.db

Not using the bundled Sybase SQL Anywhere database engine

When not using the Sybase SQL Anywhere database engine, the option can be unchecked in the installer. This will skip the installation of both the Sybase SQL Anywhere database engine and the sample databases.

Since the Servoy Application Server requires at least one connection named 'repository_server' for the Servoy Repository, when unchecking the 'Database' option in the All-In-One installer, the installation of the Servoy Application Server after finishing the All-In-One installer will not be ready for use.

In order to get the Servoy Application Server ready for use the following steps are required:

• Copy a servoy.properties file from another installation (for example a Servoy Developer instance) into the <servoy>/application_server directory
• Open the copied servoy.properties file using a text editor and manually edit the server settings. For each named server a set of properties can be set.