In order to use ATG Merchandising, ATG Business Commerce and the add-on ATG Search features (Search Merchandising and Dynamic Search and Navigation), you need to create database tables that support these products and features. These tables are also required if you use ATG Merchandising, ATG Search, and ATG Consumer Commerce with custom catalogs. Run the dcs_search_customcatalogs_versioned_ddl.sql script in the following directory:
<Atg2007.3dir>/DCS/Search/CustomCatalogs/Versioned/sql/
install/database-vendor
When installing tables on an evaluation copy of ATG Merchandising, the command takes this format. This command includes the default arguments used for a SOLID database:
<Atg2007.3dir>DAS\solid\i486-unknown-win32\solsql.exe "tcp 1313"
publishing publishing <Atg2007.3dir>\DCS\Search\CustomCatalogs\
Versioned\sql\install\solid\dcs_search_customcatalogs_versioned_ddl.sql
where <Atg2007.3dir> is the path to your ATG 2007.3 directory, 1313 is the port for your SOLID database, and publishing is the username and password used for the ATG Merchandising table space on SOLID.
The dcs_search_customcatalogs_versioned_ddl.sql script executes one subscript, versioned_custom_catalog_refinement_ddl.sql, which creates tables that hold extensions to the Refinement repository with support for versioning catalog assets. If necessary, you can run this subscript from the following directory:
<Atg2007.3dir>/DCS/Search/CustomCatalogs/Versioned/sql/
db_components/database-vendor
