If you want to use ATG Merchandising with ATG Business Commerce, you need to create database tables that support the combination of these products, in addition to the tables that you create for core commerce, as described in the previous section, Creating Versioned Core Commerce Tables.
Run the b2bcommerce_versioned_ddl.sql
script located in the following directory:
<ATG9dir>
/B2BCommerce/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>
\B2BCommerce\Versioned\sql\
install\solid\b2bcommerce_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 b2bcommerce_versioned_ddl.sql
script executes one subscript, versioned_b2b_product_catalog_ddl.sql
, which creates tables that hold extensions to the ATG Business Commerce product with support for versioning. If necessary, you can run this subscript from the following directory:
<ATG9dir>/B2BCommerce/Versioned/sql/install/
database-vendor