I have more than 200 databases and I want to migrate it from on-premises SQL Server to Azure SQL Database using sqlpackage.exe.
"sqlpackage.exe /a:Export /ssn: /sdn: /su: /sp: /tf:"
this is the command I am using for creating bacpac file of database in on-premises
"sqlpackage.exe /a:Import /sf: /tsn: /tdn: /su: /sp:"
this is the command I am using for migrating the data to Azure SQL Database
But how I can use this in loop or something similar so that I won't have to Manually enter the database name.