{"id":102139,"date":"2021-03-17T00:00:00","date_gmt":"2021-03-17T04:00:00","guid":{"rendered":"https:\/\/sisn.com\/5-best-practices-for-data-migration-projects-2\/"},"modified":"2025-12-18T02:02:11","modified_gmt":"2025-12-18T07:02:11","slug":"5-best-practices-for-data-migration-projects","status":"publish","type":"post","link":"https:\/\/sisn.com\/en-gb\/5-best-practices-for-data-migration-projects\/","title":{"rendered":"5 Best Practises for Data Migration Projects"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"102139\" class=\"elementor elementor-102139 elementor-100616\" data-elementor-post-type=\"post\">\n\t\t\t\t<div class=\"elementor-element elementor-element-216bc9d e-flex e-con-boxed e-con e-parent\" data-id=\"216bc9d\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-29b68a0f elementor-widget elementor-widget-text-editor\" data-id=\"29b68a0f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div id=\"fws_67ad2b47d0d41\" class=\"wpb_row vc_row-fluid vc_row\" data-column-margin=\"default\" data-midnight=\"dark\"><div class=\"row_col_wrap_12 col span_12 dark left\"><div class=\"vc_col-sm-12 wpb_column column_container vc_column_container col no-extra-padding inherit_tablet inherit_phone \" data-padding-pos=\"all\" data-has-bg-color=\"false\" data-bg-color=\"\" data-bg-opacity=\"1\" data-animation=\"\" data-delay=\"0\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\"><div class=\"wpb_text_column wpb_content_element \"><div class=\"wpb_wrapper\"><p>Data is the driver of most modern businesses and that means data integration and data migration need to be a well-established, seamless processes \u2014 whether data is migrating from one repository to another or moving your data to the Cloud.<\/p><p>The migration of data as part of enterprise systems migration projects can turn into a tricky process that without careful planning can get easily out of control resulting in missed deadlines, excessive consumption of man hours, data errors, and ultimately projects that end up overbudget and behind schedule. To minimise these risks, a good planning and the use of best practises are critical to make this process not just repeatable making it incrementally efficient but evolutionary in a way that the quality of the data improves with every iteration.<\/p><p>In these kind of projects, resolving data quality issues can get quite complex very easily, and this is precipitated when a good planning phase is overlooked, rushing the beginning of the process to start loading templates quickly, feeling that real progress is being made. The risk with this approach is that bad data still needs to be cleaned up before it can be loaded and this is usually done in the populated template, a place where it takes the most effort to clean the data and where the risk of errors is greater.<\/p><p>To avoid these situations, we present 5 best practises to improve the quality of data during a migration project.<\/p><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div id=\"fws_67ad2b47d13fa\" class=\"wpb_row vc_row-fluid vc_row\" data-column-margin=\"default\" data-midnight=\"dark\"><div class=\"row-bg-wrap\" data-bg-animation=\"none\" data-bg-animation-delay=\"\" data-bg-overlay=\"false\"><div class=\"inner-wrap row-bg-layer\"><div class=\"row-bg viewport-desktop\">\u00a0<\/div><\/div><\/div><div class=\"row_col_wrap_12 col span_12 dark left\"><div class=\"vc_col-sm-12 wpb_column column_container vc_column_container col no-extra-padding inherit_tablet inherit_phone \" data-padding-pos=\"all\" data-has-bg-color=\"false\" data-bg-color=\"\" data-bg-opacity=\"1\" data-animation=\"\" data-delay=\"0\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\"><div class=\"wpb_text_column wpb_content_element \"><div class=\"wpb_wrapper\"><h2>1. Keep versions of data extracts<\/h2><p>A typical data migration project involves the use of so-called database \u201cstaging tables\u201d. Staging tables are used as a temporary place to hold snapshots of data where it can then be analysed, manipulated and validated before being loaded to the target system. Every time a new set of data is loaded to staging tables an identifier for the dataset should be assigned to the records in order to be able to track changes to the data as the migration project progresses. Another reason why keeping versions of the data is important is to be able to track the changes in the source system that occur when records are added, modified or deleted during the day to day business operations. Moreover, keeping versions of the data helps identifying datasets with labels like original, validated, extracts from target, etc.<\/p><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div id=\"fws_67ad2b47d16b1\" class=\"wpb_row vc_row-fluid vc_row\" data-column-margin=\"default\" data-midnight=\"dark\"><div class=\"row-bg-wrap\" data-bg-animation=\"none\" data-bg-animation-delay=\"\" data-bg-overlay=\"false\"><div class=\"inner-wrap row-bg-layer\"><div class=\"row-bg viewport-desktop\">\u00a0<\/div><\/div><\/div><div class=\"row_col_wrap_12 col span_12 dark left\"><div class=\"vc_col-sm-12 wpb_column column_container vc_column_container col no-extra-padding inherit_tablet inherit_phone \" data-padding-pos=\"all\" data-has-bg-color=\"false\" data-bg-color=\"\" data-bg-opacity=\"1\" data-animation=\"\" data-delay=\"0\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\"><div class=\"wpb_text_column wpb_content_element \"><div class=\"wpb_wrapper\"><h2>2. Use code mapping routinely<\/h2><p>Maintaining a table with the mapping of codes between the source and destination systems ensures that these values will exist in a single location facilitating its maintenance in case they change and in order to minimise the risks for errors. Code mapping does not have to be limited to source and destination identifiers for entities, we recommend them for any code that needs a translation no matter the number of records it has. In the same way as staging tables, code maps should be versioned to track any changes and maintain the history of past data extracts in case they are needed.<\/p><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div id=\"fws_67ad2b47d1919\" class=\"wpb_row vc_row-fluid vc_row\" data-column-margin=\"default\" data-midnight=\"dark\"><div class=\"row-bg-wrap\" data-bg-animation=\"none\" data-bg-animation-delay=\"\" data-bg-overlay=\"false\"><div class=\"inner-wrap row-bg-layer\"><div class=\"row-bg viewport-desktop\">\u00a0<\/div><\/div><\/div><div class=\"row_col_wrap_12 col span_12 dark left\"><div class=\"vc_col-sm-12 wpb_column column_container vc_column_container col no-extra-padding inherit_tablet inherit_phone \" data-padding-pos=\"all\" data-has-bg-color=\"false\" data-bg-color=\"\" data-bg-opacity=\"1\" data-animation=\"\" data-delay=\"0\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\"><div class=\"wpb_text_column wpb_content_element \"><div class=\"wpb_wrapper\"><h2>3. Use an incremental approach to improve data quality and reduce times<\/h2><p>A successful data migration process should always aim for improving the quality of the data with every extract, transform, and load iteration. This means that rather than starting every extract with a fresh dataset, it should start with the last successfully and already validated one and compare it to the current snapshot from source and work on the differences, also called \u201cdeltas\u201d. Differences between datasets should include records that were added after the last extract, records that were changed, records that were deleted, and records that no longer meet the extraction criteria. By using this approach records that are not changed do not have to be validated again since they have already been successfully loaded, the ones deleted or that no longer meet the include\/exclude criteria are removed, so the focus of the transformations and validations is on the new and the updated ones only. This is particularly important when the datasets are big because it reduces the transformation and validation processing time.<\/p><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div id=\"fws_67ad2b47d1c80\" class=\"wpb_row vc_row-fluid vc_row\" data-column-margin=\"default\" data-midnight=\"dark\"><div class=\"row-bg-wrap\" data-bg-animation=\"none\" data-bg-animation-delay=\"\" data-bg-overlay=\"false\"><div class=\"inner-wrap row-bg-layer\"><div class=\"row-bg viewport-desktop\">\u00a0<\/div><\/div><\/div><div class=\"row_col_wrap_12 col span_12 dark left\"><div class=\"vc_col-sm-12 wpb_column column_container vc_column_container col no-extra-padding inherit_tablet inherit_phone \" data-padding-pos=\"all\" data-has-bg-color=\"false\" data-bg-color=\"\" data-bg-opacity=\"1\" data-animation=\"\" data-delay=\"0\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\"><div class=\"wpb_text_column wpb_content_element \"><div class=\"wpb_wrapper\"><h2>4. Apply exclude\/include rules when extracting and validations on staging tables<\/h2><p>The extraction of data from source should just include the criteria that considers which records have to be included in the snapshot. Examples of these criteria include active or inactive customers and vendors; inventory items without activity in the last year; transaction history after a certain date, etc. The main purpose is to reduce as much as possible the size of a given dataset making it easier to manipulate in future steps. Validations should take place once a snapshot of data is loaded to a staging table and records marked valid only if they meet all the criteria. Some examples of validations include required fields, valid lengths, mapped values from source to target, dependencies on other entities, etc.<\/p><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div id=\"fws_67ad2b47d1f18\" class=\"wpb_row vc_row-fluid vc_row\" data-column-margin=\"default\" data-midnight=\"dark\"><div class=\"row-bg-wrap\" data-bg-animation=\"none\" data-bg-animation-delay=\"\" data-bg-overlay=\"false\"><div class=\"inner-wrap row-bg-layer\"><div class=\"row-bg viewport-desktop\">\u00a0<\/div><\/div><\/div><div class=\"row_col_wrap_12 col span_12 dark left\"><div class=\"vc_col-sm-12 wpb_column column_container vc_column_container col no-extra-padding inherit_tablet inherit_phone \" data-padding-pos=\"all\" data-has-bg-color=\"false\" data-bg-color=\"\" data-bg-opacity=\"1\" data-animation=\"\" data-delay=\"0\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\"><div class=\"wpb_text_column wpb_content_element \"><div class=\"wpb_wrapper\"><h2>5. Source control of extract and validation scripts<\/h2><p>Data migration project requirements evolve and change with every iteration. For this reason, keeping scripts used to extract, transform, and load data under version control is a very important practise. Version controlling scripts not only preserves the history of changes made to an extraction or transformation rule but is useful to understand what changes have been made through each extract and load iteration.<\/p><p>In this post we enlist 5 recommendations that data migration projects should consider to be successful. The nature of data migration projects turns them into very complex and resource intensive efforts. Including best practises from the beginning, contributes to improving data quality by reducing errors and improving the time it takes to finish every extract and load iteration with the ultimate goal of this being a smooth process when the final loads are made before going live.<\/p><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div id=\"fws_67ad2b47d218f\" class=\"wpb_row vc_row-fluid vc_row\" data-column-margin=\"default\" data-midnight=\"dark\"><div class=\"row-bg-wrap\" data-bg-animation=\"none\" data-bg-animation-delay=\"\" data-bg-overlay=\"false\"><div class=\"inner-wrap row-bg-layer\"><div class=\"row-bg viewport-desktop\">\u00a0<\/div><\/div><\/div><div class=\"row_col_wrap_12 col span_12 dark left\"><div class=\"vc_col-sm-12 wpb_column column_container vc_column_container col no-extra-padding inherit_tablet inherit_phone \" data-padding-pos=\"all\" data-has-bg-color=\"false\" data-bg-color=\"\" data-bg-opacity=\"1\" data-animation=\"\" data-delay=\"0\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\"><div class=\"wpb_text_column wpb_content_element \"><div class=\"wpb_wrapper\"><h3><em>If your organisation is upgrading systems, moving to the cloud, or consolidating data, a data migration is on the horizon. It\u2019s a big and important project, and the integrity of the data demands that it gets done right.\u00a0Contact SIS for more information.<\/em><\/h3><\/div><\/div><\/div><\/div><\/div><\/div><\/div><h3>\u00a0<\/h3>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Data is the driver of most modern businesses and that means data integration and data migration need to be a well-established, seamless processes \u2014 whether data is migrating from one repository to another or moving your data to the Cloud. The migration of data as part of enterprise systems migration projects can turn into a&hellip;<\/p>\n","protected":false},"author":1,"featured_media":102141,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[363,364],"tags":[],"class_list":["post-102139","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","category-d365"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.5 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>5 Best Practises for Data Migration Projects | Construction ERP<\/title>\n<meta name=\"description\" content=\"SIS is the leading provider of Microsoft Dynamics 365 Enterprise Resource Planning (ERP), Project Management, and accounting solutions for contractors and professional service companies.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sisn.com\/5-best-practices-for-data-migration-projects\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"5 Best Practises for Data Migration Projects\" \/>\n<meta property=\"og:description\" content=\"SIS is the leading provider of Microsoft Dynamics 365 Enterprise Resource Planning (ERP), Project Management, and accounting solutions for contractors and professional service companies.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sisn.com\/5-best-practices-for-data-migration-projects\/\" \/>\n<meta property=\"og:site_name\" content=\"Construction ERP\" \/>\n<meta property=\"article:published_time\" content=\"2021-03-17T04:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-18T07:02:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sisn.com\/wp-content\/uploads\/2021\/03\/microoft-dynamics-365-customer-service-erp-software.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1600\" \/>\n\t<meta property=\"og:image:height\" content=\"480\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"678pcdemo_fvnkgi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"678pcdemo_fvnkgi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sisn.com\\\/5-best-practices-for-data-migration-projects\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sisn.com\\\/5-best-practices-for-data-migration-projects\\\/\"},\"author\":{\"name\":\"678pcdemo_fvnkgi\",\"@id\":\"https:\\\/\\\/sisn.com\\\/#\\\/schema\\\/person\\\/3cef1e78639c3900321c3e2109afa37f\"},\"headline\":\"5 Best Practises for Data Migration Projects\",\"datePublished\":\"2021-03-17T04:00:00+00:00\",\"dateModified\":\"2025-12-18T07:02:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sisn.com\\\/5-best-practices-for-data-migration-projects\\\/\"},\"wordCount\":987,\"publisher\":{\"@id\":\"https:\\\/\\\/sisn.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sisn.com\\\/5-best-practices-for-data-migration-projects\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sisn.com\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/microoft-dynamics-365-customer-service-erp-software.jpeg\",\"articleSection\":[\"Blog\",\"D365\"],\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sisn.com\\\/5-best-practices-for-data-migration-projects\\\/\",\"url\":\"https:\\\/\\\/sisn.com\\\/5-best-practices-for-data-migration-projects\\\/\",\"name\":\"5 Best Practises for Data Migration Projects | Construction ERP\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sisn.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sisn.com\\\/5-best-practices-for-data-migration-projects\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sisn.com\\\/5-best-practices-for-data-migration-projects\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sisn.com\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/microoft-dynamics-365-customer-service-erp-software.jpeg\",\"datePublished\":\"2021-03-17T04:00:00+00:00\",\"dateModified\":\"2025-12-18T07:02:11+00:00\",\"description\":\"SIS is the leading provider of Microsoft Dynamics 365 Enterprise Resource Planning (ERP), Project Management, and accounting solutions for contractors and professional service companies.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sisn.com\\\/5-best-practices-for-data-migration-projects\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sisn.com\\\/5-best-practices-for-data-migration-projects\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/sisn.com\\\/5-best-practices-for-data-migration-projects\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sisn.com\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/microoft-dynamics-365-customer-service-erp-software.jpeg\",\"contentUrl\":\"https:\\\/\\\/sisn.com\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/microoft-dynamics-365-customer-service-erp-software.jpeg\",\"width\":1600,\"height\":480},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sisn.com\\\/5-best-practices-for-data-migration-projects\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sisn.com\\\/en-gb\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"5 Best Practises for Data Migration Projects\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sisn.com\\\/#website\",\"url\":\"https:\\\/\\\/sisn.com\\\/\",\"name\":\"Construction ERP with Microsoft & SIS\",\"description\":\"End-to-end project accounting built on Microsoft Dynamics 365\",\"publisher\":{\"@id\":\"https:\\\/\\\/sisn.com\\\/#organization\"},\"alternateName\":\"SIS\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sisn.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/sisn.com\\\/#organization\",\"name\":\"SIS\",\"url\":\"https:\\\/\\\/sisn.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/sisn.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/sisn.com\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/500x500-sis-white-background-and-border-1.jpg\",\"contentUrl\":\"https:\\\/\\\/sisn.com\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/500x500-sis-white-background-and-border-1.jpg\",\"width\":500,\"height\":500,\"caption\":\"SIS\"},\"image\":{\"@id\":\"https:\\\/\\\/sisn.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/company\\\/793109\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/sisn.com\\\/#\\\/schema\\\/person\\\/3cef1e78639c3900321c3e2109afa37f\",\"name\":\"678pcdemo_fvnkgi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/df04eed432d74f4b55c38baa33d639a114a7940a4056a30b712a7cdc59655b11?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/df04eed432d74f4b55c38baa33d639a114a7940a4056a30b712a7cdc59655b11?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/df04eed432d74f4b55c38baa33d639a114a7940a4056a30b712a7cdc59655b11?s=96&d=mm&r=g\",\"caption\":\"678pcdemo_fvnkgi\"},\"sameAs\":[\"http:\\\/\\\/sisn.com\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"5 Best Practises for Data Migration Projects | Construction ERP","description":"SIS is the leading provider of Microsoft Dynamics 365 Enterprise Resource Planning (ERP), Project Management, and accounting solutions for contractors and professional service companies.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/sisn.com\/5-best-practices-for-data-migration-projects\/","og_locale":"en_GB","og_type":"article","og_title":"5 Best Practises for Data Migration Projects","og_description":"SIS is the leading provider of Microsoft Dynamics 365 Enterprise Resource Planning (ERP), Project Management, and accounting solutions for contractors and professional service companies.","og_url":"https:\/\/sisn.com\/5-best-practices-for-data-migration-projects\/","og_site_name":"Construction ERP","article_published_time":"2021-03-17T04:00:00+00:00","article_modified_time":"2025-12-18T07:02:11+00:00","og_image":[{"width":1600,"height":480,"url":"https:\/\/sisn.com\/wp-content\/uploads\/2021\/03\/microoft-dynamics-365-customer-service-erp-software.jpeg","type":"image\/jpeg"}],"author":"678pcdemo_fvnkgi","twitter_card":"summary_large_image","twitter_misc":{"Written by":"678pcdemo_fvnkgi","Estimated reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sisn.com\/5-best-practices-for-data-migration-projects\/#article","isPartOf":{"@id":"https:\/\/sisn.com\/5-best-practices-for-data-migration-projects\/"},"author":{"name":"678pcdemo_fvnkgi","@id":"https:\/\/sisn.com\/#\/schema\/person\/3cef1e78639c3900321c3e2109afa37f"},"headline":"5 Best Practises for Data Migration Projects","datePublished":"2021-03-17T04:00:00+00:00","dateModified":"2025-12-18T07:02:11+00:00","mainEntityOfPage":{"@id":"https:\/\/sisn.com\/5-best-practices-for-data-migration-projects\/"},"wordCount":987,"publisher":{"@id":"https:\/\/sisn.com\/#organization"},"image":{"@id":"https:\/\/sisn.com\/5-best-practices-for-data-migration-projects\/#primaryimage"},"thumbnailUrl":"https:\/\/sisn.com\/wp-content\/uploads\/2021\/03\/microoft-dynamics-365-customer-service-erp-software.jpeg","articleSection":["Blog","D365"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/sisn.com\/5-best-practices-for-data-migration-projects\/","url":"https:\/\/sisn.com\/5-best-practices-for-data-migration-projects\/","name":"5 Best Practises for Data Migration Projects | Construction ERP","isPartOf":{"@id":"https:\/\/sisn.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sisn.com\/5-best-practices-for-data-migration-projects\/#primaryimage"},"image":{"@id":"https:\/\/sisn.com\/5-best-practices-for-data-migration-projects\/#primaryimage"},"thumbnailUrl":"https:\/\/sisn.com\/wp-content\/uploads\/2021\/03\/microoft-dynamics-365-customer-service-erp-software.jpeg","datePublished":"2021-03-17T04:00:00+00:00","dateModified":"2025-12-18T07:02:11+00:00","description":"SIS is the leading provider of Microsoft Dynamics 365 Enterprise Resource Planning (ERP), Project Management, and accounting solutions for contractors and professional service companies.","breadcrumb":{"@id":"https:\/\/sisn.com\/5-best-practices-for-data-migration-projects\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sisn.com\/5-best-practices-for-data-migration-projects\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/sisn.com\/5-best-practices-for-data-migration-projects\/#primaryimage","url":"https:\/\/sisn.com\/wp-content\/uploads\/2021\/03\/microoft-dynamics-365-customer-service-erp-software.jpeg","contentUrl":"https:\/\/sisn.com\/wp-content\/uploads\/2021\/03\/microoft-dynamics-365-customer-service-erp-software.jpeg","width":1600,"height":480},{"@type":"BreadcrumbList","@id":"https:\/\/sisn.com\/5-best-practices-for-data-migration-projects\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sisn.com\/en-gb\/"},{"@type":"ListItem","position":2,"name":"5 Best Practises for Data Migration Projects"}]},{"@type":"WebSite","@id":"https:\/\/sisn.com\/#website","url":"https:\/\/sisn.com\/","name":"Construction ERP with Microsoft & SIS","description":"End-to-end project accounting built on Microsoft Dynamics 365","publisher":{"@id":"https:\/\/sisn.com\/#organization"},"alternateName":"SIS","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sisn.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/sisn.com\/#organization","name":"SIS","url":"https:\/\/sisn.com\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/sisn.com\/#\/schema\/logo\/image\/","url":"https:\/\/sisn.com\/wp-content\/uploads\/2025\/01\/500x500-sis-white-background-and-border-1.jpg","contentUrl":"https:\/\/sisn.com\/wp-content\/uploads\/2025\/01\/500x500-sis-white-background-and-border-1.jpg","width":500,"height":500,"caption":"SIS"},"image":{"@id":"https:\/\/sisn.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/793109"]},{"@type":"Person","@id":"https:\/\/sisn.com\/#\/schema\/person\/3cef1e78639c3900321c3e2109afa37f","name":"678pcdemo_fvnkgi","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/df04eed432d74f4b55c38baa33d639a114a7940a4056a30b712a7cdc59655b11?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/df04eed432d74f4b55c38baa33d639a114a7940a4056a30b712a7cdc59655b11?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/df04eed432d74f4b55c38baa33d639a114a7940a4056a30b712a7cdc59655b11?s=96&d=mm&r=g","caption":"678pcdemo_fvnkgi"},"sameAs":["http:\/\/sisn.com"]}]}},"_links":{"self":[{"href":"https:\/\/sisn.com\/en-gb\/wp-json\/wp\/v2\/posts\/102139","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sisn.com\/en-gb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sisn.com\/en-gb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sisn.com\/en-gb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sisn.com\/en-gb\/wp-json\/wp\/v2\/comments?post=102139"}],"version-history":[{"count":10,"href":"https:\/\/sisn.com\/en-gb\/wp-json\/wp\/v2\/posts\/102139\/revisions"}],"predecessor-version":[{"id":106207,"href":"https:\/\/sisn.com\/en-gb\/wp-json\/wp\/v2\/posts\/102139\/revisions\/106207"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sisn.com\/en-gb\/wp-json\/wp\/v2\/media\/102141"}],"wp:attachment":[{"href":"https:\/\/sisn.com\/en-gb\/wp-json\/wp\/v2\/media?parent=102139"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sisn.com\/en-gb\/wp-json\/wp\/v2\/categories?post=102139"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sisn.com\/en-gb\/wp-json\/wp\/v2\/tags?post=102139"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}