I would like to write a C# console application which performs the operations as described in this article: https://msdn.microsoft.com/en-us/library/azure/dn781282.aspx  to export a SQL database to a storage blob.  The article does not describe what the name of the database backup is to be called, which when performing this operation in the Azure management portal, is a value that can be supplied.  Finally, if I could get an example of how this could actually work as I continually get a 405 error when my C# application attempts to perform the

Here is a sample of how to use Import Export service in C#.

If you don't mind me asking, what is the scenario for which you are using Import/Export? If you are looking for basic backup and recovery, we have backups automatically taken for all Basic, Standard, and Premium databases. These backups can be used for recovering after unintended data modification or deletion. In addition to this, every hour we replicate a backup to a separate region. This is so in the event of a regional disaster you can recover from the 1 hour old backup. 

We have a blog post which discusses when to use the built-in backup and restore and when to use import/export.

Regards,

-Eli

• Edited by Eli FisherMicrosoft employee 16 hours 27 minutes ago

Here is a sample of how to use Import Export service in C#.

If you don't mind me asking, what is the scenario for which you are using Import/Export? If you are looking for basic backup and recovery, we have backups automatically taken for all Basic, Standard, and Premium databases. These backups can be used for recovering after unintended data modification or deletion. In addition to this, every hour we replicate a backup to a separate region. This is so in the event of a regional disaster you can recover from the 1 hour old backup. 

We have a blog post which discusses when to use the built-in backup and restore and when to use import/export.

Regards,

-Eli

• Edited by Eli FisherMicrosoft employee 16 hours 20 minutes ago

Here is a sample of how to use Import Export service in C#.

If you don't mind me asking, what is the scenario for which you are using Import/Export? If you are looking for basic backup and recovery, we have backups automatically taken for all Basic, Standard, and Premium databases. These backups can be used for recovering after unintended data modification or deletion. In addition to this, every hour we replicate a backup to a separate region. This is so in the event of a regional disaster you can recover from the 1 hour old backup. 

We have a blog post which discusses when to use the built-in backup and restore and when to use import/export.

Regards,

-Eli

• Edited by Eli FisherMicrosoft employee Wednesday, August 26, 2015 2:47 PM

Here is a sample of how to use Import Export service in C#.

If you don't mind me asking, what is the scenario for which you are using Import/Export? If you are looking for basic backup and recovery, we have backups automatically taken for all Basic, Standard, and Premium databases. These backups can be used for recovering after unintended data modification or deletion. In addition to this, every hour we replicate a backup to a separate region. This is so in the event of a regional disaster you can recover from the 1 hour old backup. 

We have a blog post which discusses when to use the built-in backup and restore and when to use import/export.

Regards,

-Eli

• Edited by Eli FisherMicrosoft employee Wednesday, August 26, 2015 2:47 PM

Here is a sample of how to use Import Export service in C#.

If you don't mind me asking, what is the scenario for which you are using Import/Export? If you are looking for basic backup and recovery, we have backups automatically taken for all Basic, Standard, and Premium databases. These backups can be used for recovering after unintended data modification or deletion. In addition to this, every hour we replicate a backup to a separate region. This is so in the event of a regional disaster you can recover from the 1 hour old backup. 

We have a blog post which discusses when to use the built-in backup and restore and when to use import/export.

Regards,

-Eli

• Edited by Eli FisherMicrosoft employee Wednesday, August 26, 2015 2:47 PM

this user has a requirement with a government agency that requires a copy of the entire database be delivered to them on a semi-weekly basis. they have a process that works well in obtaining the local copy and preparing it for delivery, just need to actually get a local copy now from Azure.

In this scenario, you would likely want to leverage out Import/Export service, as it is designed for database migration in and out of Azure. You could leverage the script I linked to earlier. 

I would suggest following the process below:

1. Create a copy of the database you want to export. (This is to guarantee a consistent BACPAC file)
2. Start the export operation on the database copy. (I'd suggest exporting to storage in the same region of the database to avoid network latency issues)
3. Delete the copy of the database after the export completes
4. Download the BACPAC file from the storage account onto your local machine.

Regards,

-Eli

In this scenario, you would likely want to leverage out Import/Export service, as it is designed for database migration in and out of Azure. You could leverage the script I linked to earlier. 

I would suggest following the process below:

1. Create a copy of the database you want to export. (This is to guarantee a consistent BACPAC file)
2. Start the export operation on the database copy. (I'd suggest exporting to storage in the same region of the database to avoid network latency issues)
3. Delete the copy of the database after the export completes
4. Download the BACPAC file from the storage account onto your local machine.

Regards,

-Eli

• Proposed as answer by Casey KarstMicrosoft employee, Moderator 16 hours 1 minutes ago

In this scenario, you would likely want to leverage out Import/Export service, as it is designed for database migration in and out of Azure. You could leverage the script I linked to earlier. 

I would suggest following the process below:

1. Create a copy of the database you want to export. (This is to guarantee a consistent BACPAC file)
2. Start the export operation on the database copy. (I'd suggest exporting to storage in the same region of the database to avoid network latency issues)
3. Delete the copy of the database after the export completes
4. Download the BACPAC file from the storage account onto your local machine.

Regards,

-Eli

• Proposed as answer by Casey KarstMicrosoft employee, Moderator Friday, September 04, 2015 3:10 PM
• Marked as answer by doghouseprogrammer 12 hours 25 minutes ago

In this scenario, you would likely want to leverage out Import/Export service, as it is designed for database migration in and out of Azure. You could leverage the script I linked to earlier. 

I would suggest following the process below:

1. Create a copy of the database you want to export. (This is to guarantee a consistent BACPAC file)
2. Start the export operation on the database copy. (I'd suggest exporting to storage in the same region of the database to avoid network latency issues)
3. Delete the copy of the database after the export completes
4. Download the BACPAC file from the storage account onto your local machine.

Regards,

-Eli

• Proposed as answer by Casey KarstMicrosoft employee, Moderator Friday, September 04, 2015 3:10 PM
• Marked as answer by doghouseprogrammer Saturday, September 05, 2015 6:41 PM