Running in the Terminal
Explore how to execute PowerShell scripts within the embedded terminal of Azure Data Studio. Learn to switch terminal shells, prepare and run dataflow scripts safely, and understand the terminal's role in streamlining non-SQL operations to improve your data integration skills.
We'll cover the following...
Running the PowerShell script in the terminal
You may have noticed that the previous notebook command, which was using the PowerShell kernel, also used the PowerShell Core executable: PWSH as the last step (i.e., after the six variable assignments specifying the source and destination settings). We can optionally run this directly in the terminal window using a slightly modified script.
Introductions
Since this is the first time we have referenced the terminal window in the course, let’s take a minute to discuss it.
Over the past couple of decades, it was common for SQL developers using SQL Server Management Studio (SSMS) to open the Command Prompt, and/or PowerShell in a separate window to perform non-SQL operations (e.g., copying files, using FTP, or performing machine level diagnostics).
Azure Data Studio has disrupted that approach by embedding terminal windows, which ...