We are working on various solutions to incrementally replication Epicor data. The challenge is Epicor does not allow cdc and while some tables have fields indicating last change date and another one for time but it is not consistent. We attempted to create a trigger solution to capturing any time a row changed but this would cause deadlocks and system performance issues. Epicor also has a trigger option but this will cause significant performance issues on the front end. Our last resort maybe to replicate the server and set up cdc on the replicated server. While viable there has to be a better solution than this and I thought maybe someone could help me here.
Question
Any one using cdata to incrementally replicate data from Epicor
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

