We’ve decided that for testing before go-live, we’re wiping our pilot environment, then re-populating it with static data. Our intention is to do multiple iterations of this. Due to how long it takes to DMT static data into an environment (10s of thousands of parts, BOOs, BOMS) it’s severely slowin…

Are you on prem or cloud? Can you backup the database after your initial data upload? Then when you need to refresh it should be pretty quick since it’s just a restore.

Thanks for your response, Cloud for me. It’s a good point and yes, we can up to a point, functions, BAQs, BPMs are fine to be “baked-in” because they’re easy to change at any point should an issue arise. However most of the testing we’re doing at the moment is ensuring correctness of the parts, B…

Yes, you can script and run DMTs in parallel just fine. Most of the time I find that just causes RPM to roughly divide in two. YOu may get better perf running DMT from separate clients, but I havn’t tried that. Eventually when some bits are more or less in a ‘done’ state you can dmt them into Liv…

Multiple DMT from different clients are possible, mileage mar vary. AS @jbooker says, the iterative approach moving confirmed config items into Live, restore live to Pilot and so on. There is the diff tool which you can also use to manage just importing the difference. Open trans are the last thin…

There’s an old post on here somewhere in which someone shared a set of 99+ BAQs. Roughly one for each DMT template for use when onboarding. Basically when you get a working subset in pilot, you can run Dmt -export from pilot and then Dmt into live. Found it very helpful for scripting. Have looked …

I got 99 problems but a BAQ ain’t one

SQL-to-BAQ converter supports SELECT * Syntax, So failing other efforts, you can methodically: SELECT * FROM Erp.Part - etc. Then, run these in DMT with the -UseFieldNames parameter and they output in a format that DMT likes. the #optionaltables you’d have to get creative with.

[image] jbooker: someone shared a set of 99+ BAQs Foegot that one thanks for the reminder

@jbooker Was it this one? [image] Cloning a company with BAQ Export / DMT Epicor ERP 10 We are deploying a few new companies in Epicor this year, part of a distribution network where the companies will share a lot of commonality and are part of a parent child structure. …

Yeah that’s the one. Thanks for finding it. I’ve wanted to say thanks to the OP for a while now. Done. I extracted his cab files and imported the many BAQs. His excellent work saved me designing BAQs to match every DMT template. Then I created a “baq_BAQueries” to return the list of BAQs and m…

Is there a better way to reset an environment?

Kinetic ERP

Hally (Simon Hall) April 6, 2026, 10:21am 10

@jbooker Was it this one?

Topic		Replies	Views
Can I export with DMT? Epicor ERP 10 dmt	14	7461	August 13, 2019
Need Help - Building Function to Dump Tables before Environment Reset Kinetic ERP	49	1647	July 29, 2024
Copy Live to Another Environment (Automated) Kinetic ERP	4	94	July 8, 2026
DMT Batch File Kinetic ERP dmt , e10	34	4323	November 13, 2022
Transfer part from one environment to another Epicor ERP 10 dmt , part , transfer	2	580	August 20, 2020

Is there a better way to reset an environment?

Related topics