Modifier

Partager via

Move Dynamics GP database to Azure Data Lake

  • Article

You can create a copy of the Dynamics GP database in Azure Data Lake so that you have it for future reference after the migration to Business Central online. To take advantage of this functionality, there are some pieces that must be set up before the migration process. A customer isn't required to copy their database to Azure Data Lake. But there are several benefits to being able to do so, including having access to the historical data that isn't migrated by the migration tool. For an introduction to Azure Data Lake, see azure.microsoft.com.

To create an Azure Data Lake storage account, you sign in to your Azure subscription (or sign up for an Azure subscription). Once signed into the Azure portal, you can create a storage account. Under the Access Keys section of the information about your storage account in the Azure portal, you can see the keys that you must provide in the cloud migration management in Business Central. For more information about Azure Data Lake and setting up a storage account, see Azure documentation.

Prerequisites

You have an Azure Data Lake Gen2 storage account with access to the storage account name and storage account key.

Move to Azure Data Lake

  1. Sign in to your Business Central online tenant.

  2. In the upper-right corner, select the Shows the search magnifyting glass icon icon, enter Cloud Migration Management, and then choose the related link to open the Cloud Migration Management page.

  3. In the action bar along the top, select ... (Show the rest) > Actions > Azure Data Lake.

    The Azure Data Lake Migration Setup guide takes you through the steps to connect your on-premises Dynamics GP database and your storage in Azure Data Lake.

  4. When the setup completes, you can monitor the progress of moving your data from on-premises to Azure Data Lake in the Cloud Migration Management page in Business Central.

If you go back to the Azure portal, you can see the data that was moved from your Dynamics GP database to Azure Data Lake. Under the containers section of the Data Lake storage, a new gp-database folder contains the company/system databases, and subfolders contain the series folder and data files.

The database folder in Azure Data Lake is always set to gp-database. If you want to rename it, you can do so after the migration completes. The same applies to the various subfolders. The folders created follow the standard naming convention of the series folders in Dynamics GP. Another folder, 3rd Party, is created, and any files that haven't been mapped to a folder reside in this folder. You can modify the content in the folders after the migration completes.

If an Azure Data Lake migration has already run in the Business Central company, and you launch a second run, the migration tool checks to see if a gp-database folder exists. If you still want to run the migration again, you must delete the gp-database folder and its contents before you can run the wizard again.

At the end of the migration, you have a complete copy of your Dynamics GP database in the cloud with all the advantages of having access to historical data without having to maintain a server on-premises.

Next steps

See also

Dynamics GP migration to Business Central online: End-to-end overview
FAQ about migrating to Business Central online from on-premises solutions