Close this search box.

To migrate data or not to migrate data?

Table of Contents

[fusion_builder_container type=”flex” hundred_percent=”no” equal_height_columns=”no” menu_anchor=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=”” background_color=”” background_image=”” background_position=”center center” background_repeat=”no-repeat” fade=”no” background_parallax=”none” parallax_speed=”0.3″ video_mp4=”” video_webm=”” video_ogv=”” video_url=”” video_aspect_ratio=”16:9″ video_loop=”yes” video_mute=”yes” overlay_color=”” video_preview_image=”” border_color=”” border_style=”solid” padding_top=”” padding_bottom=”” padding_left=”” padding_right=””][fusion_builder_row][fusion_builder_column type=”1_1″ layout=”1_1″ background_position=”left top” background_color=”” border_color=”” border_style=”solid” border_position=”all” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding_top=”” padding_right=”” padding_bottom=”” padding_left=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” center_content=”no” last=”true” min_height=”” hover_type=”none” link=”” border_sizes_top=”” border_sizes_bottom=”” border_sizes_left=”” border_sizes_right=”” first=”true”][fusion_text columns=”” column_min_width=”” column_spacing=”” rule_style=”default” rule_size=”” rule_color=”” content_alignment_medium=”” content_alignment_small=”” content_alignment=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” class=”” id=”” margin_top=”” margin_right=”” margin_bottom=”” margin_left=”” font_size=”” fusion_font_family_text_font=”” fusion_font_variant_text_font=”” line_height=”” letter_spacing=”” text_transform=”none” text_color=”” animation_type=”” animation_direction=”left” animation_speed=”0.3″ animation_offset=””]

A vital element of any new ERP system implementation comes when you migrate data. The ability to recognise useful information from legacy systems can help ease the transition between the old and the new.

The task of migrating data should be considering early in an ERP implementation cycleIt is key to the success of your project – by leaving it too late your project is at risk of abject failure. 

While it can be hard to decide which data to retain and which to cleanse, a review of legacy data is a chance to start afresh.

What data are we planning to migrate?

Breaking down your source data into distinct categories should be one of your first tasks – usually it falls into the following categories:

  • Transactional data – regularly changing data makes it harder to migrate – open sales orders, opening balances and stock on hand. 
  • Reference data – typically static data that rarely changes over a period of time, for example; country codes, tax codes, product classes etc. 
  • Catalogue data regularly changing data makes it harder to migrate – open sales orders, opening balances and stock on hand.

Each category would be migrated at different stages of the implementation, with more changeable data migrated close to the go-live date. 

It is also necessary to question whether your legacy system’s source data is of good qualityAfter all, if your business is investing in a new ERP system, why bring over any “bad data”? 

Data in your legacy system you should consider cleansing would be old customer records and addresses – as well as consolidating any repeated information 

How are we going to migrate?

It is wrong to assume that the data migration must be done automaticallyMore time and money may be spent than is necessary building complex programmes that deal with small amounts of data that could have been manually migrated. 

It must be considered what outdated data can be extracted from the legacy system, and is it worthwhile in doing soCould the data be migrated consistently – if the data is going to be migrated it must be done accurately, otherwise valuable time will be wasted and data will have to be reviewed manually in order to validate its quality 

Manual migration of data may appear daunting, especially considering the potential number of records. The effort can be quantified through a range of criteria, including: producing an estimate of the number of entries, time dedicated to entering data, and determining who will enter the data – temporary staff might workbut they would not have knowledge of the data’s context that a permanent employee might. 

Testing your Data

On large projects at least one person will be responsible for automatic data migration. During the project some customisation work may occur, so migration schemes may need regression testing to ensure that it still functions as intended during the simulation phases. 

Detailed planning is required throughout the migration and we recommend producing a summary of the migration activities and methods. All project members and sponsors should be informed to ensure they are aware of each activity’s time commitments. 

There are three main data migration methods: 

  • Transactional data – regularly changing data makes it harder to migrate – open sales orders, opening balances and stock on hand. 
  • Database import – if using SQL Server or Oracle it is possible to use a direct insert method into the database – this is a skilled approach, but has clear performance advantages.  
  • Programmatic import – programmecan be used to import data – not only ensuring the data’s integrity, but this also results in a more stable end product. 

Data migration is a vital element in any business system implementation project, and it is critical that it is given high priority in the project planning, with the requisite resources and skillsets required to ensure the overall quality of the implementation project isn’t compromised. 

If it’s not given enough thought, or considered too late in the process then your entire ERP project, or worse, your business could be damaged. 


Want to keep up with our blog?

Get our most valuable tips right inside your inbox, once per month!

Latest IT News & Insights
Microsoft Dynamics 365 Business Central Main Product Mockup Showcase ERP
Why Business Central enhances and streamlines solutions
See how Microsoft Dynamics 365 Business Central enhances business solutions and streamlines the processes...
Read More
Neuways artificial intelligence
Artificial Intelligence: The Good, The Bad & The Ugly
AI is the Marmite of the IT world. Love it or hate it, the reality is it filters into our everyday lives...
Read More
Choose Neuways for your IT Support, Cyber Security and Business Central needs.
Cyber Security Acronyms Part 1: Neuways
We are helping clients to understand cyber security. We're making it easy for you, as we are jargon busting...
Read More
Password Manager and Security with neuways
Password Managers just became an even more important tool for Employees
The Government has brought in a ban on employees and manufacturers using default passwords.
Read More
Dark Web monitoring
What is the Dark Web?
Dark Web Monitoring identifies whether any of your company data (including login credentials and confidential...
Read More
Password Manager and Security with neuways
Password Security
Business Password Manager Tool Protect your remote workforce with Password Manager Tool, the business...
Read More
WatchGuard WiFi Security
WatchGuard User Services Platform – Simple, Secure and Intelligent WiFi
Why do Neuways partner with WatchGuard? Find out below to see how we improve the cyber security of your...
Read More
Endpoint Security
Endpoint Security
Protect your business with the best in Endpoint Security – How Neuways can help you Protect Your...
Read More

Frequently Asked Questions

Managed IT support is a comprehensive solution where an expert IT provider, like Neuways, handles your technology infrastructure. This includes proactive monitoring, maintenance, cyber security, and support.

Contact us

Support: 01283 753300

Business Development: 01283 753333

Purchasing: 01283 753322

Admin and Accounts: 01283 753311


Yes we do. Your business needs Cyber Security due to the increasing number of cyber threats that are affecting businesses in all industries. If your business has data and technology systems implemented, you will need Managed Cyber Security.

Yes we can. We have our own dedicated Microsoft Dynamics 365 Business Central teams who work to ensure that we can implement the right systems and solutions into your website that are absolute right for you. 

Got a question?

Reach out
& Connect

Please enable JavaScript in your browser to complete this form.