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

Exporting azure database in powershell with New-AzSqlDatabaseExport does not always return the OperationStatusLink, resulting in an exception

I am writing a powershell script to export an Azure database to a bacpac file using the New-AzSqlDatabaseExport command (following the documentation here. When I run the powershell script, the results I get are inconsistent. When I open a new…
Yehuda Gutstein
  • 381
  • 10
  • 27
3
votes
0 answers

Azure SQL Database Bacpac export has missing indexes

We have a funky problem with the Azure SQL built in Export function (from the portal). If we export our DB there into a Bacpac file that is stored in a blob container, not all indexes get exported. We import them on a local SQL Server instance with…
Remy
  • 12,555
  • 14
  • 64
  • 104
3
votes
2 answers

Import BACPAC into an _existing_ database

Is there a way to import a BACPAC file into an existing (empty) database? It looks like the PowerShell commands allow me to create new target databases only... Is there a trick?
D.R.
  • 20,268
  • 21
  • 102
  • 205
3
votes
3 answers

Sql Server when importing bacpac file receive "Archive file cannot be size 0."

I'm exporting a bacpac file from my Azure SQL Server database to my local file system. Then when I try to import this bacpac file into a local instance of SQL Server I get a "Archive file cannot be size 0." error. I've tried the import via the GUI…
BrentHS
  • 241
  • 1
  • 2
  • 8
3
votes
1 answer

Possible BUG with BACPAC import and temporal tables

I' using the latest version of SQL Server 2016 Developer edition and SSMS (13.0.15600.2). There is a possible bug in importing Data tier Application (bacpac) that contain any temporal tables and any object (function. view) that references them with…
Sergey Yerdekov
  • 51
  • 3
3
votes
1 answer

SQL Server - Fails to import Data-Tier Application from SQL Azure

I'm attempting to import a database to my local SQL Server 2012 instance from SQL Azure using the "Import Data-Tier Application" wizard. I simply exported the database to blob storage, then downloaded the file and then selected to import the…
Paul
  • 3,072
  • 6
  • 37
  • 58
3
votes
2 answers

SQL Azure Export/Bacpacs and Foreign Key Integrity

I've a bit of a strange problem with a BACPAC I took last night using the SQL Azure Import/Export Service. In our database there are 2 related tables. dbo.Documents --All Documents in the database Id DocName Extension dbo.ProcessDocuments…
Eoin Campbell
  • 43,500
  • 17
  • 101
  • 157
3
votes
2 answers

Azure SQL Database Create via bacpac Import Fails

We are testing the migration from a local SQL Server 2008R2 database to Azure, but have hit a bump in the road. Process followed, based on SO articles: Installed SQL Server 2012 Client tools Amended DB to remove indexes with a fill factor…
moretolearn
  • 31
  • 1
  • 3
2
votes
1 answer

Sqlpackage throwing error without details

I am currently working on an application to easily restore a bacpac file. Unfortunately i have the following issue: Sqlpackage throws a error that it cannot import a database because it contains one or more user objects, but when i restore the…
Stefan Bosman
  • 43
  • 4
2
votes
1 answer

Error restoring database to server: .NET Core should not be using a file backed model

I was always able to restore a bacpac to a SQL Server in Azure using a local file like this: ds = new DacServices(connectionString); ds.ImportBacpac(BacPackage.Load(filePath), dbTargetName, new DacImportOptions { …
CodeMonkey
  • 11,196
  • 30
  • 112
  • 203
2
votes
1 answer

Error "The storage URI is not valid" when creating a new SQL Azure database from a bacpac

I'm trying to create a new SQL Azure database from a bacpac file I exported locally and uploaded as a BLOB to a storage account container. When I choose Import Database on the SQL server and choose to use the uploaded bacpac as the source for the…
Chris
  • 3,081
  • 3
  • 32
  • 37
2
votes
0 answers

How do I reset the sa user password inside a Dockerfile using the Windows SQL Server Express Docker image?

I am trying to build a Docker image from the Windows SQL Server Express image augmented with the SqlPackage tool and preloaded with some data to run integration tests using the following Dockerfile: FROM microsoft/mssql-server-windows-express ARG…
Mark
  • 1,312
  • 1
  • 16
  • 33
2
votes
1 answer

Available options to restore the db from Azure MI to local machine for confidential data

I have a requirement to backup the SQL database present in Azure Managed instance and restore it on local server for root cause analysis. This needs to be performed whenever we encounter a certain error on the DB. Since the automated backups are TDE…
PraveenDS
  • 51
  • 3
2
votes
1 answer

Unsupported elements in SQL bacpac export

I am trying to create a bacpac file of a SQL Server database hosted on GearHost to migrate to an elastic pool in Azure using "Export Data-tier Application" in SSMS. I have tried many solutions found on the web to no avail. The below error still…
Emile Cloete
  • 143
  • 1
  • 2
  • 10
2
votes
1 answer

Importing Database via BACPAC / DACPAC Failing On Users When Using CLI Tools (sqlpackage.exe / PS dbatools)

Goal Clone a SQL database to a different remote SQL Server using a PowerShell script What Works Using SSMS to import the BACPAC file into different servers (remotely & local) works without (reported) warnings or errors. What Doesn't Importing the…
andrewjamesbowen
  • 622
  • 8
  • 14
1 2
3
…
8 9