I am working with SQL Server and have this scenario.

• every client has their own database.
• all databases have the same structure
• Unfortunately, each database also has its own schema which matches the database name. This part is out of my control and has to do with migration from a different RDBMS and minimizing code changes.

We have a seed database that has the base structure for all new clients. Occasionally, there will be changes that need to be pushed for the seed database and all the tenant databases to their correct schemas.

For other databases I work with, we use dacpacs plus orchestration in IBM Urban Code Deplpoy (bunch of powershell scripts basically), but I’m unsure how it would work here.

Any suggestions are much appreciated.