Skip to main content
Help us improve Python packaging – donate today!

Microsoft SQL Scripter Command-Line Tool

Project Description

https://travis-ci.org/Microsoft/mssql-scripter.svg?branch=dev https://ci.appveyor.com/api/projects/status/vpm8p71265ijytqs/branch/dev?svg=true https://codecov.io/gh/Microsoft/mssql-scripter/branch/dev/graph/badge.svg?token=M96uWrHOIu

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.

Installation

$ pip install mssql-scripter

Please refer to the installation guide for detailed install instructions.

Usage

Please refer to the usage guide for details on options and example usage.

For general help content, pass in the -h parameter:

$ mssql-scripter -h

Contributing

If you would like to contribute to the project, please refer to the development guide.

Reporting issues and feedback

If you encounter any bugs with the tool please file an issue in the Issues section of our GitHub repo.

Code of Conduct

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.

License

mssql-scritper is licensed under the MIT license.

Release history Release notifications

This version
History Node

1.0.0a22

History Node

1.0.0a21

History Node

1.0.0a20

History Node

1.0.0a18

History Node

1.0.0a17

History Node

1.0.0a16

History Node

1.0.0a15

History Node

1.0.0a14

History Node

1.0.0a13

History Node

1.0.0a12

History Node

1.0.0a11

History Node

1.0.0a1

History Node

1.0.0a0

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, size & hash SHA256 hash help File type Python version Upload date
mssql_scripter-1.0.0a22-py2.py3-none-macosx_10_11_intel.whl (33.7 MB) Copy SHA256 hash SHA256 Wheel py2.py3 Nov 17, 2017
mssql_scripter-1.0.0a22-py2.py3-none-manylinux1_i686.whl (34.7 MB) Copy SHA256 hash SHA256 Wheel py2.py3 Nov 17, 2017
mssql_scripter-1.0.0a22-py2.py3-none-manylinux1_x86_64.whl (34.7 MB) Copy SHA256 hash SHA256 Wheel py2.py3 Nov 17, 2017
mssql_scripter-1.0.0a22-py2.py3-none-win32.whl (34.1 MB) Copy SHA256 hash SHA256 Wheel py2.py3 Nov 17, 2017
mssql_scripter-1.0.0a22-py2.py3-none-win_amd64.whl (36.8 MB) Copy SHA256 hash SHA256 Wheel py2.py3 Nov 17, 2017

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging CloudAMQP CloudAMQP RabbitMQ AWS AWS Cloud computing Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page