Back to Browse

Demo of a database migration from SQL Server to SQL MI with Azure SQL Managed Instance link feature

1.6K views
Oct 24, 2024
3:08

In this video we will demo how you can use MI link via SSMS to migrate a database from SQL Server to Azure SQL Managed Instance. For database replication and migration purposes, SQL MI link feature can be used with SQL Server 2016, 2019 and 2022, and Update policy on Azure SQL Managed Instance can be both "Always up to date" or "SQL Server 2022". To migrate a database, create MI link from SQL Server to Azure SQL Managed Instance and wait for data to be replicated. Once that is done, perform MI link failover and drop the MI link. After this, you will have read-write database in Azure SQL Managed Instance. Learn more at: https://aka.ms/mi-link Video by Djordje Jeremic. Chapters: 00:08 Introduction 00:39 How to use SSMS to migrate a database 02:15 Migration successfully completed 03:32 Additional verification of migration and MI link drop operation 📩 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 | SQL Managed Instance link https://aka.ms/sqlmi-link Recommended content: Configure SQL MI link with SSMS: https://learn.microsoft.com/azure/azure-sql/managed-instance/managed-instance-link-configure-how-to-ssms?view=azuresql Configure SQL MI link with scripts: https://learn.microsoft.com/azure/azure-sql/managed-instance/managed-instance-link-configure-how-to-scripts?view=azuresql&tabs=sql-server SQL MI Update Policy: https://aka.ms/sqlmi-up SQL MI free offer: https://learn.microsoft.com/azure/azure-sql/managed-instance/free-offer?view=azuresql What's new in SQL MI: https://learn.microsoft.com/azure/azure-sql/managed-instance/doc-changes-updates-release-notes-whats-new?view=azuresql What is Azure SQL Managed Instance: https://learn.microsoft.com/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview?view=azuresql

Download

1 formats

Video Formats

360pmp44.8 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.

Demo of a database migration from SQL Server to SQL MI with Azure SQL Managed Instance link feature | NatokHD