SqlPackage 170.5.96: más control sobre los permisos al extraer una base de datos Microsoft publicó el 15 de septiembre de 2026 la versión 170.5.96.0 de SqlPackage, y entre sus cambios aparece una mej...

If you deploy .dacpac files frequently, you know how much time is wasted when nothing has actually changed.

DacFx, SqlPackage, and other SQL development libraries enable declarative database development and database portability across SQL versions and environments. Share feedback here on dacpacs, bacpacs...

If you have ever deployed a SQL Database Project (.sqlproj) or a .dacpac with SqlPackage, you know the drill: you kick off a publish against an empty or near-empty database, grab a coffee, and wait. Even for tiny schemas, every single publish reliably took 20+ seconds before anything actually happened on the server.

Your database should be part of the same development process as the rest of your application, with source control and automation for validation and...

If you have ever deployed a SQL Database Project (.sqlproj) or a .dacpac with SqlPackage, you know the drill: you kick off a publish against an empty or near-empty database, grab a coffee, and wait.…

Your database should be part of the same development process as the rest of your application, with source control and automation for validation and...

If you deploy your SQL Server databases with SSDT or DACPACs via SqlPackage, you have probably run into this problem: the schema deployment is repeatable, but the data patches are not. SSDT handles CREATE TABLE, ALTER PROCEDURE, and every other schema object with a declarative model. Run the deployment ten times and you get the same schema. But the post-deployment script runs every time too, and if it contains INSERT or UPDATE statements, you either duplicate data or you wrap everything in IF NOT EXISTS checks that grow into an unreadable mess.

Introducing the SqlProject extract target in SqlPackage 170.4 previews - write your database directly out to a ready-to-use code definition. 📦 🚀 Grab the latest SqlPackage preview (currently 170.4.43-preview)...

Database deployments have traditionally been one of the trickier parts of a CI/CD pipeline. You need the right tools installed, the right permissions configured, and the right SQL Server instance reachable—all at deploy time. MSBuild.Sdk.SqlProj simplifies this by letting you manage your SQL Server schema as code and build a .dacpac file just like any other .NET project. Starting with version 4.0.0, it goes one step further by letting you package the .dacpac and the deployment tool into a self-contained container image that can be run anywhere containers can run.

This article explains how I use sqlpackage to detect schema drift and generate a delta script that shows exactly what’s different.

This article explains how I use sqlpackage to detect schema drift and generate a delta script that shows exactly what’s different.

This article explains how I use sqlpackage to detect schema drift and generate a delta script that shows exactly what’s different.

Learn how to migrate SQL Server to Azure SQL Database using Azure DMS and SqlPackage, covering assessment with Azure Arc, schema migration, data movement, and post-migration validation.

DacFx, SqlPackage, and other SQL development libraries enable declarative database development and database portability across SQL versions and environments. Share feedback here on dacpacs, bacpacs...

DacFx, SqlPackage, and other SQL development libraries enable declarative database development and database portability across SQL versions and environments. Share feedback here on dacpacs, bacpacs...

There are scenarios where you need to perform CI/CD for your SQL database in Fabric in isolation of other Fabric items. In this episode, we cover two ways that you can perform CI/CD for SQL database in Fabric using Azure DevOps. 0:00 Introduction 1:55 CI/CD for SQL databases in Fabric 3:08 Demo 4:00 Demo 7:50 Demo 8:55 Demo ✅ Resources: What are database projects?: https://learn.microsoft.com/en-us/sql/tools/sql-database-projects/sql-database-projects?view=sql-server-ver17 SqlPackage: https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage?view=sql-server-ver17 About MVPs: Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others - that's what sets them apart. Learn more: https://aka.ms/mvpprogram 📌 Let's connect: Twitter: Anna Hoffman, https://twitter.com/AnalyticAnna Twitter: AzureSQL, https://aka.ms/azuresqltw 🔴 To watch other MVP Edition episodes, see our playlist: https://aka.ms/dataexposedmvps To check out even more Data Exposed episodes, see our playlist: https://aka.ms/dataexposedyt 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #AzureSQL #SQLServer

SqlPackage is a command-line utility that automates database development tasks by exposing some of the public Data-Tier Application Framework (DacFx) APIs.

This is a frequent scenario, especially when migrating large databases to Azure. The truth is, the time taken for a BACPAC import depends on several factor:...

This is a frequent scenario, especially when migrating large databases to Azure. The truth is, the time taken for a BACPAC import depends on several factor:...