| title | Microsoft DacFx & sqlpackage release notes| Microsoft Docs |
|---|---|
| description | Microsoft sqlpackage release notes |
| ms.custom | tools|sos |
| ms.date | 06/20/2018 |
| ms.prod | sql |
| ms.reviewer | alayu; sstein |
| ms.prod_service | sql-tools |
| ms.topic | conceptual |
| author | pensivebrian |
| ms.author | broneill |
| manager | kenvh |
Release date: October 24, 2018
Build: 15.0.4200.1
The release includes the following features and fixes:
- Added support for database compatibility level 150.
- Added support for Managed Instances.
- Added MaxParallelism command-line parameter to specify the degree of parallelism for database operations.
- Add AccessToken command-line parameter to specify an authentication token when connecting to SQL Server.
- Added support to stream BLOB/CLOB data types for imports.
- Added support for scalar UDF 'INLINE' option.
- Added support for graph table 'MERGE' syntax.
- Fixed unresolved pseudo-column for graph tables.
- Fixed creating a database with memory optimized file groups when memory optimized tables are used.
- Fixed including extended properties on external tables.
Release date: June 22, 2018
Build: 14.0.4079.2
The release includes the following fixes:
- Improved error messages for connection failures, including the SqlClient exception message.
- Support index compression on single partition indexes for import/export.
- Fixed a reverse engineering issue for XML column sets with SQL 2017 and later.
- Fixed an issue where scripting the database compatibility level 140 was ignored for Azure SQL Database.
Release date: January 25, 2018
Build: 14.0.3917.1
The release includes the following fixes:
- When importing an Azure SQL Database .bacpac to an on-premise instance, fixed errors due to 'Database master keys without password are not supported in this version of SQL Server'.
- Database catalog collation support.
- Fixed an unresolved pseudo column error for graph tables.
- Added ThreadMaxStackSize command-line parameter to parse TSQL with a large number of nested statements.
- Fixed using the SchemaCompareDataModel with SQL authentication to compare schemas.
Release date: December 12, 2017
Build: 14.0.3881.1
The release includes the following fixes:
- Do not block when encountering a database compatibility level not understood. Instead, the latest Azure SQL Database or on-premise platform will be assumed.
- Added support for 'temporal retention policy' on SQL2017+ and Azure SQL Database.
- Added /DiagnosticsFile:"C:\Temp\sqlpackage.log" command-line parameter to specify a file path to save diagnostic information.
- Added /Diagnostics command-line parameter to log diagnostic information to the console.
Release date: November 15, 2018
Build: 15.0.4240.1
This release contains the cross-platform preview build of sqlpackage that targets .NET Core 2.1, and can run on macOS and Linux.
The release includes the following fixes:
- Moved to .NET Core 2.1
- Support for CLR UDT types, including the SQL CLR UDT types: SqlGeography, SqlGeometry, & SqlHierarchyId.
This release is an early preview with following known issues:
- The /p:CommandTimeout parameter is hard coded to 120.
- Build and deployment contributors aren't supported.
- Older .dacpac and .bacpac files that use json data serialization aren't supported.
- Referenced .dacpacs (for example master.dacpac) may not resolve due to issues with case-sensitive file systems.
- A workaround is to capitalize the name of the reference file (for example MASTER.BACPAC).