You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
> 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.
73
73
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:
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:
158
156
159
157
- The [SQL DB Contributor](/azure/role-based-access-control/built-in-roles#sql-db-contributor) role or
160
158
- 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:
168
166
169
167
- 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.
170
168
- 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.
172
170
- 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.
174
172
175
173
## Additional tools
176
174
@@ -185,4 +183,4 @@ You can also use these wizards.
185
183
- 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).
186
184
- 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).
187
185
- 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