The following table lists the databases that are typically used in a Commerce Server site. Depending on the features and configuration you choose for your site, you might have additional databases, or fewer databases.

You specify the connection strings for these databases during the setup and the unpacking process. However, you can change the connection strings by using Commerce Server Manager.

Database and name Description
Commerce Server
<site name>_commerce
Data for catalogs, campaigns, transactions, profiles, and events.
Configuration data used by Commerce Server.
Data Warehouse
<site name>_dw
Day-to-day operational data about users who visit your site, such as user profile data, transaction data, and click-history data. This data is imported from Web log files and Commerce Server databases using Commerce Server Data Transformation Services (DTS) tasks.
Direct Mailer Data for mailing lists, messages, and events.

This section contains:

Copyright © 2005 Microsoft Corporation.
All rights reserved.