RunSql

1.0.2

RunSql - GUI script for execution of SQL code and batch files. Just run this script from PowerShell and you'll get the main script GUI.
This GUI has the next elements:
Field "Sql Server Instance name" - the name of target SQL Server. Script will try to connect to this SQL Server.
Field "Port" - port number, which will be used for connecting to SQL Server. SQL Server s
RunSql - GUI script for execution of SQL code and batch files. Just run this script from PowerShell and you'll get the main script GUI.
This GUI has the next elements:
Field "Sql Server Instance name" - the name of target SQL Server. Script will try to connect to this SQL Server.
Field "Port" - port number, which will be used for connecting to SQL Server. SQL Server standart port 1433 using by default.
Field "SQl Server User Name" - user name which will be used for connection to SQL Server. This field is active, if checkbox "Use SQL Serve authentication" is enabled.
Field "SQl Server User Password" - password which will be used for connection to SQL Server. This field is active, if checkbox "Use SQL Serve authentication" is enabled.
Field "Database name" - the name of using database. You can select this name from list, wich will be got using the "Get Databases" button.
Button "Get Databases" - this button will be used for getting the databases list from SQL Server.
Checkbox "Use SQL Serve authentication" - if this checkbox is unactive, script will be try to use integrated security with current Windows user.
Checkbox "Execute T-SQL code" - if this checkbox is active, the field for SQL code enterning is enable. Use this checkbox if you want to execute SQL code directly.
Checkbox "Execute T-SQL bacth file" - if this checkbox is active, the field for SQL code enterning is disable, and "Browse" button will be active. Use this checkbox if you want to execute SQL batch file.
Field "T-SQL Code" is used for entering of executed T-SQL code, when checkbox "Execute T-SQL code" is enabled.
Field "T-SQL batch file" is used for entering of executed T-SQL batch file, when checkbox "Execute T-SQL batch file" is enabled.
Button "Browse" - this button will be using for selecting the T-SQL batch file, when you enable "Execute T-SQL bacth file" checkbox.
Checkbox "Disable output" - when this checkbox is enabled, result of T-SQL execution will not show in PowerShell console.
Button "Clear PowerShell console" is used for clearing the PowerShell console.
Button "Execute SQL" is used for starting the execution of T-SQL code. All execution process will be shown in PowerShell console by default.

Show more

Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Script -Name RunSql

Copy and Paste the following command to install this package using Microsoft.PowerShell.PSResourceGet More Info

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deploy all the dependencies to Azure Automation. Learn More

Manually download the .nupkg file to your system's default download location. Note that the file won't be unpacked, and won't include any dependencies. Learn More

Owners

Package Details

FileList

Version History

Version Downloads Last updated
1.0.2 (current version) 92 8/5/2020
1.0.0 56 10/6/2019