{"id":723,"date":"2019-06-21T21:13:10","date_gmt":"2019-06-21T21:13:10","guid":{"rendered":"https:\/\/ricardomoinhos.com\/?p=723"},"modified":"2021-09-29T10:01:04","modified_gmt":"2021-09-29T09:01:04","slug":"c-side-to-al-table-data-migration","status":"publish","type":"post","link":"https:\/\/ricardomoinhos.com\/pt\/c-side-to-al-table-data-migration\/","title":{"rendered":"C\/SIDE to AL Table Data Migration"},"content":{"rendered":"

In the last weeks I’ve read a few posts about C\/SIDE to AL Data Migration and as far as I understand people are struggling to have data migrated from C \/SIDE to AL tables.<\/p>\n

Data upgrade codeunits to the rescue. They exist in C\/AL and exists in AL as well so you should use and abuse them.<\/p>\n

If you ever made a data upgrade then you should be familiar with upgrade codeunits but if you don\u2019t, please feel free to ask me for help.<\/p>\n

Let’s take a look at the following scenario:<\/p>\n

I have two tables in C\/AL with dummy data and I want to convert them to extensions. I need to migrate the data from the C \/AL table to the new AL table.
\n* Table 50000 – Dummy Data To Migrate
\n* Table 50001 – Dummy Data To Migrate 2<\/p>\n

In table 50000 the field ids are the same. In table 50001 the ids don\u2019t match the final table ids but the fields name do so both scenarios are very similar. I\u2019ll show you how to handle it.<\/p>\n

Please consider the following steps:<\/p>\n

    \n
  1. Create two C\/AL tables and populate them with dummy data.<\/li>\n<\/ol>\n

    <\/p>\n

    <\/p>\n

    <\/p>\n

      \n
    1. The new AL tables will have the same table id and\/or the same name so we need to create new tables to temporarily hold the data and use data migration codeunits to migrate the data from the original to the upgrade (temp) tables.<\/li>\n<\/ol>\n

      <\/p>\n

      New 70000 and 70001 tables are copies of the original ones.<\/p>\n

        \n
      1. Create a new upgrade codeunit to move the data from the original tables to the upgrade (temp) tables:<\/li>\n<\/ol>\n

        <\/p>\n

        <\/p>\n

        [TableSyncSetup] GetTableSyncSetupW1(VAR TableSynchSetup : Record “Table Synch. Setup”)
        \n\/\/ The purpose of this method is to define how old and new tables will be available for dataupgrade<\/p>\n

        \/\/ The method is called at a point in time where schema changes have not yet been synchronized to
        \n\/\/ the database so tables except virtual tables cannot be accessed<\/p>\n

        \/\/ TableSynchSetup.”Table ID”:
        \n\/\/ Id of the table with schema changes (i.e the modified table).<\/p>\n

        \/\/ TableSynchSetup.”Upgrade Table ID”:
        \n\/\/ Id of table where old data will be available in case the selected TableSynchSetup.Mode option is one of Copy or Move , otherwise 0<\/p>\n

        \/\/ TableSynchSetup.Mode:
        \n\/\/ An option indicating how the data will be handled during synchronization
        \n\/\/ Check: Synchronize without saving data in the upgrade table, fails if there is data in the modified field\/table
        \n\/\/ Copy: Synchronize with saving data in the upgrade table, the modified table contains data in matching fields
        \n\/\/ Move: Synchronize with moving the data in the upgrade table,the changed table is empty; the upgrade logic is handled only by application code
        \n\/\/ Force: Synchronize without saving data in the upgrade table, disregard if there is data in the modified field\/table<\/p>\n

        DataUpgradeMgt.SetTableSyncSetup(DATABASE::”Dummy Data To Migrate”,DATABASE::”Temp Dummy Data To Migrate”,TableSynchSetup.Mode::Move);
        \nDataUpgradeMgt.SetTableSyncSetup(DATABASE::”Dummy Data To Migrate 2″,DATABASE::”Temp Dummy Data To Migrate 2″,TableSynchSetup.Mode::Move);<\/p><\/blockquote>\n

        <\/p>\n

        Codeunit subtype must be set to Upgrade.<\/p>\n

          \n
        1. At this moment, you will be able to delete the original tables without forcing it because a data upgrade codeunit has been created to handle and move the data.<\/p>\n<\/li>\n
        2. \n

          Delete tables 50000 and 50001 and choose “Now – with validation” option;<\/p>\n<\/li>\n<\/ol>\n

          <\/p>\n

            \n
          1. The tables are deleted without any issue;<\/li>\n
          2. Run the temporary tables and check that the data has been copied from the original to the temporary tables;<\/li>\n<\/ol>\n

            <\/p>\n

              \n
            1. Now create the AL extension with the two original tables. For the sake of simplicity I’ve created the following tables in AL:<\/li>\n<\/ol>\n

              <\/p>\n

              table 50100 “Dummy Data To Migrate”<\/p>\n

              {<\/p>\n

              Caption = ‘Dummy Data To Migrate’;<\/p>\n

              fields<\/p>\n

              {<\/p>\n

              field(1; “Dummy Field 1”; Code[10])<\/p>\n

              {<\/p>\n

              }<\/p>\n

              field(2; “Dummy Field 2”; Code[10])<\/p>\n

              {<\/p>\n

              }<\/p>\n

              field(3; “Dummy Field 3”; Code[10])<\/p>\n

              {<\/p>\n

              }<\/p>\n

              }<\/p>\n

              keys<\/p>\n

              {<\/p>\n

              key(Key1; “Dummy Field 1”)<\/p>\n

              {<\/p>\n

              }<\/p>\n

              }<\/p>\n

              }<\/p><\/blockquote>\n

              <\/p>\n

              table 50101 “Dummy Data To Migrate 2”<\/p>\n

              {<\/p>\n

              Caption = ‘Dummy Data To Migrate 2’;<\/p>\n

              fields<\/p>\n

              {<\/p>\n

              field(50000; “Dummy Field 3”; Code[10])<\/p>\n

              {<\/p>\n

              }<\/p>\n

              field(50001; “Dummy Field 2”; Code[10])<\/p>\n

              {<\/p>\n

              }<\/p>\n

              field(50002; “Dummy Field 1”; Code[10])<\/p>\n

              {<\/p>\n

              }<\/p>\n

              }<\/p>\n

              keys<\/p>\n

              {<\/p>\n

              key(Key1; “Dummy Field 1”)<\/p>\n

              {<\/p>\n

              }<\/p>\n

              }<\/p>\n

              }<\/p><\/blockquote>\n

              Please note that in “Dummy Data To Migrate 2” table the field ids are not equal and are sorted differently.<\/p>\n

                \n
              1. Publish the extension;<\/li>\n
              2. To migrate the data from the temporary tables to the extension tables, create a data upgrade codeunit in AL:<\/li>\n<\/ol>\n

                codeunit 50100 “Data Upgrade Codeunit”<\/p>\n

                {<\/p>\n

                Subtype = Upgrade;<\/p>\n

                trigger OnRun()<\/p>\n

                begin<\/p>\n

                end;<\/p>\n

                trigger OnUpgradePerCompany()<\/p>\n

                begin<\/p>\n

                DummyTable1_DataCopy;<\/p>\n

                DummyTable2_DataCopy;<\/p>\n

                end;<\/p>\n

                local procedure DummyTable1_DataCopy()<\/p>\n

                var<\/p>\n

                DestinyTable: Record “Dummy Data To Migrate”;<\/p>\n

                OriginTable: Record “Temp Dummy Data To Migrate”;<\/p>\n

                begin<\/p>\n

                With OriginTable do begin<\/p>\n

                if FindSet() then<\/p>\n

                repeat<\/p>\n

                DestinyTable.Init();<\/p>\n

                DestinyTable.Transferfields(originTable);<\/span><\/p>\n

                DestinyTable.Insert;<\/span><\/p>\n

                until next = 0;<\/p>\n

                \/\/DeleteAll();<\/p>\n

                end;<\/p>\n

                end;<\/p>\n

                local procedure DummyTable2_DataCopy()<\/p>\n

                var<\/p>\n

                DestinyTable: Record “Dummy Data To Migrate 2”;<\/p>\n

                OriginTable: Record “Temp Dummy Data To Migrate 2″;<\/p>\n

                begin<\/p>\n

                With OriginTable do begin<\/p>\n

                if FindSet() then<\/p>\n

                repeat<\/p>\n

                DestinyTable.Init();<\/p>\n

                DestinyTable.”Key Field 1″ := OriginTable.”Key Field 1″;\u00a0 \/\/ Add all the key fields.<\/p>\n

                DestinyTable.”Dummy Field 1″ := OriginTable.”Dummy Field 1″;<\/p>\n

                DestinyTable.”Dummy Field 2″ := OriginTable.”Dummy Field 2″;<\/p>\n

                DestinyTable.”Dummy Field 3″ := OriginTable.”Dummy Field 3”;<\/p>\n

                DestinyTable.Insert;<\/p>\n

                until next = 0;<\/p>\n

                \/\/DeleteAll();<\/p>\n

                end;<\/p>\n

                end;<\/p>\n

                }<\/p><\/blockquote>\n

                i. Two issues should arise:<\/p>\n

                <\/p>\n

                1) VSCode cannot find \u201cDummy Data To Migrate” nor “Dummy Data To Migrate 2” tables.
                \nTo fix this, you must set dependencies with the extension created earlier.
                \nIn the app.json, setup the dependencies:<\/span><\/p>\n

                \n

                “dependencies”: [<\/span><\/p>\n

                {<\/p>\n

                “appId”: “6fbcc681-a68a-46bc-ab7c-87c7434fdd06”,<\/p>\n

                “name”: “DataMigrationArticle”,<\/p>\n

                “publisher”: “Default publisher”,<\/p>\n

                “version”: “1.0.0.0”<\/p>\n

                }<\/p>\n

                ],<\/p>\n<\/blockquote>\n

                2) VSCode cannot find “Temp Dummy Data To Migrate”.<\/p>\n

                This is related with the symbols generation because this table was created in C\/AL and must be accessed in AL. Please refer to the following website:<\/p>\n

                https:\/\/docs.microsoft.com\/en-us\/dynamics365\/business-central\/dev-itpro\/developer\/devenv-running-cside-and-al-side-by-side<\/a><\/p>\n

                You need to run the Microsoft Dynamics NAV Development Environment with the generatesymbolreference<\/em> flag set as true and compile both 70000 and 70001 tables.<\/p>\n

                \n

                finsql.exe generatesymbolreference=yes<\/p>\n<\/blockquote>\n

                Please let me know if you have any doubts.<\/p>\n

                3) Download the symbols again in VS Code after following the previous steps and you should have no errors in the project.<\/p>\n

                  \n
                1. Publish the upgrade extension and install it.<\/li>\n<\/ol>\n

                  I’ve packaged the extension in VSCode and used Powershell to publish and install it but you can do it directly from VSCode if you want it.<\/p>\n

                  To do it in Powershell run the commands below.
                  \nDon’t forget to update the path, server instance and file names to match yours.<\/p>\n

                  \u25a1 Import-Module “C:\\Program Files\\Microsoft Dynamics 365 Business Central\\130\\Service\\NavAdminTool.ps1” \u2013force<\/p>\n

                  \u25a1 Publish-NAVApp -ServerInstance W1_NAVBC_CU5 -Path “C:\\…\\AL\\DataMigrationArticleUpgradeCodeunit\\Default publisher_DataMigrationArticleUpgradeCodeunit_1.0.0.0.app” -SkipVerification<\/p>\n

                  \u25a1 Sync-NAVApp -ServerInstance W1_NAVBC_CU5 -Name DataMigrationArticleUpgradeCodeunit<\/p>\n

                  \u25a1 Install-NAVApp -ServerInstance W1_NAVBC_CU5 -Name DataMigrationArticleUpgradeCodeunit<\/p><\/blockquote>\n

                    \n
                  1. Next, uninstall the extension and publish it a higher version extension;<\/li>\n<\/ol>\n
                      \n
                    • NOTE: This step is very important<\/strong>. BC will only do the data upgrade when you install a higher version of the upgrade extension. So at this moment update the extension version to a higher version, create a new package and publish the new version.*<\/li>\n<\/ul>\n

                      \u25a1 Uninstall-NAVApp -ServerInstance W1_NAVBC_CU5 -Name DataMigrationArticleUpgradeCodeunit<\/p>\n

                      \u25a1 Publish-NAVApp -ServerInstance W1_NAVBC_CU5 -Path “C:\\…\\AL\\DataMigrationArticleUpgradeCodeunit\\Default publisher_DataMigrationArticleUpgradeCodeunit_2.0.0.0.app” -SkipVerification<\/p><\/blockquote>\n

                      NOTE<\/strong>: Please note that I\u2019ve just published the new extension version using PowershelI, i didn\u2019t install it. I wasn’t able to do the data upgrade using Powershell so please do the following: after publishing the new extension version, open Extensions Management<\/strong> menu in RTC and install the new extension version there.<\/p>\n

                      <\/p>\n

                      At this moment the upgrade codeunit is executed and data is migrated;<\/p>\n

                        \n
                      1. To check if data was migrated you can use a SQL query:<\/li>\n<\/ol>\n

                        <\/p>\n

                        Et voil\u00e1, the data is migrated \ud83d\ude09<\/p>\n

                          \n
                        1. You can now uninstall and unpublish the data upgrade extension and delete tables 70000 and 70001 in C\/SIDE.<\/li>\n<\/ol>\n

                          Feel free to leave your comments or ask me questions.<\/p>\n","protected":false},"excerpt":{"rendered":"

                          In the last weeks I’ve read a few posts about C\/SIDE to AL Data Migration and as far as I understand people are struggling to have data migrated from C \/SIDE to AL tables. Data upgrade codeunits to the rescue. They exist in C\/AL and exists in AL as well so you should use and […]<\/p>\n","protected":false},"author":1,"featured_media":138,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[4],"tags":[58,59,6],"class_list":{"0":"post-723","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","6":"hentry","7":"category-dynamics365bc","8":"tag-al","9":"tag-businesscentral","10":"tag-dynamicsnav-2","12":"post-with-thumbnail","13":"post-with-thumbnail-icon"},"yoast_head":"\nC\/SIDE to AL Table Data Migration - Ricardo Paiva Moinhos<\/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:\/\/ricardomoinhos.com\/c-side-to-al-table-data-migration\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\/SIDE to AL Table Data Migration - Ricardo Paiva Moinhos\" \/>\n<meta property=\"og:description\" content=\"In the last weeks I’ve read a few posts about C\/SIDE to AL Data Migration and as far as I understand people are struggling to have data migrated from C \/SIDE to AL tables. Data upgrade codeunits to the rescue. They exist in C\/AL and exists in AL as well so you should use and […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ricardomoinhos.com\/c-side-to-al-table-data-migration\/\" \/>\n<meta property=\"og:site_name\" content=\"Ricardo Paiva Moinhos\" \/>\n<meta property=\"article:published_time\" content=\"2019-06-21T21:13:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-09-29T09:01:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ricardomoinhos.com\/wp-content\/uploads\/2014\/06\/PT_c_Dyn-NAV-2013.png\" \/>\n\t<meta property=\"og:image:width\" content=\"375\" \/>\n\t<meta property=\"og:image:height\" content=\"375\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Ricardo Paiva Moinhos\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ricardo Paiva Moinhos\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/ricardomoinhos.com\\\/c-side-to-al-table-data-migration\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ricardomoinhos.com\\\/c-side-to-al-table-data-migration\\\/\"},\"author\":{\"name\":\"Ricardo Paiva Moinhos\",\"@id\":\"https:\\\/\\\/ricardomoinhos.com\\\/#\\\/schema\\\/person\\\/16dcfdd54ec1c46bd1941659739de4cc\"},\"headline\":\"C\\\/SIDE to AL Table Data Migration\",\"datePublished\":\"2019-06-21T21:13:10+00:00\",\"dateModified\":\"2021-09-29T09:01:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/ricardomoinhos.com\\\/c-side-to-al-table-data-migration\\\/\"},\"wordCount\":1242,\"commentCount\":23,\"image\":{\"@id\":\"https:\\\/\\\/ricardomoinhos.com\\\/c-side-to-al-table-data-migration\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ricardomoinhos.com\\\/wp-content\\\/uploads\\\/2014\\\/06\\\/PT_c_Dyn-NAV-2013.png\",\"keywords\":[\"\",\"\",\"dynamicsnav\"],\"articleSection\":[\"Dynamics NAV\\\/365 BC\"],\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/ricardomoinhos.com\\\/c-side-to-al-table-data-migration\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ricardomoinhos.com\\\/c-side-to-al-table-data-migration\\\/\",\"url\":\"https:\\\/\\\/ricardomoinhos.com\\\/c-side-to-al-table-data-migration\\\/\",\"name\":\"C\\\/SIDE to AL Table Data Migration - Ricardo Paiva Moinhos\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ricardomoinhos.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/ricardomoinhos.com\\\/c-side-to-al-table-data-migration\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/ricardomoinhos.com\\\/c-side-to-al-table-data-migration\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ricardomoinhos.com\\\/wp-content\\\/uploads\\\/2014\\\/06\\\/PT_c_Dyn-NAV-2013.png\",\"datePublished\":\"2019-06-21T21:13:10+00:00\",\"dateModified\":\"2021-09-29T09:01:04+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/ricardomoinhos.com\\\/#\\\/schema\\\/person\\\/16dcfdd54ec1c46bd1941659739de4cc\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ricardomoinhos.com\\\/c-side-to-al-table-data-migration\\\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ricardomoinhos.com\\\/c-side-to-al-table-data-migration\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\\\/\\\/ricardomoinhos.com\\\/c-side-to-al-table-data-migration\\\/#primaryimage\",\"url\":\"https:\\\/\\\/ricardomoinhos.com\\\/wp-content\\\/uploads\\\/2014\\\/06\\\/PT_c_Dyn-NAV-2013.png\",\"contentUrl\":\"https:\\\/\\\/ricardomoinhos.com\\\/wp-content\\\/uploads\\\/2014\\\/06\\\/PT_c_Dyn-NAV-2013.png\",\"width\":375,\"height\":375},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ricardomoinhos.com\\\/c-side-to-al-table-data-migration\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/ricardomoinhos.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\\\/SIDE to AL Table Data Migration\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ricardomoinhos.com\\\/#website\",\"url\":\"https:\\\/\\\/ricardomoinhos.com\\\/\",\"name\":\"Ricardo Paiva Moinhos\",\"description\":\"Welcome\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/ricardomoinhos.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/ricardomoinhos.com\\\/#\\\/schema\\\/person\\\/16dcfdd54ec1c46bd1941659739de4cc\",\"name\":\"Ricardo Paiva Moinhos\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/248366f4e615e182964f85f799c6e33cbd541a6f4ca7ee948fc16d1c14030c76?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/248366f4e615e182964f85f799c6e33cbd541a6f4ca7ee948fc16d1c14030c76?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/248366f4e615e182964f85f799c6e33cbd541a6f4ca7ee948fc16d1c14030c76?s=96&d=mm&r=g\",\"caption\":\"Ricardo Paiva Moinhos\"},\"url\":\"https:\\\/\\\/ricardomoinhos.com\\\/pt\\\/author\\\/ricardopaiva\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"C\/SIDE to AL Table Data Migration - Ricardo Paiva Moinhos","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:\/\/ricardomoinhos.com\/c-side-to-al-table-data-migration\/","og_locale":"pt_PT","og_type":"article","og_title":"C\/SIDE to AL Table Data Migration - Ricardo Paiva Moinhos","og_description":"In the last weeks I’ve read a few posts about C\/SIDE to AL Data Migration and as far as I understand people are struggling to have data migrated from C \/SIDE to AL tables. Data upgrade codeunits to the rescue. They exist in C\/AL and exists in AL as well so you should use and […]","og_url":"https:\/\/ricardomoinhos.com\/c-side-to-al-table-data-migration\/","og_site_name":"Ricardo Paiva Moinhos","article_published_time":"2019-06-21T21:13:10+00:00","article_modified_time":"2021-09-29T09:01:04+00:00","og_image":[{"width":375,"height":375,"url":"https:\/\/ricardomoinhos.com\/wp-content\/uploads\/2014\/06\/PT_c_Dyn-NAV-2013.png","type":"image\/png"}],"author":"Ricardo Paiva Moinhos","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Ricardo Paiva Moinhos","Tempo estimado de leitura":"9 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ricardomoinhos.com\/c-side-to-al-table-data-migration\/#article","isPartOf":{"@id":"https:\/\/ricardomoinhos.com\/c-side-to-al-table-data-migration\/"},"author":{"name":"Ricardo Paiva Moinhos","@id":"https:\/\/ricardomoinhos.com\/#\/schema\/person\/16dcfdd54ec1c46bd1941659739de4cc"},"headline":"C\/SIDE to AL Table Data Migration","datePublished":"2019-06-21T21:13:10+00:00","dateModified":"2021-09-29T09:01:04+00:00","mainEntityOfPage":{"@id":"https:\/\/ricardomoinhos.com\/c-side-to-al-table-data-migration\/"},"wordCount":1242,"commentCount":23,"image":{"@id":"https:\/\/ricardomoinhos.com\/c-side-to-al-table-data-migration\/#primaryimage"},"thumbnailUrl":"https:\/\/ricardomoinhos.com\/wp-content\/uploads\/2014\/06\/PT_c_Dyn-NAV-2013.png","keywords":["","","dynamicsnav"],"articleSection":["Dynamics NAV\/365 BC"],"inLanguage":"pt-PT","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/ricardomoinhos.com\/c-side-to-al-table-data-migration\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/ricardomoinhos.com\/c-side-to-al-table-data-migration\/","url":"https:\/\/ricardomoinhos.com\/c-side-to-al-table-data-migration\/","name":"C\/SIDE to AL Table Data Migration - Ricardo Paiva Moinhos","isPartOf":{"@id":"https:\/\/ricardomoinhos.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ricardomoinhos.com\/c-side-to-al-table-data-migration\/#primaryimage"},"image":{"@id":"https:\/\/ricardomoinhos.com\/c-side-to-al-table-data-migration\/#primaryimage"},"thumbnailUrl":"https:\/\/ricardomoinhos.com\/wp-content\/uploads\/2014\/06\/PT_c_Dyn-NAV-2013.png","datePublished":"2019-06-21T21:13:10+00:00","dateModified":"2021-09-29T09:01:04+00:00","author":{"@id":"https:\/\/ricardomoinhos.com\/#\/schema\/person\/16dcfdd54ec1c46bd1941659739de4cc"},"breadcrumb":{"@id":"https:\/\/ricardomoinhos.com\/c-side-to-al-table-data-migration\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ricardomoinhos.com\/c-side-to-al-table-data-migration\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/ricardomoinhos.com\/c-side-to-al-table-data-migration\/#primaryimage","url":"https:\/\/ricardomoinhos.com\/wp-content\/uploads\/2014\/06\/PT_c_Dyn-NAV-2013.png","contentUrl":"https:\/\/ricardomoinhos.com\/wp-content\/uploads\/2014\/06\/PT_c_Dyn-NAV-2013.png","width":375,"height":375},{"@type":"BreadcrumbList","@id":"https:\/\/ricardomoinhos.com\/c-side-to-al-table-data-migration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ricardomoinhos.com\/"},{"@type":"ListItem","position":2,"name":"C\/SIDE to AL Table Data Migration"}]},{"@type":"WebSite","@id":"https:\/\/ricardomoinhos.com\/#website","url":"https:\/\/ricardomoinhos.com\/","name":"Ricardo Paiva Moinhos","description":"Welcome","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ricardomoinhos.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Person","@id":"https:\/\/ricardomoinhos.com\/#\/schema\/person\/16dcfdd54ec1c46bd1941659739de4cc","name":"Ricardo Paiva Moinhos","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/secure.gravatar.com\/avatar\/248366f4e615e182964f85f799c6e33cbd541a6f4ca7ee948fc16d1c14030c76?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/248366f4e615e182964f85f799c6e33cbd541a6f4ca7ee948fc16d1c14030c76?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/248366f4e615e182964f85f799c6e33cbd541a6f4ca7ee948fc16d1c14030c76?s=96&d=mm&r=g","caption":"Ricardo Paiva Moinhos"},"url":"https:\/\/ricardomoinhos.com\/pt\/author\/ricardopaiva\/"}]}},"jetpack_featured_media_url":"https:\/\/ricardomoinhos.com\/wp-content\/uploads\/2014\/06\/PT_c_Dyn-NAV-2013.png","jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/ricardomoinhos.com\/pt\/wp-json\/wp\/v2\/posts\/723","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ricardomoinhos.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ricardomoinhos.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ricardomoinhos.com\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ricardomoinhos.com\/pt\/wp-json\/wp\/v2\/comments?post=723"}],"version-history":[{"count":12,"href":"https:\/\/ricardomoinhos.com\/pt\/wp-json\/wp\/v2\/posts\/723\/revisions"}],"predecessor-version":[{"id":3837,"href":"https:\/\/ricardomoinhos.com\/pt\/wp-json\/wp\/v2\/posts\/723\/revisions\/3837"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ricardomoinhos.com\/pt\/wp-json\/wp\/v2\/media\/138"}],"wp:attachment":[{"href":"https:\/\/ricardomoinhos.com\/pt\/wp-json\/wp\/v2\/media?parent=723"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ricardomoinhos.com\/pt\/wp-json\/wp\/v2\/categories?post=723"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ricardomoinhos.com\/pt\/wp-json\/wp\/v2\/tags?post=723"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}