.. image:: https://travis-ci.org/Microsoft/mssql-scripter.svg?branch=dev :target: https://travis-ci.org/Microsoft/mssql-scripter
.. image:: https://ci.appveyor.com/api/projects/status/vpm8p71265ijytqs/branch/dev?svg=true :target: https://ci.appveyor.com/project/MrMeemus/mssql-scripter
.. image:: https://codecov.io/gh/Microsoft/mssql-scripter/branch/dev/graph/badge.svg?token=M96uWrHOIu :target: https://codecov.io/gh/Microsoft/mssql-scripter/branch/dev
.. image:: https://badge.fury.io/py/mssql-scripter.svg :target: https://pypi.python.org/pypi/mssql-scripter
.. image:: https://img.shields.io/pypi/pyversions/mssql-scripter.svg :target: https://travis-ci.org/Microsoft/mssql-scripter
We’re excited to introduce mssql-scripter, a multi-platform command line experience for scripting SQL Server databases.
mssql-scripter is the multiplatform command line equivalent of the widely used Generate Scripts Wizard experience in SSMS. You can use mssql-scripter on Linux, macOS, and Windows to generate data definition language (DDL) and data manipulation language (DML) T-SQL scripts for database objects in SQL Server running anywhere, Azure SQL Database, and Azure SQL Data Warehouse. You can save the generated T-SQL script to a .sql file or pipe it to standard nix utilities (for example, sed, awk, grep) for further transformations. You can edit the generated script or check it into source control and subsequently execute the script in your existing SQL database deployment processes and DevOps pipelines with standard multiplatform SQL command line tools such as sqlcmd.
mssql-scripter is built using Python and incorporates the usability principles of the new Azure CLI 2.0 tools.
.. code:: bash
$ pip install mssql-scripter
Please refer to the installation guide_ for detailed install instructions.
Please refer to the usage guide_ for details on options and example usage.
For general help content, pass in the -h parameter:
.. code:: bash
$ mssql-scripter -h
If you would like to contribute to the project, please refer to the development guide_.
If you encounter any bugs with the tool please file an issue in the
Issues_ section of our GitHub repo.
This project has adopted the Microsoft Open Source Code of Conduct_.
For more information see the Code of Conduct FAQ_ or contact
opencode@microsoft.com with any additional questions or comments.
mssql-scritper is licensed under the MIT license_.
.. _installation guide: doc/installation_guide.md .. _development guide: doc/development_guide.md .. _usage guide: doc/usage_guide.md .. _Issues: https://github.com/Microsoft/mssql-scripter/issues .. _Microsoft Open Source Code of Conduct: https://opensource.microsoft.com/codeofconduct/ .. _Code of Conduct FAQ: https://opensource.microsoft.com/codeofconduct/faq/ .. _MIT license: https://github.com/Microsoft/mssql-scripter/blob/dev/LI
FAQs
Microsoft SQL Scripter Command-Line Tool
We found that mssql-scripter demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 3 open source maintainers collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
CAI is a new open source AI framework that automates penetration testing tasks like scanning and exploitation up to 3,600× faster than humans.
Security News
Deno 2.4 brings back bundling, improves dependency updates and telemetry, and makes the runtime more practical for real-world JavaScript projects.
Security News
CVEForecast.org uses machine learning to project a record-breaking surge in vulnerability disclosures in 2025.