Book Image

Administrating Microsoft Dynamics 365 Business Central Online

By : Andrey Baludin
Book Image

Administrating Microsoft Dynamics 365 Business Central Online

By: Andrey Baludin

Overview of this book

This book features all the information you need to get started with administrating Microsoft Dynamics 365 Business Central Online. It contains detailed information about the admin portal and cloud migration process, all based on real usage experience. The book starts by covering the data migration process for developers, which will show you how to organize the data without code. You’ll also learn how the admin portal can be useful if you want to export a database copy, restore a backup, and set up telemetry to get detailed information about the call stack and operation statuses. As you progress, you’ll learn how to check your Business Central SaaS environment details, create new and different types of environments, and notifications, and keep your cloud data within limits. Later, you’ll explore how to set up cloud migration from an on-premise environment to SaaS, run the migration, upgrade data, and fix problems if something goes wrong. By the end of this book, you’ll be able to create new production and sandbox environments, restore them from backups, analyze environment telemetry, and confidently migrate your data to the cloud.
Table of Contents (15 chapters)
1
Part 1: Dynamics 365 Business Central Admin Center
9
Part 2: Dynamics 365 Business Central Cloud Migration Tool

Prerequisite 1 – SQL Server setup

Before a cloud migration setup can run, we must check our on-premise SQL Server settings. If you use Azure SQL Server, then skip this section.

Our check includes three points, as outlined here:

  1. SQL Server version

You must check that you have SQL Server 2016 or higher since older versions are not supported. You can upgrade your SQL Server version if needed.

To check your SQL Server version, use Command Prompt, as follows:

  • Type SQLCMD -S servername\instancename
  • Type select @@version
  • Type go

The process is illustrated in the following screenshot:

Figure 9.1 – SQL Server version check

  1. Database compatibility level

Run SQL Server Management Studio (SSMS), click on your database, and choose Properties. Then, choose Options and check the Compatibility level value. This must be SQL Server 2016 (130) or higher. Change it if needed and apply the changes.

The process...