Monday, August 07, 2017

MSSQL Scripter: REST API + Python CLI

Now that Azure is moving to Python based CLI, other tools are following the same pattern:
expose REST web services, then create command line tool that is using it.

Azure Podcast: Episode 190 - MSSQL Scripter

Azure SQL DB: Generate scripts by using mssql-scripter

GitHub - Microsoft/sql-xplat-cli: Repository for the new SQL cross-platform command line tools

"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"

No comments: