Here is a previous discussion around this topic. I am planning on using @markdamen’s SSIS approach just have not had the time to get it in place.
EpicCare has KB0050119 Checklist after Restoring an ERP10 Database to a different location that I usually refer to.
https://epicorcs.service-now.com/epiccare?id=epiccare_kb_article&sys_id=d78dd100db24fb44e325a334ca961971