I want to Export Mssql file from azure to local system according to this link
But when I go to Export and click on the storage configuration:
and then it opens configuration form but nothing happen there and storage option is also closed
Any solution for it ?
Asked
Active
Viewed 45 times
1
Ahmad Raza
- 39
- 7
-
try creating a storage account first in the same resource group. – Aravind Jun 14 '18 at 10:32
2 Answers
0
As a workaround, you can use SqlPackage to export an Azure SQL Database to a local folder in your computer as a bacpac.
SqlPackage /Action:Export /SourceServerName:SampleSQLServer.sample.net,1433 /SourceDatabaseName:SampleDatabase /TargetFile:"F:\Temp\SampleDatabase.bacpac"
Alberto Morillo
- 13,893
- 2
- 24
- 30
-
for this I have to install SQL or just run this command in CMD it will work ? I have just used SQL of Visual Studio not separately installed ? – Ahmad Raza Jun 15 '18 at 07:21
-
The following URL shows you how to obtain it https://stackoverflow.com/questions/50315074/unable-to-publish-dacpac-to-azure-sql-database-using-sqlpackage-exe/50321062#50321062 – Alberto Morillo Jun 15 '18 at 10:53
0
This is likely a UI bug in the Azure Portal.
Please create an Storage Account prior to exporting the Azure SQL Database and it will be available as follows:
Evandro de Paula
- 2,532
- 2
- 18
- 27