Reconciling Changes and Generating Database Definitions to a Database

You can reconcile the changes you have made to the offline database definitions and generate those changes directly to a database schema.

If you have one or more tables containing information that you want to generate to a database, you can use this method. However if you want to quickly generate one or more tables back to their original database connection, you can do this from the navigator. For more information, see Fast Generate or Reconcile to a Database Connection.

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 them to a database schema:

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.
To generate definitions to a database, on the Generate Options page select UPDATE (reconcile) the chosen objects and Perform the chosen operation directly with the database. Click Next.
You can also select Generate SQL scripts for the operation to generate a SQL file of the statements used to generate the changes to the database.
On the Database Connection and Schema page specify the connection details for the database and schema, and click Next. If you are generating a SQL script, specify details for the generated file on the SQL Script Options page and click Next.
On the Finish page, click Finish to update the database.

Context Menu Shortcut:

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