Stack Overflow
Stack Overflow

Questions tagged [bacpac]

BACPACs are archives containing the schema and data of Data-tier Applications. BACPACs can be used to backup/restore databases in SQL Server and Microsoft Azure SQL Databases.

BACPACs are archives containing the schema and data of Data-tier Applications. BACPACs can be used to backup/restore databases in SQL Server and Microsoft Azure SQL Databases.

136 questions
133
votes
6 answers

Azure SQL Database Bacpac Local Restore

I've created a BACPAC backup of my Azure SQL Database using the "Export" option within the Azure Management Console. Having downloaded this to my machine I'm a little stuck on how I can restore this to a local SQL Server instance. I came across the…
Ben Foster
  • 34,340
  • 40
  • 176
  • 285
36
votes
4 answers

How to import Azure SQL backup (.bacpac) to LocalDB using Visual Studio?

I imagine this would be quite a mainstream scenario but I can't find how to import an exported Azure SQL database (.bacpac) into my LocalDB in Visual Studio 2013. Am I missing something or Visual Studio missing something? (Note: there are solutions…
Borek Bernard
  • 50,745
  • 59
  • 165
  • 240
24
votes
3 answers

Can't Export Data-tier Application for Azure

I am trying to create a .bacpac file of my SQL 2012 database. In SSMS 2012 I right click my database, go to Tasks, and select Export Data-tier Application. Then I click Next, and it gives me this error: Error SQL71564: Element Login: [myusername]…
user1477388
  • 20,790
  • 32
  • 144
  • 264
22
votes
3 answers

SQL Azure V12 BACPAC import error: "The internal target platform type SqlAzureV12DatabaseSchemaProvider does not support schema file version '3.3'"

Until a very few days ago I was able to import a V12 BACPAC from Azure to my local server with SQL Server 2014 SP1 CU6 (12.0.4449.0). But now, when I try to import the BACPAC, my SQL Server Management Studio 2014 says: "Internal Error. The…
Stefano
  • 273
  • 1
  • 2
  • 8
21
votes
7 answers

Error Importing Azure bacpac file to local db error incorrect syntax near EXTERNAL

When importing db fro azure bacpac file to local sql server 2016 I'm geting the following error. Error SQL72014: .Net SqlClient Data Provider: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'EXTERNAL'. Error SQL72045: Script execution…
Zenon Iwanicki
  • 411
  • 2
  • 4
  • 8
21
votes
1 answer

converting SQL . BAK to SQL backpac format

I have MSSQL .BAK file, and for logistical reason (the DB being huge for my infra) I want to convert the same to BacPac file, so that I could upload the same to Azure. All this while I thought .BAK and BacPac are same, so there was error, is there a…
user1504387
  • 261
  • 1
  • 3
  • 4
18
votes
1 answer

Unable to restore bacpac due to foreign key conflict

I'm attempting to restore a backup (.bacpac) of a SQL Azure database to another SQL Azure database but am unable to do so because of the following error: Error encountered during the service operation. Could not import package. Error SQL72014:…
Fishcake
  • 10,496
  • 7
  • 44
  • 72
13
votes
2 answers

Azure SQL Server BACPAC import failed

whenever i try to import BACPAC on local sql server I am getting below error message: TITLE: Microsoft SQL Server Management Studio ------------------------------ Could not import package. Warning SQL0: The source contains users that rely on an…
Deepak Kumar
  • 615
  • 1
  • 5
  • 20
13
votes
4 answers

Import bacpac fails with "does not contain QueryStoreStaleQueryThreshold"

I am getting the error below when trying to import bacpac file from Azure sql database with management studio 2014. I have upgraded the Azure sql database to v12 and suspect it has something to do with this, but it works with some v12 databases and…
Jonas Røineslien
  • 705
  • 8
  • 18
11
votes
3 answers

SQL Server bacpac fails on local import in latest update (Online index operations can only be performed in Enterprise edition of SQL Server)

I have an SQL Azure database and connect to it in SQL Server Management Studio. I do Export Data Tier Application and then Import Data Tier Application for the .bacpac file to get it into my localdb. Or I use Tasks - Deploy Database. Either way, it…
Vince
  • 583
  • 5
  • 20
9
votes
2 answers

Bacpac export errors

I'm trying to export sitecore database to bacpac so that it can be restored to SQL Azure. However, I'm getting error below: One or more unsupported elements were found in the schema used as part of a data package. Error SQL71564: The element…
Nil Pun
  • 17,035
  • 39
  • 172
  • 294
8
votes
2 answers

Why would a .bacpac file take several hours to import?

I'm developing an Umbraco 8 site and in the very early stages so an extremely small database set up on SQL Server 2017 Express. I've got to the point where I'd like to transfer this to a server so that I can show other people. I've exported a…
0Neji
  • 1,038
  • 1
  • 14
  • 36
8
votes
1 answer

Restoring database from Azure BACPAC gives an error

I'm trying to restore database created as the BACPAC on Azure. I have exported the Azure database to Azure Storage Downloaded the BACPAC file to local computer. I have used build in functionality of SQL Server Management Studio, which is "Import…
gringo_dave
  • 1,372
  • 17
  • 24
8
votes
3 answers

Count not load schema model from package. (Microsoft.SqlServer.Dac)

> ADDITIONAL INFORMATION: Internal Error. The database platform service with type Microsoft.Data.Tools.Schema.Sql.SqlAzureV12DatabaseSchemaProvider is not valid. You must make sure the service is loaded, or you must provide the full type name…
Jaimin Soni
  • 1,061
  • 1
  • 13
  • 29
8
votes
2 answers

sqlpackage.exe: any way to ignore users on export?

I'm trying to create a bacpac file to export my databases to azure. Is there anyway of making it ignore the users, while creating an export package (sqlpackage /a:Export) ?
Luis Abreu
  • 4,008
  • 9
  • 34
  • 63
1
2 3
…
8 9