Questions tagged [sqlpackage]
The sqlpackage tag has no usage guidance.
11
questions
0
votes
0
answers
7
views
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.
0
votes
2
answers
1k
views
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 ...
0
votes
1
answer
199
views
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.
...
- 12.9k
0
votes
1
answer
276
views
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 ...
- 205
0
votes
1
answer
265
views
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=(...
0
votes
1
answer
158
views
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, ...
1
vote
1
answer
163
views
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 ...
- 544
1
vote
2
answers
575
views
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 ...
- 111
1
vote
1
answer
495
views
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 ...
- 13
2
votes
1
answer
517
views
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:"...
- 171
4
votes
2
answers
3k
views
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 ...
- 591