At first glance, migrating data from one database to another looks trivial: you can easily discover the schema or datamodel of each database, then simply map the elements of one to the other. Any ETL tool worth its acronym will let you do that.
In practice, migration is a nightmare…