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
1 answer

Automated bacpac export in azure

I use Azure db(v12 server version). My needs: I need db in my local environment for development and testing purposes, and it need to be up to date; I know that if i delete db server(assumption) i wont be able to restore my db. I know that i can…
Volodymyr Gorodytskyi
  • 482
  • 4
  • 18
1
vote
2 answers

Azure Import Error: The internal target platform type SqlAzureV12DatabaseSchemaProvider does not support schema file version '3.1'

For some reasons I cannot import new BACPACs from Azure. I still can import old ones. This is the error message I get: Internal Error. The internal target platform type SqlAzureV12DatabaseSchemaProvider does not support schema file version…
yaculai
  • 51
  • 8
1
vote
0 answers

Powershell DB backup script pass only when executing from ISE

I've been using following backup script for a while to create .bacpac files for MSSQL databases. The script working ok in general but fails for some databases. Those databases are not too much different to others, maybe a bit bigger. As this is used…
Mikhail Chibel
  • 1,865
  • 1
  • 22
  • 34
1
vote
1 answer

Azure preview portal wont let me import a database from bacpack

I'm trying to import a database from a bacpack. Done this many times before without issue, but now it won't work and doesn't give any indication of the problem, just mocks me with a blank messagebox.. . How can I troubleshoot this? I've made sure…
user969996
  • 55
  • 5
1
vote
1 answer

Getting DacServices error on one machine, not on another

We've got a process that includes creating a database on an SQL Server 11 and 10 database servers. We're using a dacpac to import this data in C# via DacServices. This is the code being used: var dac = new DacServices(masterConnString); using (var…
Monzie
  • 41
  • 6
1
vote
0 answers

Database creation in Azure from bacpac

While creating a database in Azure from a bacpac we receive the following error. We have tried a number of times with different containers/storage accounts BadRequest <string…
Abweb
  • 11
  • 2
1
vote
1 answer

How to import a transactionally-inconsistent bacpac

It is well-known that creating a bacpac on SQL Azure does not guarantee transactional consistency when doing an export of a live, changing database. The accepted workaround is to create a snapshot of the database first, by copying it, and then doing…
David Airapetyan
  • 5,301
  • 4
  • 40
  • 62
1
vote
1 answer

How can I configure Sql Server Management Studio to ignore certain extended properties on a view when creating a BACPAC?

When I try to generate a BACPAC from a database running on a local MSSQL database I get an error: One or more unsupported elements were found in the schema used as part of a data package. Error SQL71564: The element Extended Property:…
user310988
1
vote
0 answers

Exception calling “ImportBacPac” with “2” argument(s): “Could not import package”

I know this has been asked earlier, but I could not see any answer to this hence posting again. As part of PS(ver 4.0) importbacpac I am hitting the following error intermittently Exception calling "ImportBacPac" with "2" argument(s): "Could not…
ashish1238
  • 53
  • 6
1
vote
1 answer

converting a blob (.bacpac) to .bacpac file to import database to SQL Server Azure?

While working in MVC/ C# with Azure I need to restore database from a .bacpac file which is stored in blob storage. I m using DAC Framework API to access .bacpac from Blob storage. Issue: DacServices.ImportBacpac requires .bacpac file, I am able to…
Toubi
  • 2,469
  • 10
  • 33
  • 49
1
vote
1 answer

Internal error import BACPAC file to windows azure sql database

I am using MSSQL2014 version CTP2. Running my databases through Windows Azure SQL Database management. I've created a BACPAC file via MSSQL of my local database and want to import it to Windows Azure. I create the BACPAC file and upload it to my…
darren
  • 18,845
  • 17
  • 60
  • 79
1
vote
1 answer

Best Practice for running hourly backups on an SQL Azure Database?

I need to backup my production database each hour to the least as it contains a lot of financial information. I've looked into SQL Data Sync but considering the fast pace of schema changes we do all the time, it won't do the trick. This article:…
Uri Abramson
  • 6,005
  • 6
  • 40
  • 62
1
vote
1 answer

Can you create a SQL Azure BACPAC from a Remote C# Application

I'm working on a tool to allow backup and restore of SQL Azure databases between various local & azure environments. I have a working version where the BACPAC is created and directly streamed to my Local Developer machine. But I haven't been able…
Eoin Campbell
  • 43,500
  • 17
  • 101
  • 157
0
votes
1 answer

Can we import SQL bacpac file in existing DB (azure)

can we create a new bacpac file without creating a new DB in azure I tried creating it in the existing DB. It didn't work , a new DB is being created. I want the bacpac on the existing DB............................................
Karthik M S
  • 1
0
votes
2 answers

Error Deploying Bacpac on Azure SQL Database when the database has Azure AD Users

I'm trying to deploy a .bacpac to my Azure Subscription, the database has some Azure AD users. I can generate the .bacpac with SSMS, but when I deploy the replicated database on Azure, I'm getting this error: Could not import package. Error…
jairo buitrago
  • 15
  • 4
1 2 3
…
8 9