Why You Should Migrate SQL Server to Azure
First, let's see about which SQL Server operating systems can be migrated into Azure SQL Database (ASD). If you are currently running your SQL Server database on any of these, there should be no problem migrating into Azure:
- SQL Server on-premises
- SQL Server on Azure Virtual Machines
- Amazon Web Services (AWS) Elastic Compute Cloud (EC2)
- AWS Relational Database Service (RDS)
- Compute Engine in Google Cloud Platform (GCP)
- Cloud SQL for SQL Server in GCP
- ASD handles most database management functions
- Built in high availability
- Intelligent query processing
- Great scalability based on business and data needs
- Performance capabilities for multiple application types
Before we go into the migration process a bit, let's talk about some key considerations that need to be taken into account when migrating your SQL Server DB into ASD:
- Number of servers and databases
- Size of databases
- Acceptable downtime during migration
Lastly, the migration process...
For the migration of SQL Server to Azure it's important to note some root features are unavailable in a SQL Managed Instance, which is why it's important to carry out this move with a partner. It's also important to estimate the compute size you'll need to run your systems. Using the Azure Calculator you can get an idea of cost, but you'll need to review compute power with an Azure Engineer to estimate how much usage you'll need vs. what you have now.
- Migrate the data with Microsoft's Data Migration Assistant
- Review features alerted on completion that aren't available
- Build a network in Azure to allow access to systems previously connected to your old SQL instance
- Start testing
As with any migration of data, it's best to start with a migration plan. Feel free to reach out if you're in the planning phase and need assistance moving forward.