Hi to all
Epicor has a unsupported utility for E9 called Copy/Merge that I used to move a new company’s template into a production environment – basically inserting a selected company data from one dB into another. The tool worked very well while we were on E9.
We have converted to E10 and plan to add additional companies into existing dB/Instance and looking for a script that can help with that.
Epicor claims they don’t have a script – this can be done 100% using SQL SSIS, but some columns on all tables have constrains that would be a challenge.
Does anyone have a script or have an idea how to develop one, as this needs to address all tables in the dB or at least the ERP and ICE schema
Thanks
Motty