During the POC, while I am trying to connect my source, source connection is established successfully, but I don't get any databases populated in the source.
I want to migrate the Azure SQL databases from one tenant to another tenant using DMS in Azure SQL databases.
DB_owner roleAzure Database Migration Service is a fully managed service designed to enable seamless migrations from multiple database sources to Azure data platforms
here are supported migration scenarios using Azure DMS mentioned in document. Azure SQL database is not supported as source.
Use SqlPackage to copy Azure SQL Database from one tenant to another:=
Download and install SQLPackage from here [Download and install SqlPackage - SQL Server | Microsoft Learn] After installing SQLPackage go to the installed folder C:\Program Files\Microsoft SQL Server\160\DAC\bin, You need to run CMD from this location.
Export Database : Export with the following command, you only need to replace your path, server and database name as well as username and password to connect to the database.
SqlPackage /Action:Export /TargetFile:"C:\SQLPackageFiles\ExportHere.bacpac" /df:"C:\SQLPackageFiles\log.txt" /SourceConnectionString:"Server=tcp:xxx.database.windows.net,1433;Initial Catalog=YourDatabaseNameHere;Persist Security Info=False;User ID=YourUserName;Password=YourPassword;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"
SqlPackage /Action:Import /SourceFile:"C:\SQLPackageFiles\ExportHere.bacpac" /df:"C:\SQLPackageFiles\log_import.txt" /TargetConnectionString:"Server=tcp:YourTargetServerName.windows.net,1433;Initial Catalog=MyNewDatabase;Persist Security Info=False;User ID=YourUserName;Password=YourPassword;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"
Refer this document by @Matt Mansoomi for more understanding
