{"repo":"DrJohnT/PublishDacPac","free":true,"listed":false,"github":"https://github.com/DrJohnT/PublishDacPac","clone":"git clone https://github.com/DrJohnT/PublishDacPac.git","description":"PowerShell to publish (deploy) SQL Database using a DACPAC and DAC Publish Profile","language":"PowerShell","stars":18,"topics":["ssdt","deployment","dacpac","deploy","publish","sql","database","dac","sqlserver","dac-publish-profile"],"license":null,"category":"databases-storage","readme_excerpt":"PublishDacPac Deploy a SQL Database DacPac using a DAC Publish Profile Overview Publish-DacPac allows you to deploy a SQL Server Database DacPac to an on-premise SQL Server instance using a DAC Publish Profile. SSDT (SQL Server Data Tools) is Microsoft's tool to design the entire database model including tables, views, stored procedures, functions, schemas, etc. etc. etc. SSDT covering all aspects of a database design. SSDT is now fully integrated into Visual Studio. When you perform a build of a SSDT Visual Studio project, it creates a DacPac which defines all of the SQL Server objects - like tables, views, and instance objects, including logins - associated with a database. Publish-DacPac simplifies the use of SqlPackage.exe to deploy a DacPac overview) by using a DAC Publish Profile which provides for fine-grained control over the database creation and upgrades, including upgrades for schema, triggers, stored procedures, roles, users, extended properties etc. Using a DAC Publish Profile, multiple different properties can be set to ensure that the database is created or upgraded correctly. Publish-DacPac compares the content of a DacPac to the database already on the target server and generates a deployment script. You can tailor how publish works using a DAC Publish Profile. Publish-DacPac can be used to automate the deployment of databases, either as part of a build in Azure DevOps, or part of a server deployment using Octopus Deploy or Azure DevOps Release Manager. To au","default_branch":null,"files":null,"tree":[],"storefront":"/r/DrJohnT","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/DrJohnT/PublishDacPac/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}