search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.56k stars 898 forks source link

Publish from looses connection information using Generate Script. #25047

Open AcePalsgaard opened 11 months ago

AcePalsgaard commented 11 months ago

Type: Bug

  1. Create SQL Project in workspace
  2. Add an object such as View or table
  3. Press Publish from project name (Top element in Database Project tool window)
  4. Select Connection from connection dialog
  5. Press Generate Script

!SQLCMD is not enabled by default: Script errors every time

!Connection lost: You have to reconnect

Extension version: 1.4.1 Azure Data Studio version: azuredatastudio 1.47.0 (c7c2b2f21505562d21972d4c135119d00806db4f, 2023-11-07T17:17:45.669Z) OS version: Windows_NT x64 10.0.19045 Restricted Mode: No Preview Features: Enabled Modes:

System Info |Item|Value| |---|---| |CPUs|Intel(R) Core(TM) i7-10850H CPU @ 2.70GHz (12 x 2712)| |GPU Status|2d_canvas: enabled
canvas_oop_rasterization: enabled_on
direct_rendering_display_compositor: disabled_off_ok
gpu_compositing: enabled
multiple_raster_threads: enabled_on
opengl: enabled_on
rasterization: enabled
raw_draw: disabled_off_ok
video_decode: enabled
video_encode: enabled
vulkan: disabled_off
webgl: enabled
webgl2: enabled
webgpu: enabled| |Load (avg)|undefined| |Memory (System)|31.73GB (19.86GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|
kisantia commented 10 months ago

Currently the query editor opened with the generated script is not connected to the database specified in the publish dialog and the user needs to connect before running the script. Similar to this issue for schema compare https://github.com/microsoft/azuredatastudio/issues/6212