Power Community

Power Community

Changes to the GP Migration Tool starting with version 19.5

With version 19.5, we have made changes to how the GP migration tool will run.  This change will allow you to move data from GP to BC staging tables in one step (Run Migration Now), then migrate data from the BC staging tables, to the BC tables needed to go live. (Run Data Upgrade Now) Doing this in 2 steps will allow you to manage the migration in a more structured manner.   Let me walk through how these new steps will work:

Step One – Assisted Setup:

You will complete the Assisted Setup as you always have. As always, you can review the company Setup Status under the Companies list. Once you see the Setup Status change to ‘Completed’, you can proceed.

For more detailed steps on this part, see this blog: Starting the Migration process from GP to Business Central – Dynamics 365 Business Central Community

Step Two – Run Migration Now:

From the Cloud Migration Management page, select Run Migration Now:

You will stay on this page through this step.  As the process runs, you will notice the Status change which will start with ‘In Progress’

The next status you may see would be ‘Data Repair Pending’:

This will happen for all migrations but if you do not refresh this page, you may not see this status update at all (and that’s OK).  When you see ‘Data Repair Pending’, the tool is moving data from the GP Dynamics staging tables in SQL, to the BC GP Staging tables in Saas. 

If you would like a full listing of these staging tables, search on Config Package, then search for ‘GP’ and you will see all tables that are brought over in this stage starting with table 4015.

At this point, please be patient, the tool is working.  When the data has been completely moved to the BC staging tables, you will see a status of ‘Upgrade Pending’:


This will indicate Step Two is complete, and the data is ready to be moved into the permanent BC tables needed to operate.  This is where Step Three comes into play. 

Step Three – Run Data Upgrade Now:

From the Cloud Migration Management page, select Run Data Upgrade Now:

You are probably wondering, ‘what am I trying to upgrade’?  I asked that very same question!

The tool is moving the staged GP data into the permanent Business Central tables.  This wording could be changing down the road, but for now, let’s just know it’s the third step. 

This is where you can monitor the progress on the Data Migration Overview page just as you always have. Just be sure you are logged into the company being migrated to see the proper Overview.  When all data has been moved successfully, the Overview will look like this:

At this point, remember to be patient as Business Central is now posting transactions. This can take some time, and there is no visual indicator to show you the process has finished.

Important Notes:

If you do not see data populated on the Data Migration Overview page, check your Status on the Cloud Migration Management page as you could have a data issue:

When you see the status of Upgrade Failed on this step, you likely have data issues that need to be addressed in GP.  Review my blog for GP data clean up that can be found here:  Dynamics GP to Dynamics Business Central migration tips – Dynamics 365 Business Central Community

If data cleanup is needed in GP, I highly recommend deleting the company in BC and running through the Assisted Setup again, to get fresh data from GP once it has been fixed.  If this is needed, you may get this message when attempting to run the migration again:

This means a reset to the Cloud is needed and can be done under Actions >> Reset Cloud Data on the Cloud Migration Management page before you start a new migration:

Once this has been done, proceed with Step Two – Run Migration Now.

I hope this information is helpful and if you have any questions, please let us know.

Warm Regards,

Deseree Krumm

Support Escalation Engineer-Business Central

This post was originally published on this site

- Advertisement -spot_img


Please enter your comment!
Please enter your name here

- Advertisement - Advertisement

Latest News

Enable Early Access Wave 1 2023 | Power Platform

Like every 6 months, enabling Early Access is one of the best things to look forward to as Microsoft...

More Articles Like This

- Advertisement -spot_img