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
0
votes
1 answer

Azure BACPAC restore fails randomly from Azure Devops

I'm trying to import a bacpac in an Azure DevOps build via the Azure SQL Database Deployment plugin. The problem that it fails randomly(about 50% of the time it succeeds) with the following error: *** Error importing database:Could not import…
Joey
  • 152
  • 3
  • 14
0
votes
1 answer

I lost my Azure SQL database, but I have .bacpac file. Can I somehow open it?

So I was using Microsoft Azure trial version and I made SQL server and database. I made a backup and got .bacpac file exported. I've just logged in and saw that I lost my database because my free trial expired. Can I somehow still open database…
Natasa Andzic
  • 18
  • 5
0
votes
1 answer

Error when exporting bacpac file from local database

I am trying to deploy a local database to an azure sql databse. When i use the tool in Management Studio (Tasks > Deploy Database to Microsoft Azure SQL Database) I get an error when the process starts to export the database. I get the same error…
Keith
  • 718
  • 8
  • 12
0
votes
1 answer

Azure function - Import bacpac file from blob storage in Azure sql server - AAD token

We want to import bacpac file from Blob storage into Azure SQL server thru Azure Functions which is Blob trigger function. We have implemented it as follows log.Info($"C# Blob trigger function Processed blob\n Name:{name} \n Size:…
Manish Joisar
  • 1,256
  • 3
  • 23
  • 47
0
votes
1 answer

SQL Server BACPAC Import fails with IDENTITY_INSERT error

I'm importing a bacpac from Azure to a local SQL DB. The process goes for a while and on about the 50th table it fails with this error: IDENTITY_INSERT is already on for table 'X'. Cannot perform set operation for table 'Y' Table 'X' was…
aircan
  • 1
0
votes
1 answer

Is there a simple way to copy a SQL Azure Database locally on SQL Server 2014?

I have created a bacpac file through the Export option of Azure. Then, I tried to import the bacpac file into SQL Server installed locally on my pc, selecting in SQL Server Management Studio, the “Import Data-tier Application…” feature. The import…
Enrico
  • 1
0
votes
1 answer

Restore BacPac database backup in sql server 2014

I have database backup file with extension .bacpac so how can i restore it in sql server 2014 ?
Sumit Singh
  • 59
  • 1
  • 9
0
votes
1 answer

After upgrade to 2016 can't import Azure V12 bacpac

We've recently upgraded our development server from 2014 to 2016. We had already been using some 2016/Azure V12 functionalities on production in certain views. Now that we want to restore a recently exported bacpac file from our production database…
Feanaro
  • 922
  • 3
  • 19
  • 35
0
votes
4 answers

Prevent SqlPackage from writing to primary partition during Export

To move a 144GB SQL Server database to Azure SQL I want to export it to the .bacpac format. To do so I use SQL Package of SQL Version 130: C:\Program Files (x86)\Microsoft SQL Server\130\DAC\bin>SqlPackage.exe /Action:Export /ssn:MY_MSSQL_INSTANCE…
Gabriël
  • 1,323
  • 2
  • 22
  • 34
0
votes
2 answers

Export Bacpac from 2008 R2 fails on Azure validation rules

I'm exploring the SSDT .NET class offering in Microsoft.SqlServer.Dac.dll using Powershell, and I'm trying to work a database into a source-control-based SDLC as a proof of concept. The first thing I tried was to export a bacpac so that we could…
bwerks
  • 8,651
  • 14
  • 68
  • 100
0
votes
1 answer

Error Trying to Create Database from bacpac

I am trying to create a new database on Azure via a bacpac file created by SQL Mgmt Studio. The bacpac has been saved to a BLOB storage. The process goes through all the way to the end however, the create fails with the following message BadRequest…
physics90
  • 946
  • 3
  • 9
  • 24
0
votes
2 answers

How to copy tables from a database into another database in SQL Azure?

We made two backups from a database that needed changes in many tables, one is an exact copy of that database and the other is a BACPAC file. The new model for the database is ready but I was wondering, how can I copy the contents of the tables we…
Uriel Arvizu
  • 1,876
  • 6
  • 37
  • 97
0
votes
1 answer

Azure Database Backup lost Comment

I am using the DAC framework's Import Export Service Client tool to export a BACPAC file from a SQL Database on Azure. But when I restore the BACPAC file to the Azure Database, it loses the comment of a Store Procedure or a View, which was initially…
CKyaw
  • 63
  • 1
  • 9
-1
votes
1 answer

Which tool can I use to encrypt bacpac file using azure key vault

I exported my azure SQL Managed instance to a Bacpac file using SQLPackage, Now I want to store it on a azure file storage. Before I want to copy the bacpac to the file storage, I want to encrypt it using a Secret from Azure key vault. SQLPackage…
Jente
  • 1
-1
votes
1 answer

Azure SQL Database Bacpac Local Restore does not work anymore

I have a SQL azure instance with: SQL2014 RTM SQL Azure 12.0.2000.8 and i'm using SSMS to export to a local bacpac file. next, i'm trying to import this into a local SQL server instance (SQL2014 SP1 Developer Edition (64-bit) 12.0.4232.0). This used…
Thomas Woelfer
  • 533
  • 5
  • 21
1 2 3
…
8
9