Good call.
As an aside why not use postgres's mysql foreign data wrapper instead of syncing with the mysql database?
As an aside why not use postgres's mysql foreign data wrapper instead of syncing with the mysql database?
To directly answer your question, though, without going into too much detail, there were pci compliance issues with some tables/columns in the mysql db, so if I had to guess, perhaps DMS had the capability to assuage that concern more elegantly than mysql_fdw[0], though the mysql_fwd EXCEPT parameter seems to also do the same thing, so honestly, I have no idea.
By default, all views and tables existing in a particular database on the MySQL host are imported. Using this option, you can exclude specified foreign tables from the import.[1]
[0]: https://github.com/EnterpriseDB/mysql_fdw[1]: https://www.enterprisedb.com/docs/mysql_data_adapter/latest/...