You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
A ScriptDom parsing regression was introduced in 18.3.1 where 'RENAME' is incorrectly treated as a top-level token, cause parsing to fail.
Known Issues
Feature
Details
Deployment
A regression was introduced in 18.4.1 causing there to be a “Object reference not set to an instance of an object.” error when deploying a dacpac or importing a bacpac with a user with external login. Workaround is to use sqlpackage 18.4 and it will be fixed in the next sqlpackage release.
Add support to deploy to Azure SQL Data Warehouse (GA).
Platform
sqlpackage .NET Core GA for macOS, Linux, and Windows.
Security
Remove SHA1 code signing.
Deployment
Add support for new Azure database editions: GeneralPurpose, BusinessCritical, Hyperscale
Deployment
Add Managed Instance support for AAD user and groups.
Deployment
Support the /AccessToken parameter for sqlpackage on .NET Core.
Known Issues
Feature
Details
ScriptDom
A ScriptDom parsing regression was introduced in 18.3.1 where 'RENAME' is incorrectly treated as a top-level token, cause parsing to fail. This will be fixed in the next sqlpackage release.
Known Issues for .NET Core
Feature
Details
Import
For .bacpac files with compressed files over 4GB in size, you might need to use the .NET Core version of sqlpackage to perform the import. This behavior is due to how .NET Core generates zip headers, which although valid, are not readable by the .NET Full Framework version of sqlpackage.
Deployment
The parameter /p:Storage=File is not supported. Only Memory is supported on .NET Core.
Always Encrypted
sqlpackage .NET Core does not support Always Encrypted columns.
Security
sqlpackage .NET Core does not support the /ua parameter for multi-factor authentication.
Deployment
Older V2 .dacpac and .bacpac files that use json data serialization aren't supported.
Add support to deploy to Azure SQL Data Warehouse (preview).
Deployment
Add /p:DatabaseLockTimeout=(INT32 '60') parameter to sqlpackage.
Deployment
Add /p:LongRunningCommandTimeout=(INT32) parameter to sqlpackage.
Export/Extract
Add /p:TempDirectoryForTableData=(STRING) parameter to sqlpackage.
Deployment
Allow deployment contributors to be loaded from additional locations. Deployment contributors will be loaded from the same directory as the target .dacpac being deployed, the Extensions directory relative to the sqlpackage.exe binary, and the /p:AdditionalDeploymentContributorPaths=(STRING) parameter added to sqlpackage where additional directory locations can be specified.
Deployment
Add support for OPTIMIZE_FOR_SEQUENTIAL_KEY.
Fixes
Fix
Details
Deployment
Fix to ignore automatic indexes so that they are not dropped on deployment.
Always Encrypted
Fix for handling Always Encrypted varchar columns.
Build/Deployment
Fix to resolve the nodes() method for xml column sets.
ScriptDom
Fix additional cases where the 'URL' string was interpreted as a top level token.
Graph
Fix generated TSQL for pseudo column references in constraints.
Export
Generate random passwords that meet complexity requirements.
Deployment
Fix to honor command timeouts when retrieving constraints.
.NET Core (preview)
Fix diagnostic logging to a file.
.NET Core (preview)
Use streaming to export table data to support large tables.
Add graph table support for edge constraints and edge constraint clauses.
Deployment
Enabled model validation rule to support 32 columns for index keys for SQL Server 2016 and up.
Fixes
Fix
Details
Deployment
Fix reverse engineering a SQL Server 2016 RTM database due to an unsupported query hint being used.
Deployment
Fix deployment ordering of auto close alter statements to occur before create filegroup statements.
ScriptDom
Fix ScriptDom parsing regression where the 'URL' string was interpreted as a top level token.
Deployment
Fix a null reference exception when parsing an alter table add index statement.
Schema Compare
Fixed schema compare for nullable persisted computed columns always showing as different.
18.1 sqlpackage
Release date: February 1, 2019
Build: 15.0.4316.1
Preview release.
Features
Feature
Details
Deployment
Added support for UTF8 collations.
Deployment
Enabled nonclustered columnstore indexes on an indexed view.
Platform
Moved to .NET Core 2.2.
Schema Compare
Use memory backed storage for schema compare on .NET Core.
Fixes
Fix
Details
Performance
Performance fix to use the legacy cardinality estimator for reverse engineering queries.
Performance
Fixed a significant schema compare performance issue when generating a script.
Schema Compare
Fixed the schema drift detection logic to ignore certain extended event (xevent) sessions.
Graph
Fixed import ordering for graph tables.
Export
Fixed exporting external tables with object permissions.
Known issues
This release includes cross-platform preview builds of sqlpackage that target .NET Core 2.2. The sqlpackage can run on macOS and Linux.
Known issue
Details
Deployment
For .NET Core, build and deployment contributors aren't supported.
Deployment
For .NET Core, older .dacpac and .bacpac files that use json data serialization aren't supported.
Deployment
For .NET Core referenced .dacpacs (for example master.dacpac) may not resolve due to issues with case-sensitive file systems.
18.0 sqlpackage
Release date: October 24, 2018
Build: 15.0.4200.1
Features
Feature
Details
Deployment
Added support for database compatibility level 150.
Deployment
Added support for Managed Instances.
Performance
Added MaxParallelism command-line parameter to specify the degree of parallelism for database operations.
Security
Added AccessToken command-line parameter to specify an authentication token when connecting to SQL Server.
Import
Added support to stream BLOB/CLOB data types for imports.
Deployment
Added support for scalar UDF 'INLINE' option.
Graph
Added support for graph table 'MERGE' syntax.
Fixes
Fix
Details
Graph
Fixed unresolved pseudo-column for graph tables.
Deployment
Fixed creating a database with memory optimized file groups when memory optimized tables are used.
Deployment
Fixed including extended properties on external tables.
17.8 sqlpackage
Release date: June 22, 2018
Build: 14.0.4079.2
Features
Feature
Details
Diagnostics
Improved error messages for connection failures, including the SqlClient exception message.
Deployment
Support index compression on single partition indexes for import/export.
Fixes
Fix
Details
Deployment
Fixed a reverse engineering issue for XML column sets with SQL 2017 and later.
Deployment
Fixed an issue where scripting the database compatibility level 140 was ignored for Azure SQL Database.
17.4.1 sqlpackage
Release date: January 25, 2018
Build: 14.0.3917.1
Features
Feature
Details
Import/Export
Added ThreadMaxStackSize command-line parameter to parse Transact-SQL with a large number of nested statements.
Deployment
Database catalog collation support.
Fixes
Fix
Details
Import
When importing an Azure SQL Database .bacpac to an on-premises instance, fixed errors due to Database master keys without password are not supported in this version of SQL Server.
Graph
Fixed an unresolved pseudo column error for graph tables.
Schema Compare
Fixed SQL authentication to compare schemas.
17.4.0 sqlpackage
Release date: December 12, 2017
Build: 14.0.3881.1
Features
Feature
Details
Deployment
Added support for temporal retention policy on SQL 2017+ and Azure SQL Database.
Diagnostics
Added /DiagnosticsFile:"C:\Temp\sqlpackage.log" command-line parameter to specify a file path to save diagnostic information.
Diagnostics
Added /Diagnostics command-line parameter to log diagnostic information to the console.
Fixes
Fix
Details
Deployment
Do not block when encountering a database compatibility level that is not understood. Instead, the latest Azure SQL Database or on-premises platform will be assumed.