OSQL命令自动执行SQL脚本

--注意SQL文件的编码

--31 to 32

--dir /b/s >upScripts.sql
declare @a1 varchar(500)
declare @dbName varchar(100)='O2_TEST'
--select @dbName='BPM'
--select @dbName='BPM_BES'
--select @dbName='BPM_BINLIVE'
--select @dbName='BPM_BINMUSIC'
--select @dbName='BPM_DAZZO'
--select @dbName='BPM_KEC'
declare @serverName varchar(100)='FlowERDB01'
declare @constOSQL varchar(2000)= 'osql -S'+@serverName+' -E -d'+@dbName+' -i'
--select @a1=@constOSQL+'D:\O2-Upgrade\UpgradeV6.2.2.0-V6.2.2.2\SQL\DATABASE\Script\18046_FlowER_V6.2.2.2.sql' EXEC master..xp_cmdshell @a1
select @a1=@constOSQL+'D:\4_Upgrade\4_Upgrade\UpgradeV6.2.3.1-V6.2.3.2\SQL\Database\Table\Alter\fm_form_type(Global).sql' EXEC master..xp_cmdshell @a1
select @a1=@constOSQL+'D:\4_Upgrade\4_Upgrade\UpgradeV6.2.3.1-V6.2.3.2\SQL\Database\Script\18046_FlowER_V6.2.3.2.sql' EXEC master..xp_cmdshell @a1
select @a1=@constOSQL+'D:\4_Upgrade\4_Upgrade\UpgradeV6.2.3.1-V6.2.3.2\SQL\Database\Script\18046_FlowER_V6.2.3.2_Glossary.sql' EXEC master..xp_cmdshell @a1
select @a1=@constOSQL+'D:\4_Upgrade\4_Upgrade\UpgradeV6.2.3.1-V6.2.3.2\SQL\Database\SP\dbo.sp_Common_GetApplyFormType.sql' EXEC master..xp_cmdshell @a1
select @a1=@constOSQL+'D:\4_Upgrade\4_Upgrade\UpgradeV6.2.3.1-V6.2.3.2\SQL\Database\SP\dbo.sp_Facade_GetFormActionPage.sql' EXEC master..xp_cmdshell @a1
select @a1=@constOSQL+'D:\4_Upgrade\4_Upgrade\UpgradeV6.2.3.1-V6.2.3.2\SQL\Database\SP\dbo.sp_InfoModel_getReceiver_System.sql' EXEC master..xp_cmdshell @a1
select @a1=@constOSQL+'D:\4_Upgrade\4_Upgrade\UpgradeV6.2.3.1-V6.2.3.2\SQL\Database\SP\dbo.usp_FormDefineProperty_DeleteFormType.PRC' EXEC master..xp_cmdshell @a1
select @a1=@constOSQL+'D:\4_Upgrade\4_Upgrade\UpgradeV6.2.3.1-V6.2.3.2\SQL\Database\SP\dbo.usp_FormDefineProperty_MoveFormType.PRC' EXEC master..xp_cmdshell @a1
select @a1=@constOSQL+'D:\4_Upgrade\4_Upgrade\UpgradeV6.2.3.1-V6.2.3.2\SQL\Database\SP\dbo.usp_FormDefineProperty_SaveFormType.PRC' EXEC master..xp_cmdshell @a1
select @a1=@constOSQL+'D:\4_Upgrade\4_Upgrade\UpgradeV6.2.3.1-V6.2.3.2\SQL\Database\SP\dbo.usp_FormDesign_BuildFormTableSingle.PRC' EXEC master..xp_cmdshell @a1
select @a1=@constOSQL+'D:\4_Upgrade\4_Upgrade\UpgradeV6.2.3.1-V6.2.3.2\SQL\Database\SP\dbo.usp_FormDesign_GetConstraint.SQL' EXEC master..xp_cmdshell @a1
select @a1=@constOSQL+'D:\4_Upgrade\4_Upgrade\UpgradeV6.2.3.1-V6.2.3.2\SQL\Database\SP\dbo.usp_FormDesign_PickerSetting.sql' EXEC master..xp_cmdshell @a1
select @a1=@constOSQL+'D:\4_Upgrade\4_Upgrade\UpgradeV6.2.3.1-V6.2.3.2\SQL\Database\SP\dbo.usp_WebAdmin_ApproveModel_Import_Employee.sql' EXEC master..xp_cmdshell @a1
select @a1=@constOSQL+'D:\4_Upgrade\4_Upgrade\UpgradeV6.2.3.1-V6.2.3.2\SQL\Database\SP\dbo.usp_WebAdmin_GetFormType.PRC' EXEC master..xp_cmdshell @a1
select @a1=@constOSQL+'D:\4_Upgrade\4_Upgrade\UpgradeV6.2.3.1-V6.2.3.2\SQL\Database\SP\dbo.usp_WebAdmin_SetApplyFormPermission.PRC' EXEC master..xp_cmdshell @a1
select @a1=@constOSQL+'D:\4_Upgrade\4_Upgrade\UpgradeV6.2.3.1-V6.2.3.2\SQL\Database\SP\usp_WebAdmin_GetFormType_Edit.sql' EXEC master..xp_cmdshell @a1

/*

sp_configure 'show advanced options', 0
GO
RECONFIGURE
GO
sp_configure 'xp_cmdshell', 0
GO
RECONFIGURE
GO

*/