Is there a way to Export and Import a BACPAC file using Azure Storage and SQLPackage.exe

We are working on some automation that involves creating a BACPAC of an on-premise SQL 2014 database to local storage using SQLPackage.exe.  We would now like to specify the destination of the BACPAC in the Azure Cloud Storage.  This would get the BACPAC file out of the datacenter and "closer" to the internet.  The Import feature of SQLPackage.exe would be configured to use the Azure Cloud Storage as well. 

The issue I have run into is that I don't see any parameters that would allow me to specify the target or source in the Azure storage.  Is there such a feature and how can I get help on it?

Thanks.&

July 28th, 2015 2:16pm

Hi,

 I could not find any parameters specific to SQLPackage.exe, however I found the below link which shows how to do it in combination with Powershell.
 http://tstringer.azurewebsites.net/?p=1051
 
 Let us know if this helps.

Regards,
Nithin Rathnakar

Disclaimer: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

Free Windows Admin Tool Kit Click here and download it now
July 29th, 2015 9:15am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics