Introduction
Understanding the options and methods for migrating on-premises SQL databases to Azure are critical to ensure a successful migration. As part of the planning, it is important to follow the necessary steps that you, as a database administrator, must follow carefully. Selecting the proper compatibility level, understanding Azure preview features, and describing the available migration methods are crucial to ensure the success of your migration.
This module will also provide concrete information on the various options when you are performing a migration.
Learning objectives
At the end of this module, you will be able to:
- Understand how compatibility level affects query optimizer behaviors.
- Understand how Azure preview feature process works.
- Describe the various options when you are performing a migration.