Data Model and database synchronization

There are two ways to syncronize your Data Model and database.

  • you change your database first and synchronize your Data Model with database structure. This way is reccomended.
  • you change your Data Model first and synchronize your database with Data Model. This method have big number of limitations.

Database -> Data Model synchronization

Follow next chain:

  1. Update your database
  2. Open Data model section in Admin panel
  3. Click on Update model link button
  4. The new objects marked yellow. The changed objects marked green. Select tables or attributes wich you whant to synchronize with your Data model. Press Apply button.
  5. If some columns were deleted from database, you need to delete them manually from your Data Model.
  6. If you whant to access new columns via Views, you need to update your Views manually.

Data Model -> Database synchronization

Follow next chain:

  1. Update your Data Model.
  2. Open Data model section in Admin panel
  3. Select Data Model items which you whant to synchronize and press Sync DB for selected items button.
  4. Only the following changes are applied to the database automatically:
  • Create new table if itable does not exist in dtabase
  • Create new column in existing table if column does not exists in database.
  • Drop column if it not exists in Data Model but exists in database
  1. Apply other changes to your database manually.