0006852: Independent DB schemas for each client - Openbravo Issue Tracking System

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0006852

Openbravo ERP

A. Platform

public

2009-01-12 17:41

2009-05-22 19:33

Reporter

jtarbal

Assigned To

iciordia

Priority

normal

Severity

major

Reproducibility

always

Status

acknowledged

Resolution

open

Platform

OS Version

Product Version

2.40

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0006852: Independent DB schemas for each client

Description

Please consider the following feature request that would be of huge interest when using Openbravo ERP as a multi-client environment. It is a requirement that comes from a partner that is studying the possibility of using OB ERP in a multi-client environment.

In order to facilitate the database maintenance, it would be great if each client could have a different database schema. This way, database maintenance tasks (for example restoring a backup) would not affect other client environments.

Moreover, all the Application Dictionary metadata could be also stored in a different database schema.

With this approach, each OB ERP environment would have the following database schemas:
- 1 schema for the application dictionary data
- N schemas for the clients data where N is the number of clients

Steps To Reproduce

Proposed Solution

Additional Information