• tables from an external database (Oracle, SQL Server, etc.).
• tables whose data was not converted to the HFSQL Classic format.

• force the synchronization from the data model editor.
• program an automatic check for the changes made to the external database when opening the database schema.

Forcing the synchronization

1. Open the database schema containing the external tables in the data model editor.
2. On the "Database schema" tab, in the "Database schema" group, expand "Synchronization" and select "Update database schema from external databases". The external database synchronization wizard opens.
3. Select the databases used in the database schema to check.
4. Specify the type of check and validate. You have the ability to check:
   • the tables common to the external database and the database schema.
   • all tables present in the external database.
5. The list of tables that are not consistent with the current database schema is displayed. The current database schema can be updated. Choose the modifications to apply.
6. Program (if necessary) a regular check of the structure of the external databases. This check will be automatically performed when the database schema is opened. Specify (if necessary) the frequency of this check.
7. Validate.

Programming a regular synchronization (when the database schema is opened)

1. Open the database schema containing the external files in the table model editor.
2. Open the database schema description window:
   • right-click to open the context menu of the database schema scheme.
   • select "Database schema description".
3. On the "Options" tab, select the synchronization frequency:
   
4. Validate.