{"id":17851,"date":"2024-04-04T11:29:36","date_gmt":"2024-04-04T05:59:36","guid":{"rendered":"https:\/\/opstree.com\/blog\/\/?p=17851"},"modified":"2024-04-21T13:50:27","modified_gmt":"2024-04-21T08:20:27","slug":"migration-of-ms-sql-from-azure-vm-to-amazon-rds","status":"publish","type":"post","link":"https:\/\/opstree.com\/blog\/2024\/04\/04\/migration-of-ms-sql-from-azure-vm-to-amazon-rds\/","title":{"rendered":"Migration Of MS SQL From Azure VM TO Amazon RDS"},"content":{"rendered":"\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n

Overview<\/strong><\/p>\r\n\r\n\r\n\r\n

Recently I am working with the client using Azure Cloud for their application and the microsoft SQL server is hosting on a virtual machine so they found the need to migrate the application from Azure to AWS due to some amazing features and services of it which would be very helpful to enhance the app & it’s functionalities.<\/p>\r\n\r\n\r\n\r\n

So in order to do that my client decided to migrate the Database from VM to Amazon RDS in order to release the burden of its management along with all related tasks too, since it’s quite difficult to manage a database on a VM & on the other hand as Amazon RDS is a fully managed service & a better platform for running relational databases on Amazon Web Services (AWS).<\/p>\r\n\r\n\r\n\r\n

In this article we will do the hands on of migrating Microsoft SQL server from Azure VM to Amazon RDS by using AWS Database Migration Service with minimal downtime.<\/p>\r\n

<\/p>\r\n\r\n\r\n\r\n

To know more about AWS DMS you may follow the link below : https:\/\/opstree.com\/blog\/\/2023\/06\/20\/database-migration-service-in-aws\/<\/a><\/p>\r\n\r\n\r\n\r\n

Prerequisites<\/strong><\/p>\r\n\r\n\r\n\r\n


1. Azure VM With MS SQL Installed , Follow the below link for the same.<\/p>\r\n\r\n\r\n\r\n

( https:\/\/discourse.ubuntu.com\/t\/microsoft-sql-server-2019-on-ubuntu-20-04\/21943<\/a> )<\/p>\r\n\r\n\r\n\r\n

( https:\/\/learn.microsoft.com\/en-us\/azure\/virtual-machines\/linux\/quick-create-portal?tabs=ubuntu<\/a> )<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

This Azure VM With Microsoft SQL Server Installed & In Running State<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

Install the command line tools to interact with it<\/p>\r\n\r\n\r\n\r\n

2. Site To Site VPN Established Connection Among Both Clouds<\/p>\r\n\r\n\r\n\r\n

3. MS SQL Database ( Target ) within Amazon RDS. Create by following this link https:\/\/aws.amazon.com\/getting-started\/hands-on\/create-mysql-db\/<\/a><\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

Let’s get hands dirty here<\/strong>…<\/p>\r\n\r\n\r\n\r\n

Create a Replication Instance<\/strong><\/h3>\r\n\r\n\r\n\r\n

Open the AWS Console, search for Database Migration Service and choose Replication Instances from the navigation pane. Then choose to \u201cCreate a replication instance\u201d<\/code>, provide the required details as shown below.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n

After you click on the \u201cCreate replication instance\u201d<\/code> button, AWS provisions your replication instance. When your replication instance is ready to run, its status is \u201cAvailable\u201d<\/code>, as\u00a0shown.<\/mark><\/strong><\/p>\r\n\r\n\r\n\r\n

Note:<\/strong> Go to the Security Groups section<\/a> in the Amazon EC2 console & Azure VM. You need to check whether your security group allows your replication instance to access your RDS target database and Source database. Set the rule accordingly.<\/p>\r\n\r\n\r\n\r\n

Creating Target and Source Endpoints<\/h3>\r\n\r\n\r\n\r\n

Target endpoint<\/h3>\r\n\r\n\r\n\r\n

First, create the endpoint for your target database. Navigate to the Endpoints section<\/a> of the AWS DMS console. Choose \u201cCreate endpoint\u201d<\/code> to create a new endpoint, as shown<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n

Click on the \u201cRun test\u201d<\/code> button to test the target endpoint. After a few seconds, you should see a Status of successful. After seeing the status value is \u201csuccessful\u201d<\/code>, click on the \u201cCreate endpoint\u201d<\/code> button\u00a0.<\/mark><\/strong><\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

We have successfully created target endpoint now<\/p>\r\n\r\n\r\n\r\n

Source endpoint<\/strong><\/h3>\r\n\r\n\r\n\r\n

Follow these same steps again to create an endpoint for your source database, as shown\u00a0.\u00a0<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n

Both EndPoints Have Been Created Successfully.<\/p>\r\n\r\n\r\n\r\n

Creating a Migration Task<\/h3>\r\n\r\n\r\n\r\n

A migration task is responsible for migrating data from a source database to a target database. In order to start, navigate to the Database migration tasks<\/a> section of the AWS DMS console. Choose \u201cCreate task\u201d<\/code> to create a new Database migration task, as shown below.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n

Here we can see that the migration process has been successfully completed<\/p>\r\n\r\n\r\n\r\n

Monitoring and Checking The Migration Task\u2019s\u00a0Output<\/h3>\r\n\r\n\r\n\r\n

By Using Amazon Cloudwatch Logs<\/h3>\r\n\r\n\r\n\r\n

Navigate to the \u201cOverview details\u201d<\/code> section in DMS Task, and then click on the \u201cView Cloudwatch Logs\u201d<\/code>,<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n

These logs provide full details about the migration.<\/p>\r\n\r\n\r\n\r\n

By Using Azure Data Studio<\/strong><\/p>\r\n\r\n\r\n\r\n

To Install Azure Data Studio you may follow the link below. https:\/\/database.guide\/how-to-install-azure-data-studio-on-ubuntu-20-04\/<\/a><\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

 <\/p>\r\n\r\n\r\n\r\n

AWS Database Migration Service pricing<\/h1>\r\n\r\n\r\n\r\n

Data Migration Service is a free migration solution for switching to DocumentDB, Redshift, Aurora, or DynamoDB. You must pay for other databases based on the volume of log storing and the computational load.<\/p>\r\n\r\n\r\n\r\n

When migrating your source database to a destination database in a different Availability Zone, Region, or outside of AWS, standard AWS data transfer rates apply.<\/p>\r\n\r\n\r\n\r\n

To get further details about the pricing please go through the link below . https:\/\/aws.amazon.com\/dms\/pricing\/<\/a><\/p>\r\n\r\n\r\n\r\n

Conclusion<\/h3>\r\n\r\n\r\n\r\n

We migrated a MS SQL Database to Amazon RDS by using AWS DMS. To do this, we created a target \u201cRDS MySQL Database\u201d, a replication instance, target and source endpoints, and a migration task. Finally, we monitored our database migration by using Cloudwatch logs & Azure Data Studio\u00a0. It took me around 15-20 minutes to complete the whole migration process as the time is totally depends upon the amount of data we have for the migration.<\/p>\r\n\r\n\r\n\r\n

\ud83d\ude4f Thank you for reading this blog.<\/p>\r\n\r\n\r\n\r\n

Before you\u00a0go:<\/h3>\r\n\r\n\r\n\r\n

Clap if you liked it \ud83d\udc4f, comment and share this article to reach more community \ud83e\uddde.<\/p>\r\n","protected":false},"excerpt":{"rendered":"

Overview Recently I am working with the client using Azure Cloud for their application and the microsoft SQL server is hosting on a virtual machine so they found the need to migrate the application from Azure to AWS due to some amazing features and services of it which would be very helpful to enhance the … Continue reading “Migration Of MS SQL From Azure VM TO Amazon RDS”<\/span><\/a><\/p>\n","protected":false},"author":244582671,"featured_media":18266,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"[]","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false},"version":2}},"categories":[28070474],"tags":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/opstree.com\/blog\/wp-content\/uploads\/2024\/04\/MS-SQL-Migration-Azure-VM-to-Amazon-RDS-1.png","jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pfDBOm-4DV","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/posts\/17851"}],"collection":[{"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/users\/244582671"}],"replies":[{"embeddable":true,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/comments?post=17851"}],"version-history":[{"count":44,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/posts\/17851\/revisions"}],"predecessor-version":[{"id":18033,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/posts\/17851\/revisions\/18033"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/media\/18266"}],"wp:attachment":[{"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/media?parent=17851"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/categories?post=17851"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/tags?post=17851"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}