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

Pubblicato il: 30 ottobre 2024
sul canale di: Microsoft SQL
1,433
18

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    • Planned failover (DR drill) between SQL Se...  
📚 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/azu...
Transparent data encryption for SQL Managed Instance: https://learn.microsoft.com/azure/azu...
What's new in SQL MI: https://aka.ms/sqlmi-new


In questa pagina del sito puoi guardare il video online Create MI link from Azure SQL Managed Instance to SQL Server 2022 to replicate a database della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Microsoft SQL 30 ottobre 2024, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 1,433 volte e gli è piaciuto 18 spettatori. Buona visione!