Click OK to start the export.ĭepending on the database size this could take some time, so in order to monitor the progress go back to the Azure SQL Server and select “Import/Export history”.Īs mentioned under The How there are multiple methods to copy a database so if you’re familiar with azcopy you could for example use that toĬopy (Click for documentation) the bacpac file to the other subscription’s container. Enter the credentials from the source Azure SQL Server. In the menu that shows up set the name for the to be created bacpac file and set the storage account container. While logged in to the source subscription via the Azure Portal go to the required Azure SQL Database. Via a SQL query (Cross-Subscription, “Internal”)įor this method we’ll assume you want to copy a database between subscriptions in two different tenants.Via the Azure portal (Cross-Subscription, Cross-Tenant, “Internal”).The target Azure SQL Server is named azfsql02. For all methods mentioned we’ll use a source Azure SQL Server named azfsql01 with a Azure SQL Database named azfsdb01.
![azure data studio export database azure data studio export database](https://www.sqlservercentral.com/wp-content/uploads/legacy/2c9c083dff320dbfdbc6d9fc97c1f7bbd925d5f5/36774.png)
Multiple methods are available to copy data from one Azure SQL Database to another. Copying can be done under the same subscription or between different tenants / subscriptions, depending on One of those use cases is when you’re running both a production and test environment and you want to use the production data for testing purposes.
AZURE DATA STUDIO EXPORT DATABASE HOW TO
There are many use cases for having to copy an Azure SQL Database from one Azure SQL Server to another but how to achieve this? The why