Skip to content

Commit 8db5554

Browse files
20230825 edit pass, refresh
1 parent 51af26b commit 8db5554

3 files changed

Lines changed: 105 additions & 95 deletions

File tree

azure-sql/database/database-import.md

Lines changed: 8 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -4,19 +4,19 @@ description: Create a new database in Azure SQL Database or Azure SQL Managed In
44
author: WilliamDAssafMSFT
55
ms.author: wiassaf
66
ms.reviewer: jeschult, mathoma
7-
ms.date: 08/16/2023
7+
ms.date: 08/25/2023
88
ms.service: sql-db-mi
99
ms.subservice: backup-restore
1010
ms.topic: quickstart
1111
ms.custom:
1212
- sqldbrb=1
1313
- devx-track-azurepowershell
1414
- mode-api
15-
monikerRange: "= azuresql || = azuresql-db || = azuresql-mi"
15+
monikerRange: "=azuresql||=azuresql-db||=azuresql-mi"
1616
---
1717
# Quickstart: Import a .bacpac file to a database in Azure SQL Database or Azure SQL Managed Instance
1818

19-
[!INCLUDE[appliesto-sqldb-sqlmi](../includes/appliesto-sqldb-sqlmi.md)]
19+
[!INCLUDE [appliesto-sqldb-sqlmi](../includes/appliesto-sqldb-sqlmi.md)]
2020

2121
You can import a SQL Server database into Azure SQL Database or SQL Managed Instance using a [.bacpac](/sql/relational-databases/data-tier-applications/data-tier-applications#bacpac) file. You can import the data from a .bacpac file stored in Azure Blob storage (standard storage only) or from local storage in an on-premises location. To maximize import speed by providing more and faster resources, scale your database to a higher service tier and compute size during the import process. You can then scale down after the import is successful.
2222

@@ -71,7 +71,7 @@ SqlPackage /a:import /tcs:"Data Source=<serverName>.database.windows.net;Initial
7171
> [!IMPORTANT]
7272
> To connect to Azure SQL Database from behind a corporate firewall, the firewall must have port 1433 open. To connect to SQL Managed Instance, you must have a [point-to-site connection](../managed-instance/point-to-site-p2s-configure.md) or an express route connection.
7373
74-
This example shows how to import a database using SqlPackage with Active Directory Universal Authentication.
74+
As an alternative to username and password, you can use Microsoft Entra ID (formerly Azure Active Directory) with multi-factor authentication. Substitute the username and password parameters for `/ua:true` and `/tid:"yourdomain.onmicrosoft.com"`. This example shows how to import a database using SqlPackage with Microsoft Entra multi-factor authentication:
7575

7676
```cmd
7777
SqlPackage /a:Import /sf:testExport.bacpac /tdn:NewDacFX /tsn:apptestserver.database.windows.net /ua:True /tid:"apptest.onmicrosoft.com"
@@ -138,8 +138,6 @@ az sql db import --resource-group "<resourceGroup>" --server "<server>" --name "
138138
-u "<userId>" -p "<password>"
139139
```
140140

141-
* * *
142-
143141
> [!TIP]
144142
> For another script example, see [Import a database from a BACPAC file](scripts/import-from-bacpac-powershell.md).
145143
@@ -154,7 +152,7 @@ Stop-AzSqlDatabaseActivity -ResourceGroupName $ResourceGroupName -ServerName $Se
154152

155153
### Permissions required to cancel import
156154

157-
To cancel import operation you will need to have one of the following roles:
155+
To cancel the import operation, you need to be a member of one of the following roles:
158156

159157
- The [SQL DB Contributor](/azure/role-based-access-control/built-in-roles#sql-db-contributor) role or
160158
- A [custom Azure RBAC role](/azure/role-based-access-control/custom-roles) with `Microsoft.Sql/servers/databases/operations` permission
@@ -168,9 +166,9 @@ To cancel import operation you will need to have one of the following roles:
168166

169167
- Importing to a database in elastic pool isn't supported. You can import data into a single database and then move the database to an elastic pool.
170168
- Import Export Service does not work when Allow access to Azure services is set to OFF. However you can work around the problem by manually running SqlPackage from an Azure VM or performing the export directly in your code by using the DacFx API.
171-
- Import does not support specifying a backup storage redundancy while creating a new database and creates with the default geo-redundant backup storage redundancy. To workaround, first create an empty database with desired backup storage redundancy using Azure portal or PowerShell and then import the .bacpac into this empty database.
169+
- Import does not support specifying a backup storage redundancy while creating a new database and creates with the default geo-redundant backup storage redundancy. To work around, first create an empty database with desired backup storage redundancy using Azure portal or PowerShell and then import the .bacpac into this empty database.
172170
- Storage behind a firewall is currently not supported.
173-
- During the import process, do not create a database with the same name. The import process creates a new database of the specified name.
171+
- During the import process, do not create a database with the same name. The import process creates a new database of the specified name.
174172

175173
## Additional tools
176174

@@ -185,4 +183,4 @@ You can also use these wizards.
185183
- To learn how to connect to and query a database in Azure SQL Database, see [Quickstart: Azure SQL Database: Use SQL Server Management Studio to connect to and query data](connect-query-ssms.md).
186184
- For a SQL Server Customer Advisory Team blog about migrating using .bacpac files, see [Migrating from SQL Server to Azure SQL Database using BACPAC Files](https://techcommunity.microsoft.com/t5/DataCAT/Migrating-from-SQL-Server-to-Azure-SQL-Database-using-Bacpac/ba-p/305407).
187185
- For a discussion of the entire SQL Server database migration process, including performance recommendations, see [SQL Server database migration to Azure SQL Database](migrate-to-database-from-sql-server.md).
188-
- To learn how to manage and share storage keys and shared access signatures securely, see [Azure Storage Security Guide](/azure/storage/blobs/security-recommendations).
186+
- To learn how to manage and share storage keys and shared access signatures securely, see [Azure Storage Security Guide](/azure/storage/blobs/security-recommendations).

0 commit comments

Comments
 (0)