Change ownership of an SQL server

Question

My company has two accounts that host SQL servers. We want to empty one account and transfer the SQL servers on to a single account. Ideally we just want to change their ownership and keep the SQL servers untouched otherwise such that all the fees for these SQL DBs are paid from the same account. We do not want to touch the data and let them keep their host URL as they are being used constantly. Is this possible? And if so, how would we do that?

Answer 1

Hi Martijn Schilpzand •,

Welcome to Microsoft Q&A forum.

As I understand, you want to change ownership of SQL Server.

Could you please let us know if the question is about Azure SQL Database SQL Server?

If you want to Move Azure SQL Server to a different subscription, please use option as shown below from Azure Portal:

If you want to Copy then use steps mentioned here:

https://learn.microsoft.com/en-us/azure/azure-sql/database/database-copy?view=azuresql&tabs=azure-powershell#copy-to-a-different-subscription

You can try below options if suitable to your usecase:

• PITR restore method -

Step 1: Create new server in source subscription Step 2 : Copy the database from source server to newly created server within the same subscription step 3 : move the entire server to the destination subscription along with the database step 4: now again copy the database from moved server between the servers within destination server

Reference: Move server https://techcommunity.microsoft.com/t5/azure-database-support-blog/how-to-move-azure-sql-server-to-another-subscription/ba-p/368790

Reference Copy database: https://learn.microsoft.com/en-us/azure/azure-sql/database/database-copy?tabs=azure-powershell

• Bacpac restore method / export-import method

You can also use export import method

Step 1: Export the source database in .bacpac format and store it into the storage account / local storage Step 2 : Import the bacpac into destination server

Reference : Export - https://learn.microsoft.com/en-us/azure/azure-sql/database/database-export Import- https://learn.microsoft.com/en-us/azure/azure-sql/database/database-import?tabs=azure-powershell

Blogpost: https://www.mssqltips.com/sqlservertip/5189/restore-an-azure-sql-database-from-one-server-to-another-server/

• Direct copy the database to another subscription

Copy the database directly to the different subscription. Please note this method is not supported via azure portal.

Let us know if this helps. If not, we will continue to understand more from you.

Thanks