In order to use the ATG Search add-on features (Search Merchandising and Dynamic Search and Navigation), you need to create two sets of database tables.
First, create tables that provide versioning support to ATG Search Integration. Run the versioned_refinement_ddl.sql script in the following directory:
<Atg2007.3dir>/DAF/Search/Versioned/sql/db_components/database-vendorWhen installing tables on an evaluation copy of ATG Merchandising on a SOLID database, 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>\DAF\Search\Versioned\sql
\db_components\solid\versioned_refinement_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.
Second, create database tables that support the union of ATG Merchandising, ATG Commerce and the add-on ATG Search features. Run the dcs_search_versioned_ddl.sql script in the following directory:
<Atg2007.3dir>/DCS/Search/Versioned/sql/install/database-vendorWhen 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\Versioned\sql\install\
solid\dcs_search_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.
