blocks|key|1472444|text|Management+Studio的脚本生成选项只是SMO+scripting+capabilities的包装器。通过对各种类型的SMO使用Script()方法，可以获得简单的脚本。更复杂的脚本是由专门的Scripter类创建的。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1472445|使用SMO库可以轻松创建命令行工具。|1472446|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/ms162153.aspx|1|http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.scripter.aspx^0|1Y|8|2U|8|Q|Q|0|2U|8|1|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@$9|S|A|T|B|C]|$9|U|A|V|B|C]]|D|@$9|W|A|X|1|Y]|$9|Z|A|10|1|11]]|E|$]]|$1|F|3|G|5|6|7|12|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|13|8|@]|D|@]|E|$]]]|I|$J|$5|K|L|M|E|$N|O]]|P|$5|K|L|M|E|$N|Q]]]]

The script generating options of Management Studio are just a wrapper around the <a href="http://msdn.microsoft.com/en-us/library/ms162153.aspx" rel="noreferrer">SMO scripting capabilities</a>. Simple scripts are obtained by using the <code>Script()</code> method on various SMO types. More complex scripts are created by the specialized <a href="http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.scripter.aspx" rel="noreferrer"><code>Scripter</code></a> class.

Command line tools can be easily created by using the SMO libraries.

blocks|key|1472512|text|我的PC上的SQL2008+R2的SQLPubWiz.Exe位于"C:\Program+Files+(x86)\Microsoft+SQL+R2\90\Tools\Publishing\1.4“|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1472513|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

The SQLPubWiz.Exe for SQL2008 R2 on my PC is located on "C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Publishing\1.4"

blocks|key|1472584|text|SQLPUBWIZ+SCRIPT+-d+yourDBName+-S+yourServerName+-U+userName+-P+userPassword+scriptFilewithPath|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1472585|下载SQL2005+http://www.microsoft.com/downloads/details.aspx?FamilyId=56E5B1C5-BF17-42E0-A410-371A838E570A|offset|length|1472586|entityMap|0|LINK|mutability|MUTABLE|url|http://www.microsoft.com/downloads/details.aspx?FamilyId=56E5B1C5-BF17-42E0-A410-371A838E570A^0|0|A|2L|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

SQLPUBWIZ SCRIPT -d yourDBName -S yourServerName -U userName -P userPassword scriptFilewithPath

Download for SQL2005 <a href="http://www.microsoft.com/downloads/details.aspx?FamilyId=56E5B1C5-BF17-42E0-A410-371A838E570A" rel="nofollow noreferrer">http://www.microsoft.com/downloads/details.aspx?FamilyId=56E5B1C5-BF17-42E0-A410-371A838E570A</a>

blocks|key|1472672|text|您可以使用mssql-scripter，这是一个为数据库和数据库对象生成T-SQL脚本的命令行工具(适用于Windows、macOS和Linux)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1472673|可通过pip下载mssql脚本程序，因为它是基于Python的:+pip安装mssql脚本程序|1472674|您将运行类似于以下内容的命令来将数据库模式和数据编写到文件中：$+mssql-scripter+-S+localhost+-d+AdventureWorks+-U+sa+--+schema+-AdventureWorks--U>./Advisentureworks.sql更多用法示例：https://github.com/Microsoft/sql-xplat-cli/blob/dev/doc/usage_guide.md|offset|length|1472675|此项目可在此GitHub存储库-+https://github.com/Microsoft/sql-xplat-cli中找到|1472676|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/Microsoft/sql-xplat-cli/blob/dev/doc/usage_guide.md|1|https://github.com/Microsoft/sql-xplat-cli^0|0|0|3Z|1Y|0|0|H|16|1|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@$F|W|G|X|1|Y]]|A|$]]|$1|H|3|I|5|6|7|Z|8|@]|9|@$F|10|G|11|1|12]]|A|$]]|$1|J|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]|R|$5|M|N|O|A|$P|S]]]]

You can use mssql-scripter, a command line tool that generates T-SQL scripts for databases and database objects (works on Windows, macOS, and Linux). 

The download for mssql-scripter is via pip as it is Python-based:
pip install mssql-scripter

You'll run a command similar to the following to script the database schema and data to a file:
$ mssql-scripter -S localhost -d AdventureWorks -U sa --schema-and-data > ./adventureworks.sql
More usage examples: <a href="https://github.com/Microsoft/sql-xplat-cli/blob/dev/doc/usage_guide.md" rel="nofollow noreferrer">https://github.com/Microsoft/sql-xplat-cli/blob/dev/doc/usage_guide.md</a>

This project can be found at this GitHub repo - <a href="https://github.com/Microsoft/sql-xplat-cli" rel="nofollow noreferrer">https://github.com/Microsoft/sql-xplat-cli</a>

In Microsoft SQL Server Management Studio 2008 there is a "Generate scripts..." option under the Tasks menu. I'm just wondering if this tool is available from the command line somehow?

<img src="https://i.stack.imgur.com/wMRHF.png" alt="Screenshot of Generate SQL Server Scripts Wizard">

It looks similar to the sqlpubwiz.exe command line tool that was available for SQL Server 2005, but I can't find this executable anywhere in the SQL 2008 installation.

Generate SQL server scripts from command line?

命令行工具

SQL Server

数据库

Windows

Python

GitHub

Linux

在Microsoft SQL Server Management Studio 2008中，有一个“生成脚本...”Tasks菜单下的选项。我只是想知道这个工具是不是可以从命令行获得？​​它看起来与用于SQL Server2005的sqlpubwiz.exe命令行工具类似，但是我在SQL2008安装中找不到这个可执行文...

问是否从命令行生成SQL server脚本？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问是否从命令行生成SQL server脚本？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问是否从命令行生成SQL server脚本？
EN