BACPAC Import/Export now available for SQL Azure



It is now possible to backup and restore your SQL Azure database using the BACPAC format, from inside the Azure Management Portal. The portal allows you to select a database and export it to a blob. Restoring is a mater of choosing which blob should restore to which database. Backups do not have transactional consistency, so it may be best to back up a copy of your live database.

You can copy a database with this command:

CREATE DATABASE destination_database_name
    AS COPY OF [source_server_name.]source_database_name