{"id":282,"date":"2022-11-29T21:36:46","date_gmt":"2022-11-29T21:36:46","guid":{"rendered":"http:\/\/learnlearn.uk\/ibcs\/?page_id=282"},"modified":"2023-06-03T22:25:50","modified_gmt":"2023-06-03T22:25:50","slug":"data-migration","status":"publish","type":"page","link":"https:\/\/learnlearn.uk\/ibcs\/data-migration\/","title":{"rendered":"Data Migration"},"content":{"rendered":"<div class=\"responsive-tabs\">\n<h2 class=\"tabtitle\">Introduction<\/h2>\n<div class=\"tabcontent\">\n\n<h3>Migration Issues<\/h3>\n<p>When migrating from an old system to a new system there are a number of risk factors involved in the data transfer process.<\/p>\n<ul>\n<li>Data Loss<\/li>\n<li>Data Corruption<\/li>\n<li>Data Duplication<\/li>\n<li>Security &amp; Privacy Issues<\/li>\n<li>Timing Issues<\/li>\n<\/ul>\n<p>These issues need to be identified and managed in order to successfully migrate to the new system<\/p>\n\n<\/div><h2 class=\"tabtitle\">Loss<\/h2>\n<div class=\"tabcontent\">\n\n<h3>Data Loss<\/h3>\n<p>Data loss when transferring from an old system to a new system is a key concern.<\/p>\n<p>Data loss can occur when:<\/p>\n<ul>\n<li>Data stored on the old system is forgotten about and discarded when moved to the new system<\/li>\n<li>Data doesn&#8217;t transfer as intended to the new system<\/li>\n<li>When the new system doesn&#8217;t a have storage model that matches the existing system and there has to be deliberately discarded<\/li>\n<\/ul>\n<p>Not all data needs to be migrated from legacy system to a new system and therefore some data loss may be deliberate.<\/p>\n<p>A thorough analysis of the data models for the old and new systems needs to be undertaken in order to identify data loss risks.<\/p>\n\n<\/div><h2 class=\"tabtitle\">Corruption<\/h2>\n<div class=\"tabcontent\">\n\n<h3>Data Corruption<\/h3>\n<p>Data corruption happens when data is altered during the transfer process. This can be caused by:<\/p>\n<ul>\n<li>Incompatible storage models, where the new model has a smaller capacity than the old system<\/li>\n<li>Incompatible data encoding, such as trying to migrate Unicode to ASCII<\/li>\n<li>Timezone inconsistency when moving between systems (local time vs GMT vs UTC)<\/li>\n<\/ul>\n<p>Thorough testing and inspection of data needs to be undertaken, with special care taken with encodings and boundary cases.<\/p>\n\n<\/div><h2 class=\"tabtitle\">Duplication<\/h2>\n<div class=\"tabcontent\">\n\n<h3>Data Duplication<\/h3>\n<p>Data duplication is an issue when moving to new systems and although the duplication itself might not be an issue, it often results in:<\/p>\n<ul>\n<li>Increased storage and data processing requirements, especially when SQL queries are run on large tables<\/li>\n<li>Orphaned records that contain data that has not been correctly updated.<\/li>\n<\/ul>\n\n<\/div><h2 class=\"tabtitle\">Security Issues<\/h2>\n<div class=\"tabcontent\">\n\n<h3>Security &amp; Privacy Issues<\/h3>\n<p>Security and privacy of data are important concerns when migrating to a new system. Failure to ensure security and privacy can have serious consequences both financially and legally for the organisation. Issues include:<\/p>\n<ul>\n<li>Ensuring data is encrypted and secure during the transfer process.<\/li>\n<li>Ensuring that data to securely stored in the target system<\/li>\n<li>Ensuring that data is wiped from the legacy system<\/li>\n<li>Ensuring that those involved in the transfer process are correctly vetted and only have access to the data they need to do the job.<\/li>\n<li>Ensuring that user access privileges in the target system are set correctly to in order to maintain data privacy where appropriate<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n\n<\/div><h2 class=\"tabtitle\">Timing Issues<\/h2>\n<div class=\"tabcontent\">\n\n<h3>Timing Issues<\/h3>\n<p>Migrating data from an old system to a new system can be a time consuming and labour intensive process so the process needs to be managed in order to ensure that:<\/p>\n<ul>\n<li>Data is moved in an efficient and timely manner.<\/li>\n<li>Downtimes for systems are minimized and migration is done outside of business operational hours.<\/li>\n<li>Stakeholders are made aware in advance of any disruption and the timeframes anticipated so that they can take steps to mitigate issues that may arise.<\/li>\n<\/ul>\n\n<\/div><h2 class=\"tabtitle\">Resources<\/h2>\n<div class=\"tabcontent\">\n\n<h3>Resources<\/h3>\n<p><a href=\"https:\/\/docs.google.com\/presentation\/d\/1S38eeooW0BrbN9el-4VGOjZieKzHdBoKNAGYe7nq3bg\/edit?usp=sharing\">Teacher Presentation<\/a><\/p>\n<p><a href=\"https:\/\/www.aicurriculum.co.uk\/courses\/1\/1\/1\/3\">AI Assisted Lesson Planning &amp; Revision Resource<\/a><\/p>\n<p>&nbsp;<\/p>\n<\/div><\/div>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Migration Issues When migrating from an old system to a new system there are a number of risk factors involved in the data transfer process. Data Loss Data Corruption Data Duplication Security &amp; Privacy Issues Timing Issues These issues need to be identified and managed in order to successfully migrate to the new system Data&hellip;&nbsp;<a href=\"https:\/\/learnlearn.uk\/ibcs\/data-migration\/\" class=\"\" rel=\"bookmark\">Read More &raquo;<span class=\"screen-reader-text\">Data Migration<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"on","neve_meta_content_width":81,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Data Migration - IB Computer Science<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/learnlearn.uk\/ibcs\/data-migration\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Migration - IB Computer Science\" \/>\n<meta property=\"og:description\" content=\"Migration Issues When migrating from an old system to a new system there are a number of risk factors involved in the data transfer process. Data Loss Data Corruption Data Duplication Security &amp; Privacy Issues Timing Issues These issues need to be identified and managed in order to successfully migrate to the new system Data&hellip;&nbsp;Read More &raquo;Data Migration\" \/>\n<meta property=\"og:url\" content=\"https:\/\/learnlearn.uk\/ibcs\/data-migration\/\" \/>\n<meta property=\"og:site_name\" content=\"IB Computer Science\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-03T22:25:50+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/data-migration\/\",\"url\":\"https:\/\/learnlearn.uk\/ibcs\/data-migration\/\",\"name\":\"Data Migration - IB Computer Science\",\"isPartOf\":{\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/#website\"},\"datePublished\":\"2022-11-29T21:36:46+00:00\",\"dateModified\":\"2023-06-03T22:25:50+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/data-migration\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/learnlearn.uk\/ibcs\/data-migration\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/data-migration\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"IB Computer Science\",\"item\":\"https:\/\/learnlearn.uk\/ibcs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Migration\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/#website\",\"url\":\"https:\/\/learnlearn.uk\/ibcs\/\",\"name\":\"IB Computer Science\",\"description\":\"- learnlearn..uk\",\"publisher\":{\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/learnlearn.uk\/ibcs\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/#organization\",\"name\":\"IB Computer Science\",\"url\":\"https:\/\/learnlearn.uk\/ibcs\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2022\/09\/LearnLearnLogowhite-300x41.png\",\"contentUrl\":\"https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2022\/09\/LearnLearnLogowhite-300x41.png\",\"width\":300,\"height\":41,\"caption\":\"IB Computer Science\"},\"image\":{\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Migration - IB Computer Science","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:\/\/learnlearn.uk\/ibcs\/data-migration\/","og_locale":"en_GB","og_type":"article","og_title":"Data Migration - IB Computer Science","og_description":"Migration Issues When migrating from an old system to a new system there are a number of risk factors involved in the data transfer process. Data Loss Data Corruption Data Duplication Security &amp; Privacy Issues Timing Issues These issues need to be identified and managed in order to successfully migrate to the new system Data&hellip;&nbsp;Read More &raquo;Data Migration","og_url":"https:\/\/learnlearn.uk\/ibcs\/data-migration\/","og_site_name":"IB Computer Science","article_modified_time":"2023-06-03T22:25:50+00:00","twitter_card":"summary_large_image","twitter_misc":{"Estimated reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/learnlearn.uk\/ibcs\/data-migration\/","url":"https:\/\/learnlearn.uk\/ibcs\/data-migration\/","name":"Data Migration - IB Computer Science","isPartOf":{"@id":"https:\/\/learnlearn.uk\/ibcs\/#website"},"datePublished":"2022-11-29T21:36:46+00:00","dateModified":"2023-06-03T22:25:50+00:00","breadcrumb":{"@id":"https:\/\/learnlearn.uk\/ibcs\/data-migration\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/learnlearn.uk\/ibcs\/data-migration\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/learnlearn.uk\/ibcs\/data-migration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"IB Computer Science","item":"https:\/\/learnlearn.uk\/ibcs\/"},{"@type":"ListItem","position":2,"name":"Data Migration"}]},{"@type":"WebSite","@id":"https:\/\/learnlearn.uk\/ibcs\/#website","url":"https:\/\/learnlearn.uk\/ibcs\/","name":"IB Computer Science","description":"- learnlearn..uk","publisher":{"@id":"https:\/\/learnlearn.uk\/ibcs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/learnlearn.uk\/ibcs\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/learnlearn.uk\/ibcs\/#organization","name":"IB Computer Science","url":"https:\/\/learnlearn.uk\/ibcs\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/learnlearn.uk\/ibcs\/#\/schema\/logo\/image\/","url":"https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2022\/09\/LearnLearnLogowhite-300x41.png","contentUrl":"https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2022\/09\/LearnLearnLogowhite-300x41.png","width":300,"height":41,"caption":"IB Computer Science"},"image":{"@id":"https:\/\/learnlearn.uk\/ibcs\/#\/schema\/logo\/image\/"}}]}},"rttpg_featured_image_url":null,"rttpg_author":{"display_name":"learnlearnadmin","author_link":"https:\/\/learnlearn.uk\/ibcs\/author\/learnlearnadmin\/"},"rttpg_comment":0,"rttpg_category":null,"rttpg_excerpt":"Migration Issues When migrating from an old system to a new system there are a number of risk factors involved in the data transfer process. Data Loss Data Corruption Data Duplication Security &amp; Privacy Issues Timing Issues These issues need to be identified and managed in order to successfully migrate to the new system Data&hellip;&nbsp;Read&hellip;","_links":{"self":[{"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/pages\/282"}],"collection":[{"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/comments?post=282"}],"version-history":[{"count":7,"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/pages\/282\/revisions"}],"predecessor-version":[{"id":659,"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/pages\/282\/revisions\/659"}],"wp:attachment":[{"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/media?parent=282"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}