This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 6%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
I made an Azure SQL Database and I am trying to use an SSIS package in Visual Studio to move tables and views to it from my desktop SQL Server 2016 database. I get an error message about the "USE" statement. I don't know why my script would even have a "USE" statement since I am not switching between databases. I am just moving tables and views from a single database locally to a single database in Azure. How can I fix this? Am I just going about this the wrong way?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 97%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Hi @Andrew Harris , great to hear things worked for you. You can mark the answer as 'Accepted Answer' that helped you, so to help others having similar queries.
Alberto,
I was able to successfully migrate a database using the DMA. I had been selecting "assessment" instead of "migration". Once I switched to migration I was able to use SQL Server authentication and everything worked great. Thank you for all of your help.
-Andrew
Wonderful. I am really glad it worked for you!
Andrew,
Allow me to recommend you the easiest way to move SQL Server tables/views to Azure SQL. Please try Azure Data Migration Assistant. It can perform an assessment and also an offline migration of the data with just a few clicks.
Take a look at this step-by-step tutorial.
Now i'm having trouble uploading my migration assessment to Azure because I think I have two microsoft accounts using the same email. Here is the error message:
Failed to fetch subscription list from Azure.
AADSTS16000: Either multiple user identities are available for the current request or selected account is not supported for the scenario.
How do I fix this problem?
Create a SQL login on the Azure SQL database, and use that SQL login (SQL Server authentication) to connect to the Azure SQL from inside Data Migration Assistant
It forces me to log in to an Azure account first. There is no opportunity to specify the SQL database.
Does it matter that I'm on a free account? Part of the error message says " or selected account is not supported for the scenario."
Oh yes! If you applied for the $200 credit you have option for Azure SQL DTU S0 only. Please refer to this page to know what options are available for you and their limits.
I upgraded to "Pay as you Go" and I still get the same error message.
Do you have many objects/work created with this subscription? It seems you were testing Azure. Can you create a pay as you go account associated with a email account and try with the newly created subscription?
I upgraded to "Pay as you Go" and still get the same error message:
Failed to fetch subscription list from Azure.
AADSTS16000: Either multiple user identities are available for the current request or selected account is not supported for the scenario.
Are you sure I can't use SSIS to do this? I'm not trying to do a one-time migration. I need a way to regularly copy one or more tables/views from my local SQL Server 2016 to Azure SQL Database. This was very easy to do with SSIS when my cloud database was a SQL Server database. Now it seems to be very difficult. Am I missing something?