How to Merge Two Database Schemas
To merge two database schemas, take the following steps:
- Open the source database schema
- Select the Merge Database Schemas option from the Database menu.
- Press the Select Target push button to select the target database schema. This is the schema you have previously worked on. This is the schema that will be updated. New tables and columns will be modified, or created on the target. The currently open schema will not be updated.
- Enter the path and file name of the log file. This will record the updates to the target schema.
- Press the Apply push button.
- After the Merge has completed successfully, the log file will automatically open with the default text editor.
- Close the Merge dialog by pressing the Close push button.
- Open the target database schema. The modifications should be applied.