Microsoft SqlPackage for .NET Framework Microsoft Corporation
winget install --id=Microsoft.SqlPackage.NETFramework -e Microsoft SQLPackage is a command-line utility designed to automate database development tasks by exposing public Data-Tier Application Framework (DacFx) APIs. It streamlines workflows for importing, exporting, deploying, and managing databases in Azure SQL Database, Microsoft Fabric, and SQL Server.
Key Features:
- Advanced Permissions Support: Includes enhanced permissions such as EXECUTE ON EXTERNAL MODEL, ALTER ANY EXTERNAL MIRROR, and CREATE/ALTER ANY EXTERNAL MODEL.
- Database Options: Adds support for ACCELERATED_DATABASE_RECOVERY and OPTIMIZED_LOCKING to improve database performance and reliability.
- Vector Data Type Enhancements: Expands vector column support, including the ability to change base types and use VECTOR_SEARCH functions.
- JSON Indexes: Supports importing, exporting, and deploying JSON indexes with functions like JSON_ARRAYAGG and JSON_OBJECTAGG.
- Platform Compatibility: Offers .NET 10 compatibility for DacFx and SQLPackage CLI, ensuring broader support for modern development environments.
Audience & Benefit: Ideal for database developers and administrators working with Azure SQL Database, Microsoft Fabric, or SQL Server. This tool enables efficient deployment, automation of repetitive tasks, and simplifies managing advanced database features like external models, JSON indexes, and vector data types. It helps improve workflow efficiency while ensuring compliance with the latest database capabilities.
Installed via winget, SQLPackage provides a robust solution for modern database development needs.