Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [bacpac]

The tag has no usage guidance.

0
votes
0answers
57 views

SSMS Error importing BACPAC

Im using Database > Import Data-tier Application to pull in my .BACPAC file and am getting this error: There is already an open DataReader associated with this Command which must be closed first. (...
2
votes
0answers
84 views

Is there a way to programmatically get the version of a .bacpac file without unzipping and inspecting the xml?

The situation is that we get a copy of the latest production bacpac, then restore it locally when setting up our dev environment. During the setup, we do an explicit check for the DacFX dll but target ...
3
votes
2answers
5k views

Bacpac Import fails with error 'The Element or Annotation class SqlDatabaseOptions does not contain the Property class CatalogCollation'

I want to restore some production azure database on my local machine for development purposes. So I exported the production database to a .bacpack file & downloaded that file on local. Now I am ...
0
votes
0answers
158 views

Error 10054 encountered exporting localhost SQL Server to .bacpac

I am trying to export a localhost SQL Server database to a .bacpac file, and am encountering error 10054: "A transport-level error has occurred when receiving results from the server... An ...
2
votes
1answer
128 views

SQL Server on linux unable to export to bacpac

I'm trying to export my database to a .bacpac file. I get the following error: (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) The command I'm using is: /...
0
votes
0answers
572 views

How can a BACPAC file be created for an export from T-SQL?

Seems that SqlPackage.exe is the only way to create BACPAC export files (Export an Azure SQL database to a BACPAC file). How can a BACPAC file export be created using a T-SQL statement? Potentially ...
2
votes
2answers
2k views

Create bacpac from SQL Server 2008

Is it possible to export bacpac file from SQL SERVER 2008 (running 10.50.6220)? I can only see option for dacpac.
6
votes
0answers
833 views

SQLPackage : Import or Export SQL Azure BACPAC without users

I know how to use SQLpackage.exe. I can export from SQL Azure and create a bacpac. I can also Import to SQL Server via SQLPackage.exe. I want to export or import without the users in the database. ...