Generating Update _ Diff DDL

When you make model changes in your developer instance which must later be deployed to a test or production instance, its helpful to generate a database update script which will apply only those changes needed to update the database schema so that it matches your new model definitions. The resulting file name and path are displayed in the console window.

To generate the update DDL, execute the Ant task called gen-instance-schema-update. The resulting file name and path are displayed in the console window.

Figure 3.31. The console window shows you where the generated DDL file is located.