Recently found out that existing BDC connections don't migrate well across SharePoint on-prem farms and was wondering if anyone was aware of best practices in this area. It seems you could export it from SharePoint Designer but that is slow and tedious. Copying and mounting the Service app database didn't seem to bring over all the external content types on the old farm.

Any advice appreciated.