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

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

>

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,