Servoy can connect to any type of database that supports JDBC connections.
In order to be able to start, the Servoy Application Server requires a connection to the Servoy Repository. When using existing databases, a valid connection to a properly configured Servoy Repository is required for the Servoy Application Server to be able to start. If you install Application Server on a new database engine(installed separately), you must create a repository database using your database tool, then specify the connection parameters during install (username, password, url ...). Servoy Application server will automatically create a repository server with these connection data, but in order to create all tables in repository database you must upgrade the repository.
Using an existing database for the [Servoy Repository]
After repository server is created , Servoy Application Server can be started and configured via admin page, see Configuring the Server You will have to create the databases manually using your database tool and create Servoy Servers from admin page before importing the solution. See Database Connections for more details
Using the Bundled PostgreSQL Engine i.c.w. Existing Databases
When the installation of the PostgreSQL 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 PostgreSQL engine to existing PostgreSQL databases:
- Start the database (see Starting the Database for more information)
Connect to the database using the commandline psql utility and drop the unwanted databases:
- Restore a dump of the existing databases. For information on how to backup and restore databases, see this PostgreSQL documentation.