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
8
votes
2 answers

Export SqlDatabase to Bacpac using SqlPackage.exe fails on fillfactor

I am using the following command to execute sqlpackage to export a bacpac for a local db. "C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin\sqlpackage.exe" /action:Export /tf:".\dbname_Baseline.bacpac"…
peter pan
  • 281
  • 4
  • 14
7
votes
3 answers

Export Data-tier application error

I am trying to export a rather simple database using the Export Data-tier application and keep getting the following error: One or more unsupported elements were found in the schema used as part of a data package. Error SQL71564: The element…
physics90
  • 946
  • 3
  • 9
  • 24
7
votes
5 answers

Error while importing bacpak in Sql Server 2012

I'm getting this error while importing bacpac file from windows azure TITLE: Microsoft SQL Server Management Studio ------------------------------ Count not load schema model from package.…
Nik
  • 441
  • 1
  • 4
  • 18
7
votes
6 answers

Sql Server change fill factor value for all indexes by tsql

I have to expoet my DB into a bacpac file to import it into Azure. When I try to export I get an error because any indexes have a fillFactor value. I've found how to set a fillFactor value for all indexes but I can't specify 0, the value have to be…
danielUrrero
  • 71
  • 1
  • 1
  • 2
6
votes
0 answers

How to solve error "Can not perform requested operation on nested resource. Parent resource not found" az sql db import throws

As part of my Azure Devops release pipeline I want to restore the bacpac of the previous days data from Azure storage. I am running the following az command az sql db import -s myprod.database.windows.net -n mydb -g myresourcegroup -p…
Declan McNulty
  • 3,194
  • 6
  • 35
  • 54
6
votes
4 answers

SQL Azure export stuck at pending

I logged in to the Azure Portal and tried to export an SQL Azure database. It failed numerous times before I identified an issue with the password I was using. Then I used the correct password and got a message that there's already a request for…
Uri
  • 61
  • 1
  • 2
6
votes
2 answers

Latest recommendations for Import\Export of SQl Server bacpac files

I'm trying to get up and running with Windows Azure but finding the database side extremely frustrating. I need to export my local database to a bacpac file from SQL 2008 and then import into Azure. I would also like to be able to export from Azure…
user1194439
  • 133
  • 1
  • 1
  • 10
5
votes
3 answers

how to deal with "remapping can only be done for users that were mapped to Windows or SQL logins"

The scenario: Trying to restore from a bacpac taken from SQL Azure. Either to a new SQL Azure database instance, or an on premises server. For the earlier with the Management portal or the DAC Framework Client Side Tools. It seems to work fine, and…
eglasius
  • 35,831
  • 5
  • 65
  • 110
5
votes
1 answer

Can I create a dacpac including data in SQL Server 2008?

Can I create a DACPAC including data in SQL Server 2008? My requirement is to generate the incremental script of the DB changes, would I be able to do that using BACPAC? I tried reading this, but this is not much…
Saranya
  • 1,988
  • 16
  • 20
5
votes
1 answer

How can I do an automated export of a Azure SQL Database in the new portal?

I am using the new Azure Portal and have selected the Azure SQL Database. With the old portal I was able to set up an automated daily export of the database but with the new one I absolutely cannot find out how to do this. It really seems like it…
user1679941
5
votes
0 answers

Can't Restore Azure SQL V12 bacpac to a local SQL 2014 server

Since we upgraded some of our Azure SQL servers to V12, we can no longer restore a bacpac locally using command line sqlpackage.exe. We also tried using Management Studio, but no dice. Our local developer machines are running: Microsoft SQL Server…
Dave
  • 629
  • 6
  • 11
4
votes
1 answer

Export Azure .bacpac to MySql .sql

Is there a solution to retrieve a base Azure, and import it into MySQL? I have recover a .bacpac but I can't find a possibility to convert .sql Thanks!
Toss Net
  • 420
  • 5
  • 13
4
votes
1 answer

Can I import BACPAC with data into DB project?

I have a database with data that I want to turn into a Visual Studio 2012 SQL Database project. I tried using "Import->Data-tier application (*.dacpac)..." - I get no errors but no data gets imported (and there is no option to include data). How can…
THX-1138
  • 21,316
  • 26
  • 96
  • 160
4
votes
1 answer

Copy SQL Server 2012 database to SQL Azure via BACPAC (for Continuous Integration)

I'm creating a continuous integration MSBuild script which copies a database in on-premise SQL Server 2012 to SQL Azure. Easy right? Methods After a fair bit of research I've come across the following methods: Use PowerShell to access the DAC…
Nick Evans
  • 3,279
  • 2
  • 25
  • 21
3
votes
1 answer

how to check a SQL Azure bacpac is not corrupt

I just lost hours to a corrupt SQL Azure bacpac backup. None of the restore mechanisms I used reported anything wrong when restoring the backup, and schema and data seemed to be there, but given there most definitely was something wrong with that…
eglasius
  • 35,831
  • 5
  • 65
  • 110
1
2
3
…
8 9