1

I have one database in azure and accessing in my SQL Server Management studio and try to export the database but gives me the errors.

Here are the steps I have done:

1) Export data-tier Application

enter image description here

2) No of errors I got

enter image description here

3) Got this error in all the processes:

enter image description here

I am using SSMS (2014 and 2016)

user2185592
  • 368
  • 1
  • 8
  • 24
Mahavirsinh Padhiyar
  • 1,299
  • 11
  • 33

1 Answers1

0

Try downloading the latest version of SQL Server Management Studio in order to have the best user experience with Azure SQL Database. Please download it from here

That dss schema means you were using SQL Data Sync. You may need to use the deprovision utility to clean that remnants left by SQL data Sync.

Alternatively you can use SQLpackage, PowerShell or Azure Portal to do the same task. You can learn more about it here.

SqlPackage.exe /a:Export /tf:testExport.bacpac /scs:"Data Source=apptestserver.database.windows.net;Initial Catalog=MyDB;" /ua:True /tid:"apptest.onmicrosoft.com"
Alberto Morillo
  • 13,893
  • 2
  • 24
  • 30