Data Scrubber Utility

Epicor ERP 10
2

The approach that I would recommend as someone who supports customers with upgrade/migration issues:

  1. run the 8.03.40x scrubber against a backup of your live database. Any failures, request the fixers from Support at 8.03.40x.

  2. Upgrade from 8.03.4xx to 8.03.410.

  3. Upgrade to 9.05.702a via the DUU.

  4. Request and run the 9.05.702a scrubber against the upgraded 9.05.702a database. Any failures, request the fixers from Support at 9.05.702a.
    NOTE: if there are failures, you’ll have to run the fixers during your go-live pass so plan for that. If there weren’t any failures, then running the “checker” part of the scrubbers is all that needs to be completed during your go-live pass as a just in case measure.

  5. Migrate to 10.1.500.x.

  6. Run the E10.1.500.x native version of what used to be called the 10080 conversion to bring over historical financial data (if you were 8.03.4xx SQL - if you are Progress, then you need to run the 10080 at the 9.05.702a level before step 5 which can take between 5 minutes and 3 days +/- 3 minutes (so please go through a few trial runs to get the timings down). ** Read below for a bit more commentary on this.

  7. Request and run the Health Checker (aka: what we are calling the Scrubbers - we’re rebranding the utility a bit) at 10.1.500.x .

  8. Repeat step 7 on a regular scheduled basis after go-live at 10.1.500.x or whenever requested by Support.

** When using the DUU process, 10080 is technically available to execute when the database is at the 9.04.508 level after mandatory database conversions and it runs much, much faster than when run at 9.05.702a as the source data is in the same database as the destination in E904 but not in E905. Please do not be tempted to run 10080 at 9.04.508 because the 10080 at 9.04.508 is not the same as 9.05.702a and there are changes to this conversion at 9.05.702a that are needed for a successful upgrade/migration.

TL;DR: 10080 at 9.04.508 if Progress/SQL = :cry: , 10080 at 9.05.702a if Progress/SQL = :slight_smile:, “10080” natively in 10.1.500.x instead of running it at 9.05.702a if SQL at 8.03/9.04 = :grinning:

Hope that helps

5 Likes