mssql-scripter : generate SQL Server DML and DDL Scripts on Linux, macOS and Windows

Microsoft has introduced mssql-scripter, a multi-platform(on Linux, macOS, and Windows ) command line experience for scripting SQL Server databases. With this, we can generate data definition language (DDL) and data manipulation language (DML)  T-SQL Scripts for DB objects which are running anywhere, Azure SQL database, and Azure SQL Data WareHouse(DWH).

Generated scripts can be saved to .sql or pipe it to nix utilities. After changes to the scripts, we can execute back using command line tools such as sqlcmd.

You can download and install mssql-scripter from https://github.com/Microsoft/mssql-scripter