When generating Alter Script during Complete Compare, get "No schema to generate" message". Why?

Error Message:

 "No schema to generate"

 Description:

When Complete Comparing two models, after importing the differences from one model to another model, go to Alter Script to get the Alter syntax, get the error message "No schema to generate".  Why?

Solution:

The reason is that the tables being imported or exported are not in the Subject Area (SA) being imported or exported to.  Even in erwin, if you switch to or create a new SA with no Tables, Forward Engineering preview will also give the same message. To get the syntax you will need to import or export the new tables into the current SA as well - by default the tables are imported and exported into Model and not any SA.  Here is how to do it:

 1. In Type Selection select 'Subject Area' so you see SA in Resolve Differences screen.
 2. Import or Export the SA if it is missing in any of the two models being compared
 3. Expand the SA and see the Tables under that to import / export the desired tables.
 4. Click Alter Script icon, and click Preview to see the Alter statement.