Figure 0.12 Merge Database Schemas
If two separate physical databases are used by an application, you can merge the database schemas together in TurboData. This will allow you to generate SQL statements for the tables in both databases, at the same time.
The merge works with an open database schema and a target schema. The target schema is the schema you have previously read into TurboData. Merge compares the table names and column names on the two schemas. If the names match the target schema is updated if there are any differences. If there is a table or column on the open schema that does not exist on the target schema, it will be created on the target. If there is a table or column on the target schema that does not exist on the open schema, it will remain unchanged on the target.
Helpful Hint: This is very useful for CBD (Component Based Development). You can read in two separate components, and set an implied foreign key to create referentially correct data between the two components.
Warning: TurboData cannot detect a table name or column name modification. It will treat them as two separate tables or columns.
How to Merge Two Database Schemas
