Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement. engine. PaaS capabilities built into Azure SQL Database enable you to focus on the domain-specific database administration and optimization activities that are critical for your business. It support modern cloud applications on an intelligent, managed service that includes serverless compute. Azure SQL Database is always running on the latest stable version of the SQL Server database.
Customers running SQL Server workloads on Amazon RDS for SQL Server were looking to migrate to Azure SQL Database. The reason being Azure SQL Database can provide additional benefits not available in Amazon RDS for SQL Server. The benefits were discussed in previous post Part 1.
Currently, you can migrate Amazon RDS for SQL Server to Azure SQL database using any of the following methods:
It is the easiest to use and is integrated with SQL Server Management Studio. However, it requires additional storage and downtime because data is exported at the source, possibly copied to another location and then imported at the destination. We encourage using this method to import/export databases lesser than 150GB because it takes a long time to process databases with many objects.
Migrates schema and data.
Good for medium-sized deployments (i.e., small number of databases).
Azure Data Studio, a cross-platform tool now with the Azure SQL Migration Extension, you assess, get right-sized recommendations, and migrate to different Azure SQL targets offline or online. For Azure SQL DB, it supports only offline Migration
In this blog post, I will demonstrate how to use the Azure Migration extension of Azure Data Studio to migrate AWS RDS SQL Server database to Azure SQL Database offline.
The Azure SQL migration extension for Azure Data Studio enables you to assess, get right-sized Azure recommendations and migrate your SQL Server databases to Azure.
Before you get started, you must complete the following prerequisites:
2. Create tables and populate data in your source RDS SQL Server database that will drive the data migration.
To open the Migrate to Azure SQL wizard:
b. Select View/Select to view the assessment results.
c. In the assessment results, select the database, and then review the assessment report to make sure no issues were found.
d. Select Get Azure recommendation to open the recommendations pane.
e. Select Collect performance data now. Select a folder on your local computer to store the performance logs, and then select Start.
f. Azure Data Studio collects performance data until you either stop data collection or you close Azure Data Studio.
After 10 minutes, Azure Data Studio indicates that a recommendation is available for Azure SQL Database. After the first recommendation is generated, you can select Restart data collection to continue the data collection process and refine the SKU recommendation. An extended assessment is especially helpful if your usage patterns vary over time.
In the selected Azure SQL Database target, select View details to open the detailed SKU recommendation report:
g. In the selected Azure SQL Database target, select View details to open the detailed SKU recommendation report:
In Step 3: Azure SQL target in the Migrate to Azure SQL wizard, complete these steps for your target Azure SQL Database instance:
a. Select your Azure account, Azure subscription, the Azure region or location, and the resource group that contains the Azure SQL Database deployment.
b. For Azure SQL Database Server, select the target Azure SQL Database server (logical server). Enter a username and password for the target database deployment. Then, select Connect. Enter the credentials to verify connectivity to the target database.
c. Next, map the source database and the target database for the migration. For Target database, select the Azure SQL Database target. Then, select Next to move to the next step in the migration wizard.
In Step 4: Azure Database Migration Service in the Migrate to Azure SQL wizard, create a new instance of Azure Database Migration Service or reuse an existing instance that you created earlier. In this example, I’m using an existing instance of Database migration instance.
To use an existing instance of Database Migration Service:
Note: To create a new Database migration Service. Refer this documentation link.
In Step 5: Data source configuration, complete the following steps:
3. In Select tables for <BikeStores>, select the tables to migrate to the target. The Has rows column indicates whether the target table has rows in the target database. You can select one or more tables. Then, select Update.
You can update the list of selected tables anytime before you start the migration.
4. After selecting Run validation, a Running validation panel appears on the right side of Azure Data Studio:
a. The pre-migration validation runs automatically, verifying multiple settings in the migration configuration. On the Running validation panel, under the Validation steps, the process goes through checking Integration runtime connectivity, Source database connectivity, and Target database connectivity.
b. After all, steps are successfully validated, select Done.
c. Review your table selections, and then select Next to move to the next step in the migration wizard.
In Step 6: Summary in the Migrate to Azure SQL wizard, review the configuration you created, and then select Start migration to start the database migration.
Under Database migration status, you can track migrations that are in progress, completed, and failed (if any), or you can view all database migrations.
In this blog post, we have discussed usage of Azure Data Studio for migrating data from Amazon RDS for SQL Server Instance to Azure SQL Database.
The Azure SQL migration extension for Azure Data Studio enables you to assess, get right-sized Azure recommendations for Azure migration targets, and migrate databases offline from on-premises SQL Server, SQL Server on Azure Virtual Machines, or any virtual machine running in the cloud (private, public) to Azure SQL Database.
To learn more about Azure SQL Database Offline migrations, see Tutorial: Migrate SQL Server to an Azure SQL Database offline using Azure Data Studio with DMS.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.