copy an Azure SQL DB to another Azure SQL DBV

Michael Stoler 290 Reputation points


I have two Azure SQL Databases, Dev & Prod.

I now need to do the following:

  1. Backup the Dev Database. I am new to azure but how can I backup the Azure Database and download the backup so I have a copy. How can I restore if necessary?
  2. Completely transfer the entire schema from Prod to Dev. I don't need the data just the tables, views, stored procedures. Basically everything but the data.

Thank You,


Azure SQL Database
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,063 questions
0 comments No comments
{count} votes

Accepted answer
  1. Rahul Randive 9,176 Reputation points Microsoft Employee

    Hi @Michael Stoler

    Here is a way to backup the Azure Database and restore using .bacpac restore / export-import method

    You can also use export import method

    Step 1: Export the source database in .bacpac format and store it into the storage account or local storage
    Step 2 : Import the bacpac into destination server

    Here are the reference document
    Export -

    Thank you!

    0 comments No comments

0 additional answers

Sort by: Most helpful