Copy Database From One Azure subscription to Another

Step 1

Create login and user in the master database of the source server.

CREATE LOGIN migrationuser WITH PASSWORD = 'XXXXXXXXXX'
GO
CREATE USER migrationuser FOR LOGIN migrationuser WITH DEFAULT_SCHEMA=[dbo];
GO
ALTER ROLE dbmanager ADD MEMBER migrationuser;
GO

Step 2

Create the user in the source database and grant dbowner permission to the database.

CREATE USER migrationuser FOR LOGIN migrationuser WITH DEFAULT_SCHEMA=[dbo];
GO
ALTER ROLE db_owner ADD MEMBER migrationuser;
GO

Step 3

Capture the SID of the user "loginname" from master database

SELECT [sid] FROM sysusers WHERE [name] = 'migrationuser';

Result - 0x0106000000000064000000000000000070189A02C0E2E446B0034C6FD13AC46F

Step 4

Connect to Destination server. --Create login and user in the master database, same as of the source server.

CREATE LOGIN migrationuser WITH PASSWORD = 'XXXXXXXX', SID = 0x0106000000000064000000000000000070189A02C0E2E446B0034C6FD13AC46F;
GO
CREATE USER migrationuser FOR LOGIN migrationuser WITH DEFAULT_SCHEMA=[dbo];
GO
ALTER ROLE dbmanager ADD MEMBER migrationuser;
GO

Step 5

Execute the copy of database script from the destination server using the credentials created

CREATE DATABASE source
AS COPY OF [copy-sql-source].[source];