Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [bacpac]

18 questions
8
votes
1 answer

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 users are preventing the normal import to…
Peter PitLock
  • 1,405
  • 4
  • 24
  • 32
7
votes
3 answers

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 trying to restore that file on my local machine using…
Ketan
  • 497
  • 3
  • 6
  • 14
5
votes
1 answer

What are the .BCP files inside a .bacpak file?

Diving on dba.stackexchange.com I found a nice answer that teach me how to open a .bacpac file with File Explorer. I gave it a try with the database AdventureWorks2008R2 and all I did was: Save the database as .bacpac file Rename the file extension…
Francesco Mantovani
  • 1,695
  • 14
  • 28
4
votes
1 answer

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:.database.windows.net,1433 /sdn: /su: /sp:…
userfuser
  • 147
  • 5
4
votes
1 answer

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: /opt/mssql/bin/sqlpackage /action:Export…
Jake Smith
  • 141
  • 3
3
votes
0 answers

Find SQL version of Azure server

I have been restoring bacpacs provided by a third party on my on prem sql server via powershell. I copy over the bacpac from an SFTP site on to my local drive. This time I have been getting errors which lead me to believe that the bacpac has been…
mail_sady
  • 51
  • 3
3
votes
2 answers

Free some space on a full Express Edition instance

Using Microsoft SQL Server 2016 (RTM) - 13.0.1601.5 (X64) Express Edition (64-bit) I have a database that reaches the maximum space (10Gb) every month. In order to free up some space I do a bacpac, create a new database with the bacpac and shrink it…
Pedro Adão
  • 33
  • 4
2
votes
1 answer

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 easier) into a dedicated table…
Askolein
  • 131
  • 3
2
votes
1 answer

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 Edition. I droped some views and procedures to fix error and…
Racer SQL
  • 7,546
  • 16
  • 77
  • 140
2
votes
0 answers

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 a specific version to warn the user if they are…
Doc Rinehart
  • 21
  • 3
2
votes
2 answers

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.
JS_Diver
  • 165
  • 2
  • 6
1
vote
1 answer

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 DevOps and deploys to places. I want to include/pack…
Alex K
  • 175
  • 2
  • 2
  • 10
1
vote
0 answers

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 error: Error SQL72014: .Net SqlClient Data Provider:…
AKL
  • 11
  • 1
0
votes
1 answer

SQL72014 error importing bacpac with multiple columns using a UDT bound to a rule

Apology First off, apologies for length - this is a weird issue so I'm trying to give enough detail to make it reproducible. tl;dr So I've think found an issue while exporting a *.bacpac Data Tier Application between two MS SQL Servers to migrate…
mclayton
  • 143
  • 1
  • 5
0
votes
1 answer

Change the schema of table while restoring the database from bacpac file?

I have a bacpac file which I generated from SQL Server. And now, I am restoring the database using this bacpac file into the Azure Managed Instance. Here, I am trying to change the schema of the table according to the requirement. The question is,…
Robin
  • 1
1
2