Lesson Learned #2 Linked Server from SQL 2008 R2 to Azure SQL Managed Instance

You should know by now that the SQL 2008 and 2008 R2 is at end of support on 2019-07-09 and mainstream support also ended a long time ago https://www.microsoft.com/en-us/sql-server/sql-server-2008 https://support.microsoft.com/en-us/lifecycle/search?alpha=SQL%202008 The best path to do this migration would be to use DMA (Data Migration Assistant) and DMS (Azure Database Migration Service), however in some scenario […]