web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :

Upgrading D365 Business Central On-premise to D365 Business Central Online.

CDsilva Profile Picture CDsilva 4,188

Introduction:

Hi Buddies!  Hope you are well ?

My last blog was on Can we upgrade NAV to Business Central Online directly? If you haven’t seen it yet, please click here

This article covers the steps of how to upgrade from D365 Business Central On-premise to D365 Business Central Online.

Upgrade from NAV to Business Central online process consists of three parts:

  • Upgrade from Dynamics NAV to Business Central using the tools described in Upgrading to Business Central on-premises.
  • Convert non-standard functionality and customizations to apps and per-tenant extensions. For more information, see Deploying a Tenant Customization.
  •  Connect to the intelligent cloud, and then switch to use the Business Central online tenant going forward.

Pre-requisites:

  • D365 Business Central On-premise
  • D365 Business Central Online tenant.

Steps:

Deploying a Tenant Customization  (Deploy extensions)

D365 Business Central Online requires all customisation to be created as extensions. Once we compile our extension package .app file is created. The .app file consist of all the customization that needs to be deployed to our customer’s tenant.

We can deploy the .app file using the Upload extension feature in Extension Management page on the customer’s tenant.

Steps for deploying your .app file

  1. Log into your customer’s Dynamics 365 Business Central tenant.
  2. Open the Extension Management page.
  3. Choose the Upload Extension action.
  4. Select the browse button to select the .app file to upload. Browse to and select the extension’s .app file.
  5. Select if you want to deploy for the current version (most common) or next version. Select the language for the deployment.
  6. Choose the Deploy button.
  7. The extension will be deployed in the background.
  8. To check the status of the deployment, choose Deployment Status and then view the status of the extension deployment. Select the row to see additional details.
  9. In the deployment status details there is a Refresh button in the actions you must press to retrieve the most recent status and details.
  10. When the extension has been successfully deployed, choose the Refresh button to see the new extension in the list of installed extensions.

Connect to intelligence cloud

D365 BC products and versions are supported for this connection?

  1. Business Central on-premises (current version + the two previous major versions)
  2. This means that if the current version is version 16, then you can connect to the intelligent cloud if you are on version 16, 15, or 14.
  3. If you are currently on a version of Dynamics NAV, you must upgrade to Business Central on-premises, and then switch to Business Central online.

Cloud Migration Tool

Customers running their workloads on-premises can migrate to Business Central online by running the cloud migration tool.

Working of  Cloud migration tool 

Cloud migration tool is an assisted setup wizard on the Business Central Online.

  • Any existing data in your Business Central tenant will be overwritten with data from your on-premises solution
  • All users that do not have SUPER permissions will be automatically reassigned to the intelligent cloud user group.
  • If your data source is Business Central on-premises, several stored procedures will be added to the SQL Server instance that you define. These stored procedures are required to migrate data from your SQL Server database to the Azure SQL server associated with your Business Central tenant.
  • In the current version of Business Central, the migration tool has been optimized to migrate databases up to 30 GB. 
  • Configuring the cloud environment will have no impact on any users or data in your on-premises solution
  • We can also schedule the migration daily, weekly or off-peak business hours.
  • For more information read https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/migration-tool

Cloud Migration Management

The Cloud Migration Management page provides information about your data migration runs as well as the ability to manage your migration services.

Data migration:

  1. Data migration is the process of securely migrating data from your on-premises SQL Server instance to your Business Central online tenant.
  2. The process uses the Azure Data Factory (ADF) to migrate the data between databases directly, meaning it does not look at any permissions within the applications you are transferring data between, only SQL permissions.
  3. In order for the data migration to take place, you must successfully complete the Cloud Migration Setup assisted setup wizard in your Business Central online tenant.
  4. Once the wizard is complete and data migration is activated, an initial data migration will happen at the scheduled time.
  5. Data is migrated between the two systems on a per-table basis, and success and failures are tracked for each table. If a table fails to migrate, the error will be captured, and the migration moves on to the next table until completed.
  6. Tables will fail to migrate if they cannot be found, or if the schema does not match between the cloud and the on-premises tables.
  7. The initial data migration time can vary depending factors such as the amount of data to migrate, your SQL Server configuration, and your connection speeds.

Steps:

  1. Open D365 BC Online sandbox, type Assisted setup on the search bar

2. Click on SetupCloud Migration

3. Accept the terms and condition

4. Select the Product

5. Enter SQL Database Connection/Azure Connection

Server=tcp:{ServerName},1433;Initial Catalog={DatabaseName};Persist Security Info=False; User ID={UserName};Password={Password};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=True;Connection Timeout=30;

6. Run the Self Hosted Integration

Copy and save the Authentication Key.

Click on Next to download and install Self Hosted Integration Run-time

7. Install Microsoft Integration Runtime setup

8. Copy and Paste the Authentication key and click on Register.

9. Replicate Companies from Business Central on Premises: Select the company and click on Next.

10. Select the schedule to migrate data: Daily, Weekly

11. Setup is complete.

11. Type in Intelligent Cloud Management and click on Run Replication now

12. All data from Business Central On-premise is migrated to Business Central Online.

Thanks for Reading!


This was originally posted here.

Comments

*This post is locked for comments