Mid SQL

Shared Database, Shared Schema:?

  • All tenants share the same database and tables. A tenant identifier (e.g.,

tenant_id) is used to segregate data.

  • Pros: Easier to maintain and scale.
  • Cons: Can lead to security and data isolation issues.

More from SQL Server Tutorial

All questions for this course