Fast Generate or Reconcile to a Database Connection

You can use this method when you just want to quickly update one or more tables in the database. The offline table definitions must have a record of the database connection you want to use, so the connection must be:

That used when the table or tables were originally imported.
A database connection that the tables have already been generated to.

You have the option of reconciling the tables, which creates ALTER statements, or replacing the tables in the database, which drops the existing database tables and replaces them with the offline tables.

Other ways of generating or reconciling to a database that are suitable for generating to a different database connection are:

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, select the tables and choose Generate or Reconcile to <db_conn> from the context menu.
To reconcile the offline tables with the database tables, select Reconcile.
To replace the tables in the database with the offline table definitions, select Replace.
The replace or reconcile action may take a few seconds, and at the end a Reconcile Summary will confirm that the replacement or reconciliation took place with no errors. If you have selected Reconcile and no reconciliation is necessary, the Reconcile Summary dialog reports this.