Updating a database configuration
- Select Site Preferences > Database Configurations to add a database configuration connection.
- Click the Database Schema Configurator on the Launch Bar to open the Select Database Connection dialog box.
-
Select a configuration from the
Database Connection list
and click
OK to open the Database
Schema Configurator.
The Table Schema List panel contains all currently imported schemas under the database connection, sorted by schema name. Multiple selections are supported.The Column List panel shows all columns of the currently selected schema. Selected columns are visible to the Network Configurator, HRL Configurator, and Translation Configurator dialog boxes.Selecting a column's check box indicates that the column is added to the .vrl file for current table schema. By default, all columns are selected. Clicking Name clears all check boxes.Each column has name, database data type, and schema data type. Sort the Column List table by clicking on a table header.Required columns are selected and not available because they are always visible. For the schema data type attribute, possible values are those data types of VRL Format.The Database protocol is based on the VRL format to implement. All selected columns in the Database Schema Configurator are converted to a VRL field. Column names must follow the naming rule of a VRL field. Only letters, digits, and underscores are supported. Cloverleaf does not support special characters, including spaces for table/column names, even though they are supported by the SQL standard syntax.
-
Use the editing buttons at the bottom of the Table Schema List
as necessary.
- Import adds schemas into the Table Schema List.
-
Synchronize
synchronizes the selected table schemas with the database.
See Synchronizing the selected table schema.
You can also use File > Synchronize All.
- For Add SQL Statement Schema/ Update SQL Statement Schema, see Adding/Updating SQL statement schema.