I am not able to see any databases after connecting source SQL server to Azure Data migration Service.

Question

I am not able to see any databases after connecting source SQL server to Azure Data migration Service.

Amit Singh 0

I want to migrate the Azure SQL databases from one Tenant to another tenant using DMS in Azure SQL databases.

DMS-poc_ss

During the POC, while i am trying to connect my source, source connection is established successfully, but i dont any databases populated in source.

Tasadduq Burney 8,956 Reputation points MVP

2025-04-21T09:16:52.6166667+00:00

If the source connection is successful but no databases are showing:

Make sure the account used has read/list access to the databases.

Check if firewall settings or network rules are blocking metadata visibility.

Confirm the server is an Azure SQL Database (PaaS), not SQL Server on VM.

If using Azure SQL logical server, only user databases (not system DBs) will appear.

Verify the source server isn't empty or that databases aren't paused (in case of serverless).
Amit Singh 0 Reputation points

2025-04-21T11:19:04.3733333+00:00
It is Azure SQL db (PaaS)

I am able to see databases using same login in SSMS.

I dont any firewall or IP or Networking setting in DMS

All the databases are online
Saraswathi Devadula 7,415 Reputation points Microsoft External Staff Moderator

2025-04-21T14:59:11.03+00:00

Hello Amit Singh

Kindly please share the details requested in the private message for further investigation, which will help me to mitigate this issue.
Saraswathi Devadula 7,415 Reputation points Microsoft External Staff Moderator

2025-04-22T10:49:43.63+00:00

Hello Amit Singh

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Saraswathi Devadula 7,415 Reputation points Microsoft External Staff Moderator

2025-04-22T15:47:45.71+00:00

Hello Amit Singh

Kindly note that Azure Database Migration Service (DMS) does not support migrating Azure SQL databases between tenants. The service does not allow selecting an Azure SQL database as a source for migration. Instead, Azure DMS is designed to facilitate migrations from on-premises SQL Server to Azure SQL Database.

I kindly request you to please follow the below documents which will help you to migrate the Azure SQL databases from one tenant to another.

https://learn.microsoft.com/en-us/archive/technet-wiki/51360.azure-how-to-move-resources-between-subscriptions-under-different-tenants
https://techcommunity.microsoft.com/blog/modernizationbestpracticesblog/seamless-cross-tenant-migration-of-azure-sql-databases-without-modifying-connect/4356629
https://techcommunity.microsoft.com/blog/azuredbsupport/how-to-copy-azure-sql-database-to-a-different-subscription-and-different-tenant/3965985

Please do let me know if you have any further concerns. I am happy to address.
Saraswathi Devadula 7,415 Reputation points Microsoft External Staff Moderator

2025-04-23T06:31:02.18+00:00

Hello Amit Singh

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
PratikLad 1,830 Reputation points Microsoft External Staff Moderator

2025-04-25T09:36:03.39+00:00

Hello Amit Singh

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

1 answer

Your answer

Tasadduq Burney 8,956 Reputation points MVP

2025-04-21T09:16:52.6166667+00:00

If the source connection is successful but no databases are showing:

Make sure the account used has read/list access to the databases.

Check if firewall settings or network rules are blocking metadata visibility.

Confirm the server is an Azure SQL Database (PaaS), not SQL Server on VM.

If using Azure SQL logical server, only user databases (not system DBs) will appear.

Verify the source server isn't empty or that databases aren't paused (in case of serverless).
Amit Singh 0 Reputation points

2025-04-21T11:19:04.3733333+00:00

It is Azure SQL db (PaaS)

I am able to see databases using same login in SSMS.

I dont any firewall or IP or Networking setting in DMS

All the databases are online
Saraswathi Devadula 7,415 Reputation points Microsoft External Staff Moderator

2025-04-21T14:59:11.03+00:00

Hello Amit Singh

Kindly please share the details requested in the private message for further investigation, which will help me to mitigate this issue.
Saraswathi Devadula 7,415 Reputation points Microsoft External Staff Moderator

2025-04-22T10:49:43.63+00:00

Hello Amit Singh

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Saraswathi Devadula 7,415 Reputation points Microsoft External Staff Moderator

2025-04-22T15:47:45.71+00:00

Hello Amit Singh

Kindly note that Azure Database Migration Service (DMS) does not support migrating Azure SQL databases between tenants. The service does not allow selecting an Azure SQL database as a source for migration. Instead, Azure DMS is designed to facilitate migrations from on-premises SQL Server to Azure SQL Database.

I kindly request you to please follow the below documents which will help you to migrate the Azure SQL databases from one tenant to another.

https://learn.microsoft.com/en-us/archive/technet-wiki/51360.azure-how-to-move-resources-between-subscriptions-under-different-tenants
https://techcommunity.microsoft.com/blog/modernizationbestpracticesblog/seamless-cross-tenant-migration-of-azure-sql-databases-without-modifying-connect/4356629
https://techcommunity.microsoft.com/blog/azuredbsupport/how-to-copy-azure-sql-database-to-a-different-subscription-and-different-tenant/3965985

Please do let me know if you have any further concerns. I am happy to address.
Saraswathi Devadula 7,415 Reputation points Microsoft External Staff Moderator

2025-04-23T06:31:02.18+00:00

Hello Amit Singh

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
PratikLad 1,830 Reputation points Microsoft External Staff Moderator

2025-04-25T09:36:03.39+00:00

Hello Amit Singh

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Answer 1

PratikLad 1,830 Microsoft External Staff Moderator

Hello Amit Singh

Azure Database Migration Service (DMS) does not directly support migrating Azure SQL Databases (PaaS) between Azure Active Directory (AAD) tenants.

DMS is designed to handle migrations to Azure SQL Database from sources like SQL Server, MySQL, etc., but not from one Azure SQL Database to another across tenants.

Here are supported scenarios for Migration using Azure DMS:

enter image description here

Alternative methods to migrate Azure SQL database to a different subscription and different tenant:

Copy database
You can create a geo-secondary in a subscription different from the subscription of the primary under a different Azure Active Directory tenant
Using SQLpackage tool to Export/Import bacpac file.

Here in below documents you can refer to other alternative methods for copy Azure SQL database to a different subscription and different tenant

PratikLad 1,830 Reputation points Microsoft External Staff Moderator

2025-04-29T03:46:31.5+00:00

Hello Amit Singh

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
PratikLad 1,830 Reputation points Microsoft External Staff Moderator

2025-04-30T03:44:09.7433333+00:00

Hello Amit Singh

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Share via

I am not able to see any databases after connecting source SQL server to Azure Data migration Service.

1 answer

Your answer