I am using SP2013 on-premise standard edition. In a site collection we have built a local term set group with 100+ termsets. We are going to use Backup-SPSite & Restore-SPSite to copy this site collection to another SP2013 farm. As far as I understand, the local term set group is not saved in the content DB. It is saved in managed metadata DB.
How should I copy the term set group towards the new farm? I cannot directly backup/restore the managed metadata DB because the destination DB contains termsets from other site collections and we should not override it. Also we don't have DB access.
If I export the termsets into CSV and import to new environment, the terms' GUID will be changed. Then I have to go over every library and list to fix the 100+ managed metadata column.
May I have your advice on this situation? Thanks.