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
3 answers

SQL Azure - The ImportExport operation failed because of invalid storage credentials

When I run my script below it keeps failing with "The ImportExport operation failed because of invalid storage credentials." The access key and SAS all seem to be correct when I check in the portal. Can someone please point me in the right…
KayMan
  • 23
  • 6
0
votes
1 answer

Exclude column data from one table when restoring from a BACPAC file

I have a .bacpac file from a large database. The problem is it contains one table which has files stored as varbinary and is extremely large. This table is to large to restore locally. I would like to restore the .bacpac file, but instruct it to…
Scott Willhite
  • 129
  • 4
0
votes
0 answers

Importing Data Tier Application Turns Suspect After Server Restart

Whenever I export a data tier application from my Azure Sql Database and then Import that .bacpac file from that export into my local Sql Server after the machine is restarted the database is marked as suspect. Before restarting the machine the…
dmoore1181
  • 1,793
  • 1
  • 25
  • 57
0
votes
0 answers

How can I find .bacpac files in my Azure subscription inside storage

We have a subscription in Azure that has a SQL Server and all databases are being backed up once a month. We would like to download those backups but we cannot find or we don't know where can we find the .bacpac files, is there a way to find them or…
RaRdEvA
  • 694
  • 7
  • 12
0
votes
1 answer

SQL Azure backup on-prem using Powershell

I have this Powershell script I am trying to run, to do me a 'bacpac' file from an Azure tenancy database, to on-prem (local folder). # Load SMO Assembly [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO") | Out-Null #…
Fandango68
  • 4,461
  • 4
  • 39
  • 74
0
votes
3 answers

How to open Azure database .bacpac locally for local Umbraco website?

I exported and downloaded my database from Azure as a .bacpac file. I want to install Umbraco locally and use this database locally. How do I do it? Every time when I open the Microsoft SQL Server Management Studio it tries to connect to the…
Menahem Gil
  • 787
  • 2
  • 15
  • 39
0
votes
0 answers

Error while importing bacpac file to Azure SQL Database (SSISDB.catalogues is not supported in this version of SQL)

We are facing an issue when we are importing a bacpac file to azure SQL Datatbase. When we digged into the issue we have found out that the bacpac file which we are receving from past 5 days has the script which has "Execute ssisdb" related things…
Naga Nekkalapu
  • 1
  • 1
0
votes
1 answer

How can I programmatically import a .bacpac file into an on-premises SQL Server instance?

I am working on a project which hosts multiple services in Microsoft Azure, including their own databases, which are Azure SQL Databases. The development happens on developer laptops using Docker Compose including the database server which is using…
localhorst
  • 1
0
votes
0 answers

Is there any way to create bacpac file from ssms using code not the export wizard?

I am working on a .net framework-based windows application and I want to export data from a database and then import it to the other database with the same schema.
Krushal Sadariya
  • 1
0
votes
1 answer

Invalid length parameter passed to LEFT or SUBSTRING function when I try to import a .bacpac when a certain table is not empty

I exported a database to a .bacpac but when I tried to import said .bacpac again an error is raised: "Data plan execution failed with message One or more errors occurred" and the error that triggered this failure was "Invalid length parameter passed…
DinahMoeHumm
  • 185
  • 10
0
votes
0 answers

SQL Server Management Studio - SSMS doesn't show BackUp and Restore options on Tasks menu

I'm tying to transfer one sql database from one Azure account to another. One way to do this is documented by Microsoft here [Restore a Backup from a Device (SQL Server)], where they recomend to use BackUp and Restore options, but these options…
Marcelo Sader
  • 331
  • 4
  • 12
0
votes
1 answer

how to get AzSql Database Import/Export Status using Python

I am trying to import a bacpac to azure sql database it runs for almost 2.5 hours, I need to get the status of this import job i.e. in-progress, complete etc using python. I know I can do it using Get-AzSqlDatabaseImportExportStatus…
Manish
  • 23
  • 5
0
votes
1 answer

Import Data-Tier Application vs sqlpackage.exe

We are now encountering an error with an automated process when attempting to restore a .BACPAC file using the sqlpackage utility but are successful when importing the same file using the "Import Data-Tier Application" wizard through SSMS. The error…
Cza102282
  • 33
  • 6
0
votes
1 answer

SQL Server - Bacpac import issue

I have a .bacpac file of database (created from azure). The database contains master key and certificate attached. Now, I have to import data into my local instance, I am using import-data tier feature but it gives error related to you have already…
SSD
  • 1,041
  • 3
  • 19
  • 39
0
votes
1 answer

Import Bacpac file into Azure SQL DB

I have a bacpac file of db1 in my local. I want the bacpac file to import in database db2. When I was trying to import the file using import option in SSMS (right click database and import data) there is no option to connect to the existing/already…
John11
  • 51
  • 1
  • 7
1 2 3
…
8 9