4 ms·
In 23 years I've worked on one project that moved databases. Client requirement, huge system that Oracle was the best match for. Also, one that was a licensed
by tracker1 9y ago
In 23 years I've worked on one project that moved databases. Client requirement, huge system that Oracle was the best match for.
Also, one that was a licensed software that needed to support DB2, Oracle and MS-SQL to integrate with various state's agencies. The former was a huge pain, the latter was horrible to write code for.
For the most part, you use what works for you and stick with it. The more risky a platform, the less you rely on features like stored procedures, etc. In the end, I'd rather have vendor lock-in than have to write complex queries three times, and other really cumbersome abstractions, slowing things down a lot! Extrapolating to services beyond the DB.
In the end, the db migration was far less time/effort than maintaining an untethered software.