MMG Schema Sync Utility

The MMG Schema Sync Utility, sync_source_target_schema_utility.sh, enables administrators and advanced users to synchronize database schema meta data between a work space’s source and target environments.

This tool is essential when modifications, such as new table creation, are performed manually outside OFS MMG, by using tools like SQL Developer, which may cause inconsistencies between the source and target schema definitions and OFS MMG’s meta data catalog. By keeping the DMM meta data in sync ensures that subsequent workspace edits and data sourcing operations proceed without errors.

The following is an example of how this works; you had initially sourced Table1 and Table2 into your workspace through OFS MMG. Later, you or another team member manually creates a new Table3 directly in both the source and target schema outside the OFS MMG user interface. If you try to edit your workspace in OFS MMG to bring in Table3, the operation will fail because OFS MMG’s meta data (managed by DMM) does not recognize that Table3 already exists in the target. DMM will attempt to recreate it that will in turn cause a conflict.

The MMG Schema Sync Utility solves this by refreshing DMM’s meta data, allowing OFS MMG to recognize all the tables that currently present in the target schema, including those that are added manually.

The MMG Schema Sync Utility works in the following way:

1. The utility invokes a backend DMM API.
2. If the run contains no table filter, it scans and re-registers all the tables in the target schema into DMM’s catalog.
3. If the run contains a list of tables, it updates only the specified tables.
4. Once the synchronization is performed, these tables are visible and selectable within OFS MMG as if they had originally been sourced there.