탐색 건너뛰기

Azure SQL DB: Generate scripts by using mssql-scripter

2017년 7월 19일 수요일

You can now use mssql-scripter, an open-source command-line interface, to generate database scripts. Mssql-scripter is a multi-OS command-line equivalent of the widely used Generate and Publish 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.

체험 계정

Azure 크레딧 $200을 얻고 인기 서비스를 12개월 간 체험해 보세요.

시작

Visual Studio

구독자는 매년 최대 $1800 상당의 Azure 서비스를 이용할 수 있습니다.

지금 활성화

스타트업

Microsoft for Startups에 참가하고 Azure 서비스를 체험해 보세요.

자세한 정보