Questions tagged [sqlpackage]
The sqlpackage tag has no usage guidance.
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.
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 ...
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 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 ...
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=(...
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, ...
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 ...
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 ...
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 ...
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:"...
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 ...