INFO How to use one SQL Server database to store sales from multiple stores

Article # 5306

The information in this article applies to this particular SalesCart Product(s): 
SQL


SYMPTOMS
You would like to create multiple SalesCart SQL websites, but use one SQL Server database to store all sales.

CAUSE
This is an informational article on how to use one SQL Server database to store sales from multiple stores.

RESOLUTION
Create the SalesCart SQL Server database on a single machine. Create the SalesCart SQL sites on the same machine or on different machines. For each SalesCart SQL site, create a DSN that will point to the central SQL Server database.

SUMMARY
You would like to create multiple SalesCart SQL websites, but use one SQL Server database to store all sales.

STATUS
This is an informational article on how to use one SQL Server database to store sales from multiple stores.

REFERENCE
No references


Additional Query Words: central database

Active/inactive: Active
Author:
 William Cheung
Date:
 8/4/03