146 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
52
views
user_type_id values are inconsistent when using a bacpac file from one machine on another
I'm creating a .bacpac file of a database on a server and then restoring that .bacpac file onto another server. When I do that the values for user_type_id for custom user types within sys.types is ...
0
votes
0
answers
175
views
I am getting an error while importing .bacpac file
I am trying to import a .bacpac file, but I'm getting this error
One or more errors occurred. (mscorlib)
One or more errors occurred.
One or more errors occurred.
Violation of PRIMARY KEY constraint '...
0
votes
1
answer
126
views
Azure SQL Server to on-premise (local) server database data-tier import error
I'm getting this error message whenever I import the .BACPAC data tier file that I exported from Azure SQL Server:
Could not import package.
Warning SQL72012: The object [database_name_Data] exists ...
-1
votes
1
answer
488
views
Importing .bacpac file with Azure Data Studio on MacBook Pro with M3 chip
I am currently using a MacBook Pro with an M3 chip and I am trying to import a .bacpac file with Azure Data Studio. However, I am encountering an issue due to the requirement of running the following ...
0
votes
1
answer
619
views
Procedure FINTAG_INSTEADOFINSERTTRIGGER, Line 41 Cannot insert an explicit value into a timestamp column
I encountered the following error while attempting to restore the 10.0.40 UAT.bacpac on a development environment running version 10.0.38:
Procedure FINTAG_INSTEADOFINSERTTRIGGER, Line 41 Cannot ...
-3
votes
1
answer
213
views
How can i import a 1 terabyte bacpac to an Azure SQL Server?
I have a 1 terabyte bacpac file. I have this file residing in an Azure Storage account.
I have tried using SSMS, SQLPackage, Azure Portal and Powershell and they all fail in importing.
Is there a way ...
0
votes
0
answers
309
views
Any way to validate or open a potentially corrupt bacpac file?
I am trying to open a bacpac file to restore an Azure database but have run into several issues thus far.
EDIT: the file is >20GB so I cannot open it in notepad, but using MORE it does seem that ...
0
votes
0
answers
17
views
Is there a way to convert BACPAC files into a readable format? [duplicate]
We are using BACPAC files for our MS-SQL Server in an Azure elastic pool to create backups.
We faced a problem where while resorting the backup an error with a PK occurred.
Is there a possibility to ...
1
vote
2
answers
934
views
As a subscription owner, whenever I try to export an Azure database as a BACPAC to a container within a datablob I get a BlobAlreadyExist error code
I have been tasked to backup and delete a couple databases; however, whenever I do so (and note that this container is brand new and completely empty) I get the following error from the activity log:
...
3
votes
1
answer
999
views
Import data-tier application (bacpac) into azure SQL edge docker instance
I am trying to import data from a .bacpac sql data file into a azure sql edge container. I have tried 2 ways to achieve it, but unfortunately no luck.
Using sqlpackage cmd tool to import bacpac file ...
1
vote
1
answer
84
views
What is the most efficient way to generate a change data set given two SQL Server backup files?
I need to ingest data from a vendor that only provides full snapshots of their databases rather than pushing the changes or providing direct query / API access.
So the vendor uploads a SQL Server ...
0
votes
1
answer
1k
views
How do I fix the a database platform service Error when importing bacpac to Azure
I received a bacpac that was created from a SQL Server 2017 (not Azure) but I want to restore it in Azure. I tried using SSMS 2016 and connected to Azure SQL and used the Import Data Tier Application ...
0
votes
1
answer
407
views
Using SqlPackage .NET 6 edition. How to specify Data/Log file paths?
I am forced to use the .Net 6 version of SqlPackage.exe to import a bacpac file.
I have looked over the documentation here https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-import?view=...
0
votes
1
answer
671
views
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.................
0
votes
2
answers
1k
views
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 ...