Horizontal scaling with database schema
0
votes
0
answers
100
views
I am designing a database schema for our customers on-premise, which will be moved to Azure PaaS later.
Regarding the "scale out" strategies I lean towards to create "one database", and create schema for each and every customer to store the database objects such as tables, procedures, and views.
Although, I find little to no information how to keep track of schema changes in each and every schema, and put a version number on each.
Tools such as Liquibase or Fluentmigrator has limited support for such it seems, as they seems to be better for a single database.
What are the best practices to version, and manage database schemas in a database?
Asked by Avi
(265 rep)
Jan 17, 2022, 06:15 PM