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.58k stars 908 forks source link

Create Azure Database Migration Service powershell script is collapsed onto one line, unrunnable #25943

Open clkrislawton opened 1 month ago

clkrislawton commented 1 month ago

Type: Bug

  1. Install the Azure SQL Migration extension.
  2. Connect to a SQL Server instance, right click a Database from the list, press Manage.
  3. Press the "Migrate to Azure SQL" button to start the process. I was migrating to an Azure SQL Database resource, not sure if any more info is needed.
  4. On step 5 of the process, under the Azure Database Migration Service drop-down, press Create New
  5. Select the "I want to setup self-hosted integration runtime on my local machine [...]" option.
  6. Open up the PowerShell script collapsible UI element to reveal the PowerShell script to run.area
  7. See that the script is presented on one line when copied into another text editor and when the user presses the "Execute Script" button given by the Azure Data Studio interface.

The script fails to run because the only line starts with a comment character. This locks the user into the process with no way of continuing.

I got around this by cloning the source code and finding the actual PS1 file here: azuredatastudio\extensions\sql-migration\scripts\SHIR-auto-configuration.ps1

Azure Data Studio version: azuredatastudio 1.49.1 (2f696aa95a13ccabd7e0a4431d1d759e3a7b8cfd, 2024-08-13T18:12:38.831Z) OS version: Windows_NT x64 10.0.19045 Restricted Mode: No Preview Features: Disabled Modes:

System Info |Item|Value| |---|---| |CPUs|Intel(R) Core(TM) i7-7700 CPU @ 3.60GHz (8 x 3600)| |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)|15.89GB (2.64GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|
Extensions (1) Extension|Author (truncated)|Version ---|---|--- sql-migration|Mic|1.5.4