In order to use ATG Merchandising, ATG Business Commerce and the add-on ATG Search features (Search Merchandising and Faceted Search), 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:
<ATG9dir>/DCS/Search/CustomCatalogs/Versioned/sql/
install/database-vendor
To install the tables on an SOLID evaluation database, open a command prompt and enter the following command, which includes the default arguments for a SOLID database:
<ATG9dir>DAS\solid\i486-unknown-win32\solsql.exe "tcp 1313"
publishing publishing <ATG9dir>\DCS\Search\CustomCatalogs\
Versioned\sql\install\solid\dcs_search_customcatalogs_versioned_ddl.sql
where <ATG9dir> is the path to your ATG 9.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 separately. It is located in the following directory:
<ATG9dir>/DCS/Search/CustomCatalogs/Versioned/sql/
db_components/database-vendor
