copy an Azure SQL DB to another Azure SQL DBV

Michael Stoler 290 Reputation points
2023-11-30T15:27:10.46+00:00

Hello,

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,

Michael

Azure SQL Database
Azure
Azure
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
    2023-11-30T15:32:15.4366667+00:00

    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 - https://learn.microsoft.com/en-us/azure/azure-sql/database/database-export
    Import- https://learn.microsoft.com/en-us/azure/azure-sql/database/database-import?tabs=azure-powershell
    Blog: https://www.mssqltips.com/sqlservertip/5189/restore-an-azure-sql-database-from-one-server-to-another-server/

    Thank you!

    0 comments No comments

0 additional answers

Sort by: Most helpful