Single-Instance Multischema Deployment

A multischema deployment is another version of a single instance deployment, but with multiple database schemas. Enterprises can share the same Configuration schema but have different Transaction schemas, one for each set of enterprises. Note that each enterprise-specific Transaction schema is further associated with a Colony ID.

Note: For more detailed information about colonies, multischema tables, and how multischema features are implemented by Sterling Selling and Fulfillment Foundation, see Multischema Overview.

The following multischema deployment example shows three colonies:

In this type of deployment, the Configuration schema is shared by all three enterprises, but each enterprise has its own Transaction schema.

Following are the advantages and limitations of this multischema deployment.

Advantages

Limitations