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
1
vote
2 answers

open DataReader associated with this Command

I'm 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. (System.Data) I am trying this from a fresh reboot…
user566095
  • 31
  • 6
1
vote
1 answer

Error validating elements stops migration or bacpac backup

I am having a problem migrating a SQL 2017 database to Azure. I have used the 'Deploy Database to Microsoft Azure SQL Database' and 'Export Data-tier Application' wizards from the tasks menu in SSMS and get the same result. I am trying migrate 4…
Eddie
  • 11
  • 3
1
vote
3 answers

BACPAC from SQL Azure Error when import it

I tried to import my db from SQL Azure, but I am getting the next error in SQL Server Management Studio from each version that I specified: SQL Server Management Studio v17.9.1: Could not load schema model from package.…
Carlos Bolivar
  • 11
  • 1
  • 2
1
vote
1 answer

Data Tier Export to BacPac Fail

I need to export an entire SQL Server database - schema, tables, data etc and trying to use the following method. Login to SSMS with admin credentials, locate relevant database, right click on database, select Tasks >> Export Data-tier Application. …
AJF
  • 1,801
  • 4
  • 27
  • 54
1
vote
1 answer

Azure SQL Server - How cost will be calculated

I have created SQL Server resource in SQL Server and then using import database option, I created database using local bacpac file. I was able to perform this action and my database was created in SQL Server. I looked at Azure SQL pricing but not…
Manish Joisar
  • 1,256
  • 3
  • 23
  • 47
1
vote
2 answers

Azure SQL DB Refresh From Production

Looking for the best practice on refreshing a QA/Test Azure SQL Database from a Production Azure SQL Database The production database is on a different server and resource group. So just wondering the best method for getting the production data into…
77Vetter
  • 209
  • 3
  • 16
1
vote
1 answer

How to export (bacpac) azure database

I have one database in azure and accessing in my SQL Server Management studio and try to export the database but gives me the errors. Here are the steps I have done: 1) Export data-tier Application 2) No of errors I got 3) Got this error in all…
Mahavirsinh Padhiyar
  • 1,299
  • 11
  • 33
1
vote
1 answer

Can I delete a DB from azure while is being restored from a BACPAC file?

I have a BACPAC file that is being restored into a new database. Later, I realized that I don't need the DB anymore. The problem is that it has not finished to restored yet. The question is that I can delete the DB while is restoring and be sure…
Diego Arturo
  • 171
  • 1
  • 3
  • 15
1
vote
1 answer

Is there a way to programmatically backup and restore Azure database with a bacpac or similar?

So I am migrating a database from a local SQL Server 2014 to an Azure database. I migrated successfully using a bacpac and the connections are working fine. However I still want to perform backups and of course the old school file backup does not…
djangojazz
  • 14,131
  • 10
  • 56
  • 94
1
vote
2 answers

Azure SQL Database download .bacpac

I want to export my current database backups from Azure to my local on-premise environment. I have created a .bacpac file from the Azure SQL Database and stored this within my Azure Blob Storage. However, whenever I download my backup it is always…
Jack Jones
  • 55
  • 4
1
vote
2 answers

importing SQL Server .bacpac file

I've been trying (and failing) to import a SQL .bacpac file to SQL 2014 Express. Does anyone know if it's even possible to import these to Express? I haven't found anything online saying otherwise, but thinking of just getting the developer edition…
DarkW1nter
  • 2,933
  • 11
  • 67
  • 120
1
vote
1 answer

How to import bacpac to Dataset

I have a bacpac file and I need to import bacpac to a dataset type variable. I have checked QL Azure BACPAC extraction, however I do not know how to use ImportBacpac command from DacServices: SqlConnectionStringBuilder csb = new…
hunterex
  • 565
  • 11
  • 27
1
vote
1 answer

Cannot export a BACPAC from SQL Azure -- ExtAuth_Key10 is not supported in Microsoft Azure SQL Database v12

I'm getting an error with exporting the database that's housed in SQL Azure. The database itself is already v12. When I try to export the database, I get this error: The element ExtAuth_Key10 is not supported in Microsoft Azure SQL Database v12.…
this
  • 1,406
  • 11
  • 23
1
vote
1 answer

Errors while Importing from BACPAC in Azure SQL DB

I have a .bacpac file exported from SQL Server 2008. While I'm trying to import the same in my Azure SQL Server using latest SSMS, I'm thrown the below error at a specific Table. =================================== Data plan execution failed with…
Suhail
  • 11
  • 2
1
vote
1 answer

Import large database from bacpac with SQL Server Management Studio

I'm trying to import a large database to a Microsoft SQL Server 2016 (v13.0.2164.0) from a bacpac export with Microsoft SQL Server 2016 Management Studio. To import I right click Databases, select Tasks and Import Data-tier Application. The…
John Coder
  • 95
  • 1
  • 4
1 2 3
…
8 9