Azure SQL Managed Instance / Migration / Data Migration Assistant (DMA) / Assess on-premises SQL Server instance
Posted by Barac in Azure, SQL Server on Oct 30th, 2019 | 0 comments
Before we migrate our database to the cloud we need to assess our on-premises SQL Server instance and Data Migration Assistant (DMA) tool can help us with that. Using Data Migration Assistant (DMA) tool we can detect potential compatibility issues which may impact our database functionality after migration to Azure SQL managed Instance. DMA main functionalities: Discover issues that can affect an upgrade to an on-premises SQL Server Discover new features in the target SQL Server platform Migrate an on-premises SQL Server instance to a modern...
Azure SQL Managed Instance / Migration from on-premises SQL Server instance to Azure SQL Managed Instance
Posted by Barac in Azure, SQL Server on Oct 9th, 2019 | 0 comments
Database migration from on premises SQL Server instance (SQL Server 2017) to Azure SQL Managed Instance. With series of posts I will try to describe whole database migration process from on premise SQL Server to the cloud. First step will be to determine whether Azure SQL Managed Instance is compatible with the database requirements of business application. Step 1. Assess managed instance compatibility I used Data Migration Assistant (DMA) to detect potential compatibility issues impacting database functionality on Azure SQL managed Instance....
About Me
My name is Zoran, currently living in Auckland, New Zealand. I am a data specialist with more than 15 years of hands-on experience in database administration and optimisation. I am also, Certified Microsoft Trainer (MCT) and Microsoft Certified Solutions Expert (MCSE) with a Master‘s degree in Information Technology. Sharing knowledge and contributing to the SQL Server community is my passion. I am also an organiser of the Auckland SQL User Meetup Group. As well I am active blogger and speaker at different SQL events such as SQL Saturdays, Meetups etc.
read moreAuckland SQL Group
MSDN PROFILE
SQL SERVER UPDATES
- Microsoft SQL Server 2022 Updates / Release Candidate (RC 1) Evaluation Edition (16.0.950.9)
- Microsoft SQL Server 2019 Updates / BETA (15.0.1000.34) / RTM (15.0.2000.5)
- Microsoft SQL Server 2017 Updates / RTM (14.0.1000.169)
- Microsoft SQL Server 2016 Updates / RTM (13.0.1601.5) / SP1 (13.0.4001.0 or 13.1.4001.0) / SP2 (13.0.5026.0 or 13.2.5026.0) / SP3 (13.0.6300.2 or 13.3.6300.2)
- Microsoft SQL Server 2014 Updates / RTM (12.0.2000.0) / SP1 (12.0.4100.1 or 12.1.4100.1) / SP2 (12.0.5000.0 or 12.2.5000.0) / SP3 (12.0.6024.0 or 12.3.6024.0)
- Microsoft SQL Server 2012 Updates / RTM (11.00.2100) / SP1 (11.0.3000.0 or 11.1.3000.0) / SP2 (11.0.5058.0 or 11.2.5058.0) / SP3 (11.0.6020.0 or 11.3.6020.0) / SP4 (11.0.7001.0 or 11.4.7001.0)