copy an Azure SQL DB to another Azure SQL DBV

Question

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

Answer 1

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!