getting error while taking azure sql backup

Question

I'm using below command to take azure sql databse backup, but getting error.

*** Error exporting database:Database source is not a supported version of SQL Server...tcp:xxxxx.database.windows.net,1433

"C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin\SqlPackage.exe" /Action:Export /SourceServerName:"tcp:xxxxx.database.windows.net,1433" /SourceDatabaseName:DbName /SourceUser:user /SourcePassword:password /TargetFile:C:\backups\backup.bacpac

What this mean? even export data tier application also throws same error.

Alberto Morillo · Accepted Answer · 2018-12-05 14:59:37Z

1

Please download the latest version of SQL Server Management Studio (SSMS). It seems you are using an old version of SSMS.

Alternatively, you can install a newer version of DacFx. Please download from here.

You can also use the Export option of Azure portal. To export to a blob storage account on Azure and then download the bacpac from there.

answered Dec 5, 2018 at 14:59

Alberto Morillo

15.8k3 gold badges29 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

getting error while taking azure sql backup

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related