Загрузка...

Create MI link from Azure SQL Managed Instance to SQL Server 2022 to replicate a database

In this demo you will see how can you use SSMS to create MI link from Azure SQL Managed Instance to SQL Server 2022. This can be used to replicate data from SQL MI to SQL Server for any purposes, including database migration from Azure to on-premises, for example. This can be highly effective in meeting cloud exit requirements while minimizing latency and downtime.
Note: To be able to create MI link to SQL Server 2022, Update Policy of your Azure SQL Managed Instance needs to be set to "SQL Server 2022".

Learn more at: https://aka.ms/sqlmi-link

Video by Djordje Jeremic.

📩 SQL MI Newsletter | https://aka.ms/sqlmi-letter
🍿 Watch next | Planned failover (DR drill) between SQL Server 2022 and SQL MI https://www.youtube.com/watch?v=Ql1Evh6VVIM
📚 Read next | Free offer for Azure SQL Managed Instance: https://aka.ms/sqlmi-free

Chapters:
00:08 Introduction
00:24 Use SSMS to create MI link from SQL MI to SQL Server 2022
02:22 MI link successfully created
03:09 Verifying newly created database in SQL Server 2022

Recommended content:
Link feature for SQL MI documentation: https://aka.ms/mi-link
Test network connectivity for MI link: https://aka.ms/sqlmi-link-tnc
Prepare your environment for a link: https://learn.microsoft.com/azure/azure-sql/managed-instance/managed-instance-link-preparation
Transparent data encryption for SQL Managed Instance: https://learn.microsoft.com/azure/azure-sql/database/transparent-data-encryption-tde-overview
What's new in SQL MI: https://aka.ms/sqlmi-new

Видео Create MI link from Azure SQL Managed Instance to SQL Server 2022 to replicate a database канала Azure SQL
Страницу в закладки Мои закладки
Все заметки Новая заметка Страницу в заметки

На информационно-развлекательном портале SALDA.WS применяются cookie-файлы. Нажимая кнопку Принять, вы подтверждаете свое согласие на их использование.

Об использовании CookiesПринять