Are you looking to modernize your data platform by migrating your on-prem database to Azure? Azure’s Database Migration Assistant is a free, downloadable tool to make this a much simpler process. The Database Migration Assistant provides seamless assessments of SQL Server on premises, as well as upgrades to later versions of SQL Server or migrations to SQL Server on Azure VMs or Azure SQL Database.
In today’s blog/video I’ll walk through using the Data Migration Assistant to assess for migrating an on premises SQL Server Database to an Azure SQL Database. For those who are unaware, the Data Migration Assistant enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality on your Azure SQL Database, as well as SQL Server on an Azure VM. It also recommends performance and reliability improvements.
Within Azure, we have a few options to run our SQL Databases. We have Azure SQL Data Warehouse, which is built for large scale, big data relational databases. We can also run our SQL on Azure SQL VMs, where we can gain benefits by doing this within Azure compared to running them on VMWare or Hyper Feed.
At 3Cloud, we’re all about helping you transform your business and your data with Azure. I’m excited to share a real-world story about a company that, with our help, is transforming the way that they do reporting and analysis using all the data tool and platforms offered in the Azure cloud.
Sometimes it’s hard to know which SQL platform is the best fit for you and your business. We speak with many of our customers about what platform they should be putting their data in within Azure. I’d like to talk about Azure SQL Data Warehouse and whether or not it is the right fit for your data workloads and your organization.