Questions tagged [bacpac]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
30 views

Is the BACPAC from a TDE encrypted DB also encrypted?

If you create a BACPAC of an encrypted database, will the data in the BACPAC be encrypted? We're currently using on-prem SQL Server and use TDE to encrypt our customer databases. We also have a ...
0
votes
0answers
27 views

How to migrate SQL2014 to Azure SQL in short time (scripting)? [duplicate]

Context: The new application is ready to be used (Azure SQL). The old application is still used (MS SQL 2014). The switch from the old to the new is to be done during one night. The size of data is ...
1
vote
1answer
223 views

What is the best way to include a large amount of configuration data in a SQL project?

I have a BIDS SQL Server Database Project with a database that I publish dynamically to various servers (SQL2016). It initially starts blank and everything is parameterized. Everything is in Azure ...
2
votes
1answer
155 views

Importing a single large table in Azure

I have an existing DB called MyDb in Azure SQL Server. I have a bacpac of another DB with several tables in it. I'm interested in importing one single table (that table has no FK, it makes things ...
2
votes
1answer
317 views

MS Azure remote back up with SqlPackage

I wanted to do an export of a .bacpac file from MS Azure database, from local machine, with command like this: sqlpackage.exe /Action:Export /ssn:tcp:<ServerName>.database.windows.net,1433 /sdn:...
1
vote
0answers
354 views

Import bacpac containing security policies and temporal-tables with schemabinding

I've created a bacpac backup of my database (both Azure and local with SSMS). Trying to import the bacpac to same or another machine (again both Azure and local) the import always fails with this ...
2
votes
1answer
1k views

Importing BACPAC file from azure to SQL creating an empty database

Exported Data-Tier_application from an Azure database to create a BACPAC of it. SQL editions I'm trying to use to import the BACPAC: SQL Server 2016 express. SQL Server 2017 Developer ...
2
votes
0answers
202 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 ...
6
votes
2answers
9k 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
306 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 ...
4
votes
1answer
235 views

SQL Server on linux unable to export to bacpac [closed]

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: /...
2
votes
2answers
3k 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
2k 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. The ...