I would like to know the approach to migrate following SharePoint 2010 service applications from one farm to another:
- Managed Metadata
- Project Service application
- Secure Store Service Application
For each service application, there is an underlying service application database where the real content lives. The process for each involves moving the database to the other farm SQL instance. To do that follow these steps:
Point the Service Application to the migrated service application database.
For example: if you migrated the BCS Service Database correctly and it's database name was "BCS_Service_Application" then list that as the "new" database name for a new service application and it will make the connection.