Z Chen

Support AAD authentication via connection string

10

### Expected behaviour: Successful connection when "Active Directory Password" is specified in the connection string Example: ```ts const connectionString = "Server=test.database.windows.net;Database=master;Authentication=Active Directory Password;User [email protected];Password=abcd"; mssql.connect(connectionString); ``` See https://learn.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlconnection.connectionstring?view=dotnet-plat-ext-7.0 for allowed...

Database Projects - Generate script not working for new Azure SQL DBs

3

- Azure Data Studio Version: RC build from https://mssqltools.visualstudio.com/CrossPlatBuildScripts/_build/results?buildId=163875&view=results - OS Version: Win 11 Steps to Reproduce: 1. Create SDK style project, add some tables/views/etc. 2. Build and generate script...

Export fails with error - SQL71623: Model translation is not allowed because the model contains 1 errors

2

Export fails when stored procedure contains DDL that references a user-defined function. Workaround is to use SqlPackage Extract action with `/p:ExtractAllTableData=true`. - SqlPackage or DacFx Version: 15.0.5282.3 - .NET Framework...

Create stored procedure in empty database: ```tsql CREATE PROCEDURE [dbo].[spStringSplit] AS BEGIN SELECT value FROM STRING_SPLIT('XXXXX-XXXXX', '-', NULL) END ``` Extract/export will fail with following error: > Error 0: An...

Default configuration is Debug which builds to `./bin/Debug`. However if you add the following property to the SDK-style project, it still builds to `./bin/Debug`. It should build to `./bin/Release` instead....

Originally submitted as [TFS Defect 13100784](https://sqlbuvsts01/Main/SQL%20Server/_workitems#_a=edit&newQuery=false&id=13100784) by nadebow The issue was reported by SQL DW customer, but the same issue was repro'ed in SQL DB (SQL DB does not support...

Test SDK on all .NET SDK versions

2

Multi-target the test project to all supported .NET versions. This requires all SDK versions to be installed so we're only enabling this in the pipeline.

- SqlPackage or DacFx Version: 16.0.6296.0 - .NET Framework (Windows-only) or .NET Core: Both - Environment (local platform and source/target platforms): repros in Azure and SQL 2022, presumably in earlier...

Docs: * JSON_OBJECT: https://learn.microsoft.com/en-us/sql/t-sql/functions/json-object-transact-sql?view=sql-server-ver16 * JSON_ARRAY: https://learn.microsoft.com/en-us/sql/t-sql/functions/json-array-transact-sql?view=sql-server-ver16 JSON_OBJECT has new key value pair syntax like this: ` ::= json_key_name : value_expression` Both functions also have a new clause `` that...

Schema Compare issues when there are multiple objects with same name under a bucket

1

Version: 1.48.0-insider (user setup) Commit: 8a715ed3b1e87153e46651b920367170564eb376 Date: 2024-02-15T12:58:00.069Z VS Code: 1.82.0 Electron: 25.9.8 Chromium: 114.0.5735.289 Node.js: 18.15.0 V8: 11.4.183.29-electron.0 OS: Windows_NT x64 10.0.22631 ## Scenario 1 1. Create a database...