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)
Part 1: Dynamics 365 Business Central Admin Center
Part 2: Dynamics 365 Business Central Cloud Migration Tool

Prerequisite 2 – Connection string construction

You will need a connection string when you run a cloud migration setup, so, we need to prepare this beforehand.

A connection string consists of four parameters, as outlined here:

  • Server name
  • Database name
  • Username
  • User password

The full view looks like this:

server={Server name\Instance name};Initial Catalog ={Database name};user id ={User name};password ={User password};

As an example, I have SQL Server CloudMigration with a BCDEMO instance. My Business Central database is named Demo Database BC (18-0). To migrate this database, I created an Integration user with the password integration123. Using these parameters, my connection string will look like this:

server=CloudMigration\BCDEMO;Initial Catalog ="Demo Database BC (18-0)";user id =integration;password =integration123;

If I have my database in Azure SQL, the connection string might look like this: