SQLPackage and DB on Azure

Question

I am running sqlpackage from commandline:

sqlpackage.exe /action:Extract  /TargetFile:"C:\file.dacpac" /sourceDatabasename:dbsorgente  /sourceservername:dummy.database.windows.net  /p:ExtractAllTableData=True

and I get error: [Windows logins are not supported in this version of SQL Server]

The db is on Azure and from Sql Management STudio I can successfully connect to it. Can you help me ?

I am using Sql Autentication. – Riddick Oct 08 '21 at 14:41 — Riddick, Oct 08 '21 at 14:41

score 1 · Answer 1 · answered Oct 08 '21 at 14:51

You need to specify also /SourceUser: and /SourcePassword: in your command, otherwise it will use Windows login to authenticate to source server.

So your command should look like:

sqlpackage.exe /action:Extract  /TargetFile:"C:\file.dacpac" /sourceDatabasename:dbsorgente  /sourceservername:dummy.database.windows.net  /sourceuser=yourUser /sourcePassword=yourPassword /p:ExtractAllTableData=True

SQLPackage and DB on Azure

1 Answers1