2 ms·
Moving from a DB engine to another, even if technically possible (right abstractions and everything), is often extremely painful once you have a few years of da
by kakwa_ 6y ago
Moving from a DB engine to another, even if technically possible (right abstractions and everything), is often extremely painful once you have a few years of data.
(I'm currently involved in migrating quite a few large DBs, and it's a pain for everyone: SREs, support teams and the customers).
But yes, there is no "one size fits all", it depends pretty much on how your org is operating.
- bluGill 6y agoThat isn't the only reason to support more than one engine. Sometimes you don't need to move data to change the engine. If you sell a product that needs a database you probably want an abstraction so you can use the customer's database and schema.