TRANSITIONING BETWEEN SYSTEM SHARING TYPES IN MULTI-TENANCY DATABASE SYSTEMS

The present disclosure involves systems, software, and computer implemented methods for transitioning between database system sharing types. One example method includes identifying a tenant container that includes a read-only table, a first writable table, and a mixed table for storing read-only and writable data. A shared container is created. A shared table is created in the shared container. Data is copied from the read-only table to the shared table. The read-only table is dropped. A read-only view is created in the tenant container. A second shared table is created in the shared container. Read-only mixed data is copied from the mixed table to the second shared table and deleted from the mixed table. The mixed table is renamed to be the second writable table. A union view is created that provides unified access to the second shared table and the second writable table.