Note: The information on this site is out of date and will be replaced with code samples on MSDN in the near future. We recommend that you consider writing your own client application to import/export from Azure.  More details here.

 

 

 

 

 

 

 

 

DAC Import/Export Hosted as a Service

The new Import/Export Service for SQL Azure is now live. The service will directly import or export between a SQL Azure database and Windows Azure BLOB storage. The service complements the client side tools already available - for more information see the main documentation page. Databases exported to a BACPAC using the client side tools can be uploaded to Windows Azure BLOB storage and imported using the service. Similarly, databases exported to a BACPAC using the service can be imported using the client side tools.

                                                            Skip the content - take me directly to the download!





Requirements

All you need is the EXE and the configuration file provided as a download in this release as well as a public internet connection. No other downloads are necessary to interact with the service.

Note the service imports and export between SQL Azure and Windows Azure BLOB storage only - you must have a storage account set up in order to use the service.

Usage

The new EXE provided as a part of this CodePlex release submits import, export, or status requests to the service. Once successfully submitted, your request is assigned a unique request ID which you can check for status.

You can see some video tutorials on how to use the service at our blog!

  • To submit an export request:
    • Note: the BACPAC will be saved to your Windows Azure storage account
    • DacIESvcCli.exe -s serverName.database.windows.net -d AdventureWorkse -u MyAdminLogin -p MyPassword -bloburl http://blobAccountName.blob.core.windows.net/blobContainerName/bacpacFilename.bacpac -blobaccesskey MyKey -accesskeytype storage -x

 

  • To submit a selective export request:
    • Note: the BACPAC will be saved to your Windows Azure storage account
    • DacIESvcCli.exe -sx serverName.database.windows.net -d AdventureWorkse -u MyAdminLogin -p MyPassword -bloburl http://blobAccountName.blob.core.windows.net/blobContainerName/bacpacFilename.bacpac -blobaccesskey MyKey -accesskeytype storage -x -sxf c:\local_file_path

 

  • To submit an import request:
    • Note: the BACPAC must already be in your Windows Azure storage account prior to submitting an import request
    • DacIESvcCli.exe -s server.database.windows.net -d AdventureWorkse -edition Web -size 1 -u MyAdminLogin -p MyPassword -bloburl http://blobAccountName.blob.core.windows.net/blobContainerName/bacpacFilename.bacpac -blobaccesskey MyKey -accesskeytype storage -i

 

  • To check the status of all requests for a server:
    • DacIESvcCli.exe -s server.database.windows.net -u MyAdminLogin -p MyPassword -status

 

  • To check the status of a specific request:
    • DacIESvcCli.exe -s server.database.windows.net -u MyAdminLogin -p MyPassword -requestid myRequestID -status


Note: if you are experiencing issues with request submission, we recommend you put quotes around BLOB URI and key values

The EXE provided as a part of this CodePlex release serves as a reference implementation for how to submit requests to the Import/Export service.

Download the EXE here.

Backups

The export process is not intrinsically transactionally consistent. In order to make your export consistent, we recommend you copy the database first and then export from the copy.

Catch a video walkthrough of the tool at our blog!

Other Backup Notes

  • Passwords are not stored in the BACPAC therefore you'll need to set the passwords on relevant logins upon import to a new server
  • SQL variant data types are not yet supported, support will be added in a future release of the Import/Export Service
  • You can import (restore) BACPACs created by the service by using the client side tools also available in this project



For additional information please visit our blog and for help feel free to visit our forums here.

Last edited Nov 12, 2012 at 10:41 PM by Shamitha_Reddy, version 23

Comments

No comments yet.