As of May 31, 2023, we have updated our Code of Conduct.

Questions tagged [sqlpackage]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers

How to rollback sqlpackage dacpack deployment [closed]

Please let me know what is best approach for rollback sqlpackage dacpack deployment. Or how to restore database to original state. Thanks in advance.
Sushant Kamble's user avatar
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 ...
Hamza Hamdani's user avatar
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. ...
SqlWorldWide's user avatar
  • 12.9k
0 votes
1 answer

Is it possible to apply filters on SqlPackage?

We develop a lot of modules separately. This means the Blog module has its own database in development. All objects of each module start with the module schema. So the Posts table inside the Blog ...
Ali EXE's user avatar
  • 205
0 votes
1 answer

importing bacpac file using sql package

How can I specify Database maximum size when importing bacpac file using sql package? The maximum size of 32GB is auto-sizing, but my actual DB size is over 35GB. Can I get to use DatabaseMaximumSize=(...
Cho Wai Tun's user avatar
0 votes
1 answer

Why does SQLPackage include my table-valued function in deployments when it hasn't changed?

I'm using SQLPackage in TFS to automate an SSDT project/DACPAC deployment with SQL Server 2014. I have a table-valued function that appears in the deployment report and script with every deployment, ...
John Hurtubise's user avatar
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 ...
Greg's user avatar
  • 544
1 vote
2 answers

SqlPackage importing of very large bacpacs to Azure

I want to import a database from a .bacpac file to a SQL Server in Azure. I read the document. It says that there is a flag called DatabaseMaximumSize=(INT32). I wanted to know if there's a limit that ...
CodeMonkey's user avatar
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 ...
Wai Lun Poon's user avatar
2 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:"...
Daryl1976's user avatar
  • 171
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 ...
Santhoshkumar KB's user avatar