Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [sqlpackage]

19 questions
4
votes
2 answers

Exclude certain schema along with unnamed constraints in SSDT

Task Automate database deployment (SSDT/dacpac deployment with CI/CD) The database is a 3rd party database It also includes our own customized tables/SP/Fn/Views in separate schemas Should exclude 3rd party objects while deploying the database…
Santhoshkumar KB
  • 581
  • 2
  • 9
  • 22
3
votes
1 answer

SqlPackage resolving table that doesn't exist

I'm trying to validate the integrity of one of our SQL Server 2016 databases by using sqlpackage.exe to extract the dacpac and validate the schema: ./sqlpackage.exe /DiagnosticsFile:"diagnostics_users.txt`" /Action:Extract /TargetFile:…
Daryl1976
  • 191
  • 4
2
votes
0 answers

Oracle 19C Auto Compile fails on Package With SQL_Macro but ALTER PACKAGE ... COMPILE Succeeds

We have a package SCHEMA.MYPACKAGE with a procedure SCHEMA.MYPACKAGE.GETDATA that calls a sql macro SCHEMA.SQLMACROFUNCTION that exists within the same schema but outside the package. The macro is called within a select statement and qualified by…
lightwing
  • 31
  • 6
1
vote
1 answer

sqlpackage.exe fails on SignalR objects

Issue: When running sqlpackage.exe to apply a sql dacpac, it occasionally fails on broker/SignalR related objects, which breaks the build: *** Could not deploy package. Error SQL72014: .Net SqlClient Data Provider: Msg 15151, Level 16, State 1, Line…
Greg
  • 582
  • 1
  • 4
  • 14
1
vote
2 answers

SqlPackage importing very large bacpacs to Managed Instance

I want to import a database from a .bacpac file to a SQL Server Managed Instance. I have read SqlPackage Import parameters and properties in the documentation. It says that there is a flag DatabaseMaximumSize=(INT32). I wanted to know if there's a…
CodeMonkey
  • 111
  • 6
1
vote
1 answer

Deploying dacpac through sqlpackage.exe with NETWORK SERVICE user

I have a database release pipeline in Azure DevOps Server which deploys our dacpac files through Powershell commands that run the sqlpackage.exe commands to publish the database. I am using the NETWORK SERVICE user to publish the databases to our…
user216359
0
votes
0 answers

DACPAC deployment hangs at Updating database (start)

We are currently in the middle of creating a proof of concept using DACPACs as our deployment/release method rather than our in-house deployment product. The two databases that I am currently using to test are Azure SQLDB databases, and our repo is…
scarr030
  • 115
  • 8
0
votes
0 answers

Sqlpackage.exe is dropping default constraints and computed columns

I'm deploying database schema-only (no data) changes to our Azure Sql Managed Instance via Azure DevOps task SqlAzureDacpacDeployment@1, and for some tables it is always dropping and re-creating computed columns and/or default constraints. Some of…
Greg
  • 582
  • 1
  • 4
  • 14
0
votes
1 answer

How do I synchronise data from Azure SQL DB to its newer version without changing the schema?

I have read about SqlPackage tool, and I found it amazing, very useful. I'm struggling though to understand how it can work with the following scenario. I have an Azure SQL DB, let's call it "MyDb", in a production environment, version 1.0. I would…
Alberto Solano
  • 101
  • 3
0
votes
0 answers

SqlPackage.exe not honoring DoNotDropObjectTypes

When deploying Sql Server changes, I'm seeing objects being dropped despite requesting them not to be dropped. For example, in /p:DoNotDropObjectTypes, I specified Services, but in the deployment output, it fails while attempting to drop the…
Greg
  • 582
  • 1
  • 4
  • 14
0
votes
1 answer

.DTSX package is there a way to wrap a workflow into a transaction

I have a dtsx package that imports data from a csv into a table, it truncates the table before it loads the data into the table. The problem is that sometimes for a reason or another the package fails, hence I end with an empty table, I would like…
Axeltherabbit
  • 117
  • 5
0
votes
1 answer

Why is SQLPackage suddenly including every scalar function in my SSDT project for ALTER in my deployment?

I have a SQL 2019 SSDT project with a large number of scalar and table-valued functions. Suddenly yesterday, my Windows TFS (on prem) deployment project's SQLPackage scripting step is suddenly including every scalar function in the project (~300) in…
John Hurtubise
  • 9
  • 1
0
votes
2 answers

SSIS Package hanging with two Constraints pointed at one Task: Can you have multiple constraints pointing to one Task?

In the example I pasted in the image, I have 5 Tasks. I don't think it's important what kind of Tasks I'm using--but I could be wrong, of course--because the main issue seems to be how the constraints (the arrows) flow. I have one flow that goes:…
user3621633
  • 275
  • 2
  • 10
0
votes
2 answers

SQL Server Agent not running SSIS package

I have followed many articles to create an SSIS pipeline package, deploy it and schedule it. I'm trying to transfer data from two remote servers, an OLEDB driver that connects to a SQL Server Database as a Source and an OLEDB provider for ODBC…
Hamza Hamdani
  • 17
  • 1
  • 5
0
votes
1 answer

SqlPackage Import - How to chose vCore purchase model?

I read the following documentation. Properties specific to the Import action Looking at the switch description for DatabaseEdition, I do not see a choice for vCore Azure SQL Database purchase model. Is it not possible to choose the vCore model while…
SqlWorldWide
  • 13,687
  • 3
  • 30
  • 54
1
2