MSSQL生成整个数据库的SQL脚本的工具 scptxfr.exe

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了MSSQL生成整个数据库的SQL脚本的工具 scptxfr.exe，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含1980字，纯文字阅读大概需要3分钟。

内容图文

scptxfr.exe的路径要正确
declare @cMd varchar(1000)
set @cmd = ‘master.dbo.xp_cmdshell ‘ + 
‘‘‘c:\"Microsoft ‘ +
‘SQL Server"‘ +
‘\MSSQL\Upgrade\scptxfr.exe ‘ +
‘ /s YourServerName /p YourSAPassword /I /d YourDBName /f ‘ +
‘c:\YourDBName.sql‘‘‘
exec (@cmd)

工具参数说明：
SCPTXFR /s <server> /d <database> {[/I] | [/P <password>]}
        {[/F <script files directory>] | [/f <single script file>]}
        /q /r /O /T /A /E /C <CodePage> /N /X /H /G /Y /?
/s - Indicates the source server to connect to.
/d - Indicates the source database to script.
/I - Use integrated security.
/P - Password to use for ‘sa‘. Note that login ID is always ‘sa‘.
     If /P not used or if a password does not follow the flag,
     a null password is used. Not compatible with /I.
/F - The directory into which the script files should be generated.
     This means one file is generated for each category of objects.
/f - The single file in which all script is to be saved.
     Not compatible with /F.
/q - Use quoted identifiers in the generated scripts.
/r - Include drop statements for the objects in the script.
/O - Generate OEM script files.  Cannot be used with /A or /T.
     This is the default behavior.
/T - Generate UNICODE script files.  Cannot be used with /A or /O.
/A - Generate ANSI script files.  Cannot be used with /T or /O.
/? - Command line help.
/E - Stop scripting when error occurs.
     Default behavior is to log the error, and continue.
/C - Indicate the CodePage which overrides the server CodePage.
/N - Generate ANSI PADDING.
/X - Script SPs and XPs to separate files.
/H - Generate script files without header (default: with header).
/G - Use the specified server name as the prefix for the generated             
     output files(to handle dashes in server name).
/Y - Generate script for Extended Properties (valid for 8.x server 
     only).

MSSQL生成整个数据库的SQL脚本的工具 scptxfr.exe

标签：

本文系统来源：http://www.cnblogs.com/Frank99/p/5951241.html

内容总结

以上是互联网集市为您收集整理的MSSQL生成整个数据库的SQL脚本的工具 scptxfr.exe全部内容，希望文章能够帮你解决MSSQL生成整个数据库的SQL脚本的工具 scptxfr.exe所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---