Azure Resource Mover

Microsoft recently held the 2020 Ignite conference. Just like in previous years, there were many announcements introducing new services and expanded capabilities of existing ones, especially in Azure.

Ahead of Ignite, I was asked to take a test drive of one of the new features, Azure Resource Mover (in preview). It’s easy to move a resource group to another subscription or move a resource to another resource group, but it hasn’t been easy to move a resource to another Azure region. This problem is now solved with Azure Resource Mover which allows you to move a resource such as a VM or Azure SQL Database to another region, and it figures out the dependencies for you.

Why would anyone want to move a resource to another region? Well, it might make sense to move resources closer to end users to decrease latency, maybe the organization has been part of an acquisition or merger and now they need to consolidate resources, or maybe a new region you have been waiting for has opened. There could be many reasons to move a resource to another region, and this new service makes it easy to do. You may be wondering about cost, however, and using this service is free.

I recently wrote a blog post about my experience if you would like to see more details of the process, but I’ll provide an overview here. Instead of using the Azure Portal for the move, you can also use PowerShell or Azure CLI.

1. Launch the Azure Resource Mover page
2. Set the subscription, source, destination
3. Choose the resource to move
4. Check for and add the dependencies
5. Modify destination resource settings as required, for example, resizing the VM
6. Prepare, initiate, and move the resources
7. Clean up old resources, or keep them in place if you wish

Note that it will take some time, maybe even days, to move a large VM. I’ve never tried to move a VM using the old process, but Microsoft says this new service significantly reduces the time required.

I also moved an Azure SQL Database. There was one big difference: I had to make sure that the target SQL Server service was in place. I already had one in the target region, so I just moved the database into that.

Azure Resource Mover is just one of the many announcements from the 2020 Microsoft Ignite conference!

Kathi Kellenberger

Join the debate, and respond to the editorial on the forums

As organizations realize the advantages they can g...

Here we are, another Tuesday!! It is time for our Fourth and final installment in the Failing SQL Agent Jobs series

Last time we discussed 5 backup types for SQL Server. Now I want to introduce you to five ways to make backups in SQL Server...

This post looks at a curious data type that isn’...

I have a client who is challenging me in a lot of ...

sp_RestoreScript 1.7 has been released. For information and documentation please visit https://sqlundercover.com/2017/06/29/undercover-toolbox-sp_restorescript-a-painless-way-to-generate-sql-server-database-restore-scripts/ Changes in 1.7 New Parameters @IncludeCopyOnly – 1 – Copy only backups are included0 – Copy only... The...

Containers are being used by more and more organizations to automate build pipelines in their CICD processes. In this article, Mahendran Purushothaman shows how to automate the creation of Docker containers and a Kubernetes cluster in Azure.

A long time ago, in early days of the Azure SQL Database in 2015, I wrote this article in which I tried to compare the SQL Server and Azure... The...

Total: 2 Average: 5Introduction Azure SQL Database is a Platform as a Service (PaaS) offered by Microsoft Azure. Hence, you need the Azure subscription to use this SQL Database....

Whether you are a SQL Server Database Administrato...

It is sometimes best to think of SQL Prompt as if it were a Treasure Island. You tend to come across the good things by setting out to discover them. Join us to discover the hidden gold within SQL Prompt.

Whether you are a SQL Server Database Administrato...

The DevOps Enterprise Summit, Las Vegas, is back from October 13 to October 15 and, even though it’s virtual this time around, it still promises to be engaging and...

Aaron Bertrand continues explaining the evolution ...

Like any technology, AI can be used for evil instead of good. Shree Das explains several examples and what should be done to prevent the misuse of data.

Git is used by many teams for version control. In this article, Dino Esposito takes a look back at the history of source control and how git became the popular tool it is today.

Last week one of my Azure Data Factory deployment pipelines...

Click to learn more about co- author Ion Stoica. Click to learn more about co- author Ben Lorica. Machine learning platform designers need to meet current challenges and plan...

Kellyn Pot'Vin-Gorman explains Oracle Automatic Storage Management and why it’s impossible to do a comparison to Azure IaaS.

Oracle has been established as one of the top database systems used in enterprises throughout the world. In this article, Cynthia Dzikiti describes her career as an Oracle application...

Welcome to part eleven of the plansplaining series. You will have noticed that this is no longer a monthly series.

In this article, Edward Pollack describes some of ...

Computed columns may be the cause of hard to track down performance issues. In this article, Robert Sheldon reviews the issues and some ways to get around them.

Most of the time when the optimizer t...

I love questions. Most of all, I love questions I can answer. I spotted this question recently: How can I use Profiler to capture execution plans for queries over...

n this 28th article for SQL Server Always On Availability Group series, we explore the high-availability for the SQL Server PolyBase(SSB) external tables using AG groups.

While I was preparing to work in the new (for me) ...

Thanks for watching this week's Power BI news roun...

While I was preparing to work in the new (for me) ...

Are you really, really good at designing Power BI ...

Join us live as we answer your questions about Pow...

As a Power BI developer I know how Power Query makes it easy to get data from web sources, but I also know there are limits to what it...

I want PASS to survive. I can say that unequivocally, because this organization has been a part of my career, my job, and my life for twenty years. Many... The...

Over the last week, I’ve seen two discussions where the securityadmin server role was suggested.

While the terms “Data Security” and “Data Breach” have been around for a long time, they acquired a lot of traction a few years ago with the...

Roaster It doesn’t take much to let a bad perso...

This post shows how to run a SQL Server Instance on about any computer using Docker Containers.

I’ve been blogging about running SQL Server in D...

Another post for me that is simple and hopefully s...