You can destroy all ATG Content Administration, ATG Business Control Center, ATG Portal, and ATG Adaptive Scenario Engine tables with the following global script:
<ATG2007.3dir>/BIZUI/sql/install/db-vendor/drop_bizui_all_ddl.sql
For information on the individual scripts used to destroy the tables for the ATG Adaptive Scenario Engine and ATG Portal, see the discussion on destroying database tables in the ATG Installation and Configuration Guide. If your product suite includes any ATG applications, refer to your application’s manual to locate its destroy scripts.
ATG Content Administration Database Drop Scripts
The drop_bizui_all_ddl.sql script executes the following individual subscripts in order to destroy the database tables for ATG Content Administration. A copy of each subscript is located in the <ATG2007.3dir>/Publishing/base/sql/unistall/dbvendor directory for the appropriate database.
File Name | Description |
|---|---|
Destroys the tables for storing media for ATG Content Administration. | |
Destroys the tables for the ATG Content Administration repository, which holds processes and process types. | |
Destroys the tables for the extensions to the user profile specifically for ATG Content Administration. | |
Destroys the tables for the | |
Destroys the tables for the | |
Destroys the tables for storing versioning information. | |
Destroys the tables for the workflow portion of the ATG Content Administration repository. |
ATG Business Control Center Database Drop Scripts
The drop_bizui_all_ddl.sql script executes drop_viewmapping_ddl.sql to destroy the database tables used by the ATG Business Control Center. A copy of this script exists in the <ATG2007.3dir>/BIZUI/sql/uninstall/dbvendor directory.
