Skip to content
Repository for the new SQL cross-platform command line tools
Python Other
  1. Python 99.3%
  2. Other 0.7%
Branch: dev
Clone or download
Latest commit a2e3efd Jun 28, 2018
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
doc Merging release 1.0.0a22 (#164) Nov 17, 2017
mssqlscripter Version bump to 1.0.0a23 Jun 28, 2018
sqltoolsservice Ron/refresh sqltoolsservice v1.4.0-alpha.47 (#195) Jun 27, 2018
.bumpversion.cfg Version bump to 1.0.0a23 Jun 28, 2018
.gitattributes Feature/scripting client (#4) Mar 27, 2017
.gitignore Merging release 1.0.0a22 (#164) Nov 17, 2017
.travis.yml Merging dev to master for release 1.0.0a20 (#141) Sep 1, 2017
LICENSE.txt Refactor/folder structure (#23) Apr 13, 2017
MANIFEST.in Merging release 1.0.0a22 (#164) Nov 17, 2017
README.rst Merging release 1.0.0a22 (#164) Nov 17, 2017
appveyor.yml Merging dev to master for release 1.0.0a20 (#141) Sep 1, 2017
build.py Fixing naming convention for local copy of sqltoolsservice, removed l… ( Nov 22, 2017
dev_requirements.txt Merging dev to master for release 1.0.0a20 (#141) Sep 1, 2017
dev_setup.py Merging release 1.0.0a22 (#164) Nov 17, 2017
dos2unix.py Merging release 1.0.0a22 (#164) Nov 17, 2017
mssql-scripter Merging release 1.0.0a22 (#164) Nov 17, 2017
mssql-scripter.bat Feature/stdout fix (#84) May 18, 2017
mssql-scripter.pyproj Ron/remove win64 (#165) Nov 20, 2017
mssql-scripter.sln Merging release 1.0.0a22 (#164) Nov 17, 2017
setup.cfg Merging release 1.0.0a22 (#164) Nov 17, 2017
setup.py Version bump to 1.0.0a23 Jun 28, 2018
tox.ini Ron/remove win64 (#165) Nov 20, 2017
utility.py Merging release 1.0.0a22 (#164) Nov 17, 2017

README.rst

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.

You can’t perform that action at this time.