Before you begin to build the web application for your production web site, you must install and configure a production-ready database.

  1. Set up the ATG asset management server.

    Follow the steps in the Setting Up an Asset Management Server chapter of the ATG Content Administration Programming Guide.

  2. Start the database.

    Follow instructions in the documentation from the database vendor.

  3. To create the tables for ATG Content Administration, run this script:

    <ATG10dir>/BIZUI/sql/install/database-vendor/bizui_all_ddl.sql

    For more information, see the section Create ATG Content Administration Tables in the ATG Content Administration Programming Guide.

  4. If you have ATG Search, create the tables that support ATG Search integration. Run this script:

    <ATG10dir>/DAF/Search/Index/sql/db_components/
    database-vendor/search_ddl.sql

    For more information, see the section Creating the Search Database Tables in the chapter Installing ATG Search in the ATG Search Installation and Configuration Guide.

  5. Follow the instructions below to create and populate versioned database tables as required by Merchandising and, optionally, Oracle ATG Web Commerce Consumer Commerce, Oracle ATG Web Commerce Business Commerce, and Oracle ATG Web Commerce Search.

  6. Initialize and populate the ATG Content Administration database by running the scripts that are described in the section Initialize the Database in the chapter Setting Up an Asset Manager Server in the ATG Content Administration Programming Guide.

  7. Import data required by ATG Content Administration and Merchandising. See Importing Required Data.

  8. If you use additional ATG applications, see the documentation for each ATG application to learn the database tables requirements for the application.


Copyright © 1997, 2013 Oracle and/or its affiliates. All rights reserved. Legal Notices