Almost all Servoy applications utilize a database to store user data and application metadata. Servoy can connect to any database that has a JDBC driver available. Servoy provides a database, Sybase SQL Anywhere, for you if you do not already have a database management system (DBMS).
Creating a New Database in Sybase SQL Anywhere
In Servoy Developer, you may create a new SQL Anywhere database from the Solution Explorer tree.
- In the Servoy Developer Solution Explorer tab, expand the Database Servers node (under Resources) and right click on a SQL Anywhere database (all the example databases provided by Servoy are SQL Anywhere) to show the popup menu.
- Select Create Sybase Database.
- Enter a name for the database in the dialog window.
- A dialog will appear indicating a Sybase database restart is required.
- A dialog will recommend to restart Servoy Developer. Click OK. and close Servoy Developer.
- Close Sybase SQLAnywhere.
- On Windows - Look for the orange lighting bolt in the system tray, right click, and select Shut down "servoy_repository"
- On Mac and Linux - find the dbsrv11 process and shut it down.
- Restart Servoy Developer.
- Your database will appear in the Database Servers node.
Connecting to an Existing Database
You may also connect to an existing database.
It is best practice to create your data model (tables, primary keys, foreign keys, and fields)
Overview
Content Tools
Activity