Azure SQL Data Warehouse: Support for mssql-scripter

jeudi 22 juin 2017

In the latest release of the mssql-scripter, Azure SQL Data Warehouse is now supported. Mssql-scripter is the multiplatform command-line equivalent of the widely used Generate Scripts Wizard experience in SQL Server Management Studio.

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 tools (for example, sed, awk, grep) for further transformations. You can edit the generated script or check it into source control. Then, you can execute the script in your existing SQL Database or SQL Data Warehouse 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. The source code is on GitHub, and we welcome your contributions and pull requests. An installation and quick start guide is available.

Compte gratuit

Recevez $200 en crédits Azure ainsi qu’un accès pendant12 mois aux services populaires, et ce gratuitement.

Démarrez gratuitement

Visual Studio

Les abonnés obtiennent des crédits d’un montant de $1800 par an pour l’achat de services Azure

Activer maintenant

Start-ups

Rejoignez le programme BizSpark et bénéficiez des services Azure gratuits

En savoir plus.