Skip to main content
Archived

This project has been archived by its maintainers, and is no longer receiving any updates.

https://travis-ci.org/Microsoft/sql-xplat-cli.svg?branch=dev https://ci.appveyor.com/api/projects/status/vpm8p71265ijytqs/branch/dev?svg=true https://codecov.io/gh/Microsoft/sql-xplat-cli/branch/dev/graph/badge.svg?token=M96uWrHOIu https://badge.fury.io/py/mssql-scripter.svg https://img.shields.io/pypi/pyversions/mssql-scripter.svg

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 files for mssql-scripter 1.0.0a21

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for mssql-scripter 1.0.0a21
File Size Uploaded
mssql-scripter-1.0.0a21.tar.gz 18.8 kB Details

Release files / mssql-scripter-1.0.0a21.tar.gz

Download URL mssql-scripter-1.0.0a21.tar.gz
Size 18.8 kB
Tags Source
SHA-256 checksum
How to use checksums
84377b76e40ef8400b185e0235b15c264247cbfa6a8245e1ae8ab64c65daca4c
BLAKE2b-256 checksum
How to use checksums
f53b29a5c8afd8db2bbabdcb11aeae8191032580c637f8da383981fc9efe3333
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page