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
Connect to Existing Database	Creates a new DB Server connection to an existing database.
Create New Database	Creates a new named database (PostgreSQL) and creates a connection to it.
Synchronize with DB Server Information	Opens the Database Synchronization Wizard
Reload Tables/Structure from DB	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 selected 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.