Hacker News new | ask | show | jobs
by pegas1 2117 days ago
you add the tenantId to each table and you add it to the primary key of the table too. then you just merge.
1 comments

“Just”. Depends on the number of tenants and how divergent they are.

I would incrementally bring tenants together into a single DB.

There are also some limitations if using something like rails / activerecord which doesn't support composite primary keys natively