Sync To DB Tab

The Sync To DB tab contains the following fields.

Field	Module Property?	Description
Objects will be added to DB	No	The SmartMapper ER Model objects that are created in the database when synchronization is invoked.
Audit	No	Select to enable auditing. For identity relationships, when auditing is enabled, a new table is created and an ADT prefix is added in the table name. For association relationships, when auditing is enabled, the creating_date and modified_date attributes are added in the table.
Objects will be removed from DB	No	The SmartMapper ER Model objects that are removed. The database tables for removed objects are not actually dropped during synchronization. Instead the tables are marked as deleted and are not used by TIBCO ActiveMatrix BusinessWorks Plug-in for SmartMapper. That is, the data is left intact for removed objects.
Objects will be changed into DB	No	The SmartMapper ER Model objects that are changed.
Close	No	Close this dialog.
Generate SQL	No	Generates a window that contains the SQL that is executed if you click Sync ER Model w/DB.
Generate Complete Script	No	Generates a complete SQL script for the current SmartMapper ER Model. Click Copy to Clipboard to copy the SQL script to the Clipboard.
Perform Sync	No	Creates or removes the TIBCO ActiveMatrix BusinessWorks Plug-in for SmartMapper objects in the database.