Data Migration

Moving from your legacy system can involve some time ensuring the data migration goes smoothly. Often the process is much more difficult that it may seem. A large pitfall that often gets overlooked is data validation and integrity checking.

With MFG/Pro things are simplified. The CIM Interface offers the ability to enter data through the user interface, giving us access to data integrity checking that already exists in the system. Some tables can be loaded through the CIM interface. Some can be loaded directly and quickly into the database. All tables should be loaded into a temporary database for just this purpose.

Using our data migration tools we can format and precheck your data. We can convert any ASCII delimited source file. Some clients use tools such as MS Excel to modify their data before conversion then simply hand over the Spreadsheet for load. After we receive the datafile we perform several steps..

Erroneous data is resubmitted for corrections and the process is repeated on this subset of data. All the code is specific to each load and is stored on your system. So, it can be run as many times as you require.

Included here for your reference is a sample Data Migration Flow Diagram, extracted from a recent ERP system implementation.

If you have data migration issues, please contact us and we'll be happy to give you a competetive quotation.