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

The existing passwords are not working after exporting SQL Server managed database from azure to local machine

The export of the Azure database to storage - OK. -.bacpac created successfully. The import from that .bacpac to a local SQL Server - OK; the sa user can login and use the database. The local server has been configured…
Mx.Wolf
  • 578
  • 5
  • 13
0
votes
1 answer

Sqlproj deployment to AzureSql (dacpac vs bacpac)

The Situation I have an Azure Devops build pipeline that is building and deploying to an existing AzureSql Database instance via the outputted .dacpac. I would like to have the ability to run a script or execute API calls to create new AzureSql…
CodeWarrior
  • 7,388
  • 7
  • 51
  • 78
0
votes
0 answers

MSSQL server not allow to take backup with user schema

One or more unsupported elements were found in the schema used a part of data a package, Error SQL71510: Error validating element [myuser]: Sql User:[myuser] has unresolved reference to sqlLogin [myuser]. We cannot take a backup due to this user…
Oviya
  • 1
  • 1
0
votes
1 answer

Azure SQL bacpac Fails on Special Characters in Stored Procedures

Trying to move a database from an Azure GOV tenant to a standard Azure tenant. From what I can tell, the export is failing due to special characters in the Store Procedures (slashes, dollar signs, etc.) These are properly escaped and work as…
BaronVonKumpf
  • 11
  • 2
0
votes
2 answers

gCloud SQL import bacpac file for SQL Server

I have a .bacpac file exported from an Azure SQL Server database and I want to import that into GCP Cloud SQL. As I understand, cloud SQL has the gcloud sql import bak command that allows you to do this but this only supports .bak files as opposed…
Vikram
  • 170
  • 1
  • 12
0
votes
0 answers

SQL Server bacpac export import error | Datalength gets increased

We are facing a weird error while exporting data in bacpac format from Azure SQL database and then restoring it back (using SSMS). It throws error related to Truncated value: 2628 in one of the columns with size Varchar(256), collation is…
Pragmatic
  • 3,093
  • 4
  • 33
  • 62
0
votes
1 answer

Azure Bacpac: How to compress a bacpac within SSMS

Is there a better way/quicker way to export an azure database via SSMS with it being compressed via the Export Data-tier Application? In the Advanced settings, there are only options to select the tables to be exported. When you take a .bak file,…
ttaylor27272727
  • 195
  • 3
  • 18
0
votes
1 answer

Is there a way to successfully import a bacpac that exceeds 4GB in which I need to change the Collation?

I am migrating a database from On Premises SQL to Azure. This is a process we have performed several times already, successfully. The process is normally quite simple. I export the database to a Data Tier Application, I change the extension from…
DinahMoeHumm
  • 185
  • 10
0
votes
1 answer

Error trying export SQL Azure database to BACPAC file

I daily backup around 100 databases to BACPAC file using AzureRM for Windows PowerShell. For some reason 20 of these databases started to throw an strange error: Could not export schema and data from database. One or more errors occurred. One or…
Mario Castillo Gamez
  • 3
  • 2
0
votes
1 answer

Can't export SQL Azure database when stored procedure is encrypted

I want to export my SQL Azure database to a file test.bacpac, but I failed: One or more unsupported elements were found in the schema used as part of a data package. Error SQL71564: Error validating element [dbo].[IsMyUserExisted]: The element…
Chandra Arifin
  • 43
  • 1
  • 11
0
votes
1 answer

SqlPackage import maximum db size

I want to import a database from a .bacpac file to a SQL Server in Azure. I read the document here: https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-import?view=sql-server-ver15 It says that there is a flag called…
CodeMonkey
  • 11,196
  • 30
  • 112
  • 203
0
votes
2 answers

Difference between loading a file from a path and from a stream C#

This is a follow up question to this question: Difference between file path and file stream? I didn't fully understand everything answered in the linked question. I am using the Microsoft.SqlServer.Dac.BacPackage which contains a Load method with 2…
CodeMonkey
  • 11,196
  • 30
  • 112
  • 203
0
votes
1 answer

Import bacpac in SQL Server instance using VB.Net

I have tried to search online code in VB.net for importing/restoring bacpac on my local SQL server instance but unable to find out. Can anyone help me with this problem?
Abhishek Avadhoot
  • 1
  • 5
0
votes
1 answer

BACPAC backups seem to be stuck

I'm trying to export my databases and they seem to be "stuck". I tried to create the first backup but when I went download it, I noticed the file size was 0MB. So I went and tried again and got the error below: Database export error Failed to…
lamarant
  • 3,243
  • 2
  • 25
  • 30
0
votes
1 answer

SQL Server Restore BACPAC throws error on a missing User-defined table type

I've exported an Azure SQL Database using the Azure Portal into a .bacpac file. Using SQL Server Management Studio 17.9.1, I run the "import data-tier application" wizard and select the .bacpac file. It won't import successfully: One error message…
JonHendrix
  • 933
  • 15
  • 28
1 2 3
…
8
9