语句生成整个数据库.docVIP

MSSQL生成整个数据库的SQL脚本的工具 --scptxfr.exe的路径要正确C:\Program Files\Microsoft SQL Server\MSSQL\Upgrade\scptxfr.exe declare @cMd varchar(1000) set @cmd = master.dbo.xp_cmdshell + c:\Program Files\Microsoft + SQL Server + \MSSQL\Upgrade\scptxfr.exe + /s LONCOM/p/I /d center3 /f + d:\center3.sql exec (@cmd) 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 { | [/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