How to install sqlcmd via python pip

- Intended Audience :: System Administrators
- Programming Language :: SQL
- Topic :: Database
- Topic :: Database :: Front-Ends

When you know about this project and you want to new install sqlcmd to support your project or you get trouble as ModuleNotFoundError: No module named "sqlcmd" or ImportError: cannot import name "sqlcmd" in your project, let follow this tutorial to install sqlcmd

Installation:

Step 1: First, ensure you installed pip in your os, to check pip has been installed on your computer

In Windows (CMD):

py -m pip --version

In Unix/macOS:

python3 -m pip --version

Ensure pip, setuptools, and wheel are up to date:

In Windows (CMD):

py -m pip install --upgrade pip setuptools wheel

In Unix/macOS:

python3 -m pip install --upgrade pip setuptools wheel

py -m pip install --user virtualenv

py -m venv test_sqlcmd_env

test_sqlcmd_env\Scripts\active

pip3 install virtualenv

python3 -m venv test_sqlcmd_env

source test_sqlcmd_env/bin/active

Step 2: OK, now, let flow below content to start the installation sqlcmd

To install sqlcmd on Windows(CMD):

py -m pip install sqlcmd

To install sqlcmd on Unix/macOs:

pip install sqlcmd

Step 3: If you want to install a specific sqlcmd version, add ==<sqlcmd version> to the end command line

Example:

pip install sqlcmd==0.4.1

Please see the version list below table:

py -m pip install sqlcmd==0.7.1

pip install sqlcmd==0.7.1

py -m pip install sqlcmd==0.7

pip install sqlcmd==0.7

py -m pip install sqlcmd==0.6

pip install sqlcmd==0.6

py -m pip install sqlcmd==0.5

pip install sqlcmd==0.5

py -m pip install sqlcmd==0.4.2

pip install sqlcmd==0.4.2

py -m pip install sqlcmd==0.4.1

pip install sqlcmd==0.4.1

Step 4: Otherwise, you can install sqlcmd from local archives:

Download the distribution file from sqlcmd-0.7.1.zip or the specific sqlcmd version in the below list of distribution

After that, install by command:

On Windows(CMD):

py -m pip install <path_to_sqlcmd_downloaded_file>

On Unix/macOs:

pip install <path_to_sqlcmd_downloaded_file>

List distribution:

Project link:

- Homepage