> It is strange that there aren't more writeups on Postgresql migrations.
It's probably because switching databases is very painful and rare.
I would think that not having to pay the Oracle/MS/Sybase/Teradata licenses are a good enough incentive...
Speaking of economic incentives.
That could be a thesis topic for my hereto unwritten PhD in Behavioral Economics:
"Choosing to pay" What are the behavioral aspects of top leadership - Why do people still chose proprietary" A quantitative case study."
If I had to wager, it's support. Oracle/MS generally provide much better support that open source software.
Oracle is definitely not known for their good support, and there are plenty of companies which provide really good PostgreSQL support.
Re:New in PostgreSQL 10
by irrational on Friday September 22, 2017 @01:02PM
(#15313886)
This. It was worth it, but it still took us the better part of a year.
Re:New in PostgreSQL 10
by sharninder on Friday September 22, 2017 @05:05AM
(#15310423)
Another one here:
It is strange that there aren't more writeups on Postgresql migrations.
Yandex had a good one. Posted here a long while ago: https://news.ycombinator.com/item?id=12489055