Databases
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. |
| Administration MSCS_Admin |
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:
- Commerce Server Database Relationships
- Commerce Server Database Connection Strings
- Connection Strings, Site Packager, and Admin Objects
- OLE DB Provider Connection Pooling
- Administration Database Tables
- Analysis/Report Database Tables
- Data Warehouse Database Tables
- Direct Mailer Database
- Campaigns Database Tables
- Prediction Database Tables
- Components of the Catalog Database
- MSCS_CatalogScratch Database
- Profiles Database Tables
- Transactions Database Tables
- TransactionConfig Database Tables
Copyright © 2005 Microsoft Corporation.
All rights reserved.