Reconciling Changes and Generating Database Definitions to a File

You can reconcile the changes you have made to the offline database definitions and generate a SQL script containing ALTER statements to update the online schema with those changes.

Note: If you have made changes to tables that have foreign keys, it is possible that the foreign keys will be dropped when you generate your changes to the database. For more information, refer to Offline Tables and Foreign Keys.

To reconcile changes and generate a SQL file:

In the navigator, expand the workspace and project.
Right-click an offline schema and choose New to display the New Gallery.
From the New Gallery, expand Database Tier , and select Offline Database.
Choose SQL Generated from Offline Database Objects to launch the Generate SQL from Offline Database Objects wizard.
In the pages of the wizard enter parameters and select options to define the table. For information about how to fill in these values, click Help in the dialog.
On the Generate Options page select UPDATE (reconcile) the chosen objects. Click Next.
On the SQL Script Options page specify details for the generated file, then click Next.
On the Finish page, click Finish to update the database.

Context Menu Shortcut:

In the navigator, right-click one or more offline table definitions and choose Generate or Reconcile Objects
or
On the database diagram select one or more tables, right-click and choose Generate | Data Definition Language.