Create the versioned core Commerce tables in order to use ATG Merchandising.
To create the required tables on your database, run the dcs_versioned_ddl.sql script located in the following directory:
<ATG9dir>/DCS/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\Versioned\sql\install\solid\
dcs_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 for the ATG Merchandising table space on SOLID.
The tables created by dcs_versioned_ddl.sql have the same names as those created by the dcs_ddl.sql script that is used to install core Commerce tables, the only difference being that some tables provided by dcs_versioned_ddl.sql have additional columns for storing data on versioned assets. Those tables are implemented by the individual scripts described in the table below. If necessary, you can run these scripts individually from the following directory:
<ATG9dir>/DCS/Versioned/sql/db_components/database-vendor
Script name | Purpose |
|---|---|
| Creates tables that support the versioning of coupons |
| Creates tables that support the versioning of price lists |
| Creates tables that support the versioning of products and catalogs |
| Creates tables that support the versioning of promotions |
