Data management (Cloud)
Overview
Sage FRP 1000 Cloud solution has been developed to use 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 may use one or several production databases.
A multi tenants repository master database :
- Is managed in shared mode
- (The shared mode is the model use 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 set on several databases is not supported.