Database Servers
Reference documentation for the Database Servers item
Overview
The Database Servers node in the Solution Explorer can be expanded to show each of the named Database Server connections that have been configured.
Commands Summary
The following commands are available for Database Servers node. They can be accessed by right-clicking the context menu:
| Command | Summary |
|---|---|
Creates a new DB Server connection to an existing database. | |
Creates a new named database (PostgreSQL) and creates a connection to it | |
Reloads the schema from the database |
Commands Details
The following commands are available for Database Servers node in the Solution Explorer. They can be accessed by right-clicking to get the context menu:
Connect to existing database
Use this command to create new Database Server connection to an existing database. You will have the option to select the database vendor or you can choose empty. The Database Server Connection Editor will be opened. If you select a particular vendor, then some properties will be pre-filled. Enter your connection parameters and save.
Create new database
Use this command to create new Database on an existing Postgresql Server. You will be prompted to enter a name for the database. The command will also create a Database Server connection and pre-fill the connection parameters and open the Database Server Connection Editor.
Synchronize with DB Server information
Use this command to synchronize between the database schema and the Database Information (.dbi) files in your project. This command will open the database synchronization wizard, where you can resolve differences between the schema and your .dbi files.
Reload Tables/Table Structure from DB
Use this command to reload the database schema from the database. You can do this to check for changes which may have been made to the schema from outside of the Servoy development environment. If conflicts are found, you can fix them by synchronizing with your .dbi files.
Last updated