最新文章专题视频专题问答1问答10问答100问答1000问答2000关键字专题1关键字专题50关键字专题500关键字专题1500TAG最新视频文章推荐1 推荐3 推荐5 推荐7 推荐9 推荐11 推荐13 推荐15 推荐17 推荐19 推荐21 推荐23 推荐25 推荐27 推荐29 推荐31 推荐33 推荐35 推荐37视频文章20视频文章30视频文章40视频文章50视频文章60 视频文章70视频文章80视频文章90视频文章100视频文章120视频文章140 视频2关键字专题关键字专题tag2tag3文章专题文章专题2文章索引1文章索引2文章索引3文章索引4文章索引5123456789101112131415文章专题3
当前位置: 首页 - 科技 - 知识百科 - 正文

MSSQL生成整个数据库的SQL脚本的工具_MySQL

来源:动视网 责编:小采 时间:2020-11-09 17:37:46
文档

MSSQL生成整个数据库的SQL脚本的工具_MySQL

MSSQL生成整个数据库的SQL脚本的工具_MySQL:scptxfr.exe的路径要正确declare @cMd varchar(1000)set @cmd = 'master.dbo.xp_cmdshell ' + '''c:/Microsoft ' +'SQL Server' +'/MSSQL/Upgrade/scptxfr.exe ' +' /s YourServerName /p YourSA
推荐度:
导读MSSQL生成整个数据库的SQL脚本的工具_MySQL:scptxfr.exe的路径要正确declare @cMd varchar(1000)set @cmd = 'master.dbo.xp_cmdshell ' + '''c:/Microsoft ' +'SQL Server' +'/MSSQL/Upgrade/scptxfr.exe ' +' /s YourServerName /p YourSA


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 /d {[/I] | [/P ]}
{[/F ] | [/f ]}
/q /r /O /T /A /E /C /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脚本的工具_MySQL

MSSQL生成整个数据库的SQL脚本的工具_MySQL:scptxfr.exe的路径要正确declare @cMd varchar(1000)set @cmd = 'master.dbo.xp_cmdshell ' + '''c:/Microsoft ' +'SQL Server' +'/MSSQL/Upgrade/scptxfr.exe ' +' /s YourServerName /p YourSA
推荐度:
标签: 软件 工具 数据库
  • 热门焦点

最新推荐

猜你喜欢

热门推荐

专题
Top