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, a repository database and a set of sample databases, but the installation of the engine and databases is optional in the installer.

The Servoy Application Server requires a connection to the Servoy Repository in order to start. See Servoy Repository for more information. When using existing databases, make sure that a valid connection to a properly configured Servoy Repository is available to the Servoy Application Server.

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, except the servoy_repository.* files
• 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/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 installation) into the <servoy>/application_server directory
• If the copied servoy.properties file doesn't already contain properly configured database connections, see Database Servers for more information on how to manually edit the servoy.properties file.

Depending on the type of databases used, JDBC drivers might need to be added. See JDBC drivers for more information.