Como realizar un backip en mi PC de una base de datos SQL Azure

Question

Buenas tardes,
Por favor su ayuda, ando intentando hacer una backup en mi PC desde una base de datos SQL Azure.
Saludos,
Joseph
Lima

Using Bing Translator
Question Title: How to backup my PC of an Azure SQL database

Question body: Please your help, I'm trying to make a backup on my PC from an Azure SQL database.
Best regards

Answer 1

Hi, @Joseph Buttgenbach Welcome to the Microsoft Q&A platform, thanks for posting the question
Unfortunately, this forum is only offered in English at this time.I have translated your question into English.
You can follow this document to export data from the Azure portal or by using SSMS

From SSMS you can also check this blog here

Please let me know if you need any additional information.

Regards
Geetha

Answer 2

Answer in English

In addition to procedure shared by Geetha, you can create a local bacpac of the Azure SQL Database using Poweshell.

$exportRequest = New-AzSqlDatabaseExport -ResourceGroupName $ResourceGroupName -ServerName $ServerName `  
  -DatabaseName $DatabaseName -StorageKeytype $StorageKeytype -StorageKey $StorageKey -StorageUri $BacpacUri `  
  -AdministratorLogin $creds.UserName -AdministratorLoginPassword $creds.Password  

or using sqlpackage utility:

SqlPackage /Action:Export /SourceServerName:SampleSQLServer.sample.net,1433  
  
/SourceDatabaseName:SampleDatabase /TargetFile:"F:\Temp\SampleDatabase.bacpac"  

Respuesta en Español.

En adición al procedimiento que te ha compartido Geetha en su respuesta, también puedes usar PowerShell

$exportRequest = New-AzSqlDatabaseExport -ResourceGroupName $ResourceGroupName -ServerName $ServerName `  
  -DatabaseName $DatabaseName -StorageKeytype $StorageKeytype -StorageKey $StorageKey -StorageUri $BacpacUri `  
  -AdministratorLogin $creds.UserName -AdministratorLoginPassword $creds.Password  

o usar un utilitario llamado sqlpackage que puedes descargar aquí.

SqlPackage /Action:Export /SourceServerName:SampleSQLServer.sample.net,1433  
  
/SourceDatabaseName:SampleDatabase /TargetFile:"F:\Temp\SampleDatabase.bacpac"