This post will cover how to move an Azure SQL database from one Azure SQL Server to another.
I have created two Azure SQL Servers in different regions, and both servers have a single database that we are going to use to perform this test.
The databases will have a database user login associated with them. All current database logins are copied over to the new database once the copy activity is done. The SQL Server admin credentials are, however, not copied over.
You should note that the security principal you use to copy over the database will become the new owner of the database (Administrator at the new Azure SQL Server).
We are going to copy test-db01 to a new Azure SQL Server over at test-sqlserver02. The database maintains a transactional consistent copy of the database from the time you initiated the copy activity. Any changes after that copy activity are not copied over.
Select the database that you want to copy and click on the copy button.
Next, change the database name with destination Azure SQL server as shown above, when done, select review and create.
Next, you should be able to access your database on the new Azure SQL Server.