Azure Cloud Shell: Generate scripts by using mssql-scripter

23 Ağustos 2017 Çarşamba

You can now use mssql-scripter, an open-source command-line interface, to generate database scripts in Azure Cloud Shell. 

With mssql-scripter, you can 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. The generated script can be edited or checked in to 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, which is also available in Azure Cloud Shell.

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.

Ücretsiz hesap

$200 değerinde Azure kredisi elde edin ve popüler hizmetlerden 12 ay boyunca ücretsiz olarak yararlanın

Ücretsiz kullanmaya başlayın

Visual Studio

Aboneler yıllık $1800 tutarına kadar Azure hizmeti edinir

Şimdi etkinleştirin


BizSpark programına katılıp ücretsiz Azure hizmetlerinden yararlanın

Daha fazla bilgi edinin