Data management (Cloud)

Overview

Sage FRP 1000 Cloud solution has been developed for SQL Azure Database.

Each production environment has its own SQL virtual server.

Small environment

In a small environment a single database may be used.

In this case both the repository master database and the production data of a single tenant may be stored in the same database.

Medium and large environments

In these environments a minimum of two databases is required.

• The repository master database base.
• A production database.

Multitenancy

A multitenancy environment, which typically is large, may uses one or several production databases.

A multi tenants repository master database :

• Is managed in shared mode

(The shared mode is the model used for multi-societies databases)

A multi tenants production database :

• May content data of several tenants.
• Has a tenant identifier in each table.

Note that one tenant data set MUST be stored inside a single database, spreading tenant's data on several databases is not supported.