Hi, We have a requirement to replicate Epicor production DB. the purpose is to provide full access (Global Security manager) to developers on replicated DB connected Epicor environment so that the developers don’t have access on live production DB to alter any data. The primary requirement is, de…

Agreed @Mark_Wonsil - Common tools/methods that work for both of us are certainly better… @AmilaAmarasinghe_Str never mentioned if they are cloud or not, and given the direction of Epicor, I think @markdamen and I may be re-writing our ‘scripts’ sooner than we want to be!

We have recently set up transaction replication for reporting and it works fine. As all of the code for bpms, baqs, dashboards is al in the database now, I am not sure how that would impact the dev environment. This is a link to KB0050119 on the steps needed after moving a database. https://epicor…

Didn’t Epicor offer an option for an education type environment that would replicate your live data, for users to train on?

Yes, when you purchase embedded education, they provide an environment that you use to do the “lab work.”

I have multiple test enviroments - the daily refresh one is called “MRP”, and allows us to test things that we know will get overwriten at 1am the following day. We have another called Dev, which we refresh once every few months or after a version change. We have one called UpgradeTest, which I al…

I’ll check that my SSIS package doesn’t include any passwords (shouldnt, because we use Windows Auth) and then happily share it with you.

@markdamen nd @Mark_Wonsil Thank you both for sharing the solutions. Will try both. Can you tell me what’s the size for DBs? Usually how much time does the process takes?

@MikeGross - Actually i did opened a case in Epiccare and what they mentioned is they do not have particular recommendation on what options are better and asked me to reach community here for their experience. Does anyone have experience with any other 3rd party tools such as Oracle GoldenGate?

Hi Mark Would also be interested in that as would love to automate that process. Been recently listening to The Phoenix Project on audible about IT in a large manufacturing business. Not all relevent to an SME but definately makes you think about how best to apply IT in an SME. Regards Richard

Epicor Database Replication

Epicor ERP 10

gpayne (Greg Payne) December 14, 2019, 4:15pm 11

@markdamen Thanks, I am going live in January and still working on how to do a weekly let alone nightly testng area.

Topic		Replies	Views
DB Refresh Rules of Thumb Epicor ERP 10 database-refresh	15	2462	December 6, 2018
Backup SQL - epicor 10.700.3 Yahoo Archive	13	869	April 2, 2015
In the planning stages of a 10.1.400 to 10.2.300 update Epicor ERP 10 upgrade	30	4678	August 30, 2021
Test environment Kinetic ERP	14	3313	January 19, 2023
TestEnvironment on same server as Production Epicor ERP 10 admin	15	4680	August 20, 2019

Epicor Database Replication

Related topics