How to run SQL Commands from PowerShell

If you want to run SQL commands from your PowerShell terminal you can do so by simply installing the SQLServer module with the command below: You will be prompted to install from an untrusted source. Type “A” to accept and install the module. Once it is complete you can see…

Want to improve your IT skillset? Start with a free account and get access to our IT labs!

Table of Contents

    Add a header to begin generating the table of contents

    Related Courses

    If you want to run SQL commands from your PowerShell terminal you can do so by simply installing the SQLServer module with the command below:

    Install-Module sqlserver
    Image
    Install SQLServer PowerShell Module

    You will be prompted to install from an untrusted source. Type “A” to accept and install the module.

    Once it is complete you can see all the new commands you have available to you by running the following command:

    Get-Command -Module SQLServer
    Image 1
    All the SQLServer PS Module Commands

    And that’s it! Now you can run commands like Invoke-SqlCMD!

    CREATE YOUR FREE ACCOUNT & GET OUR

    FREE IT LABS

    profile avatar

    Paul Hill

    Paul Hill is the founder of ServerAcademy.com and IT instructor to over 500,000 students online!