批处理完成SQL一键安装

最新推荐文章于 2023-04-24 10:00:00 发布

zw0558

最新推荐文章于 2023-04-24 10:00:00 发布

阅读量4.1k

点赞数

文章标签： sql sql server collation file mfc system

本文链接：https://blog.youkuaiyun.com/zw0558/article/details/5965165

版权

1.打开bat文件正确方法

CString m_strPath ="D://安装文件//sql2000//SQL2000_PER";
SetCurrentDirectoryA(m_strPath);
system((LPCTSTR)("D://安装文件//sql2000//SQL2000_PER//setup.bat"));

2.bat文件设置

@echo off
rem Performs SQL Server Full Server Unattended Install operation

rem Before running this batch file, you must edit the corresponding
rem unattended install file (sqlins.iss), and enter your
rem Product Key (CD-Key) from your CD.

cls

echo *
echo Unattended install for SQL Server is starting.
echo *
echo *
echo Waiting for SQL Server Setup to finish...

@echo on
start /wait x86/setup/setupsql.exe -s -m -SMS -f1 "sqlTest.iss"
@echo off

3.sqlTest.iss 文件设置

[InstallShield Silent]
Version=v5.00.000
File=Response File

[File Transfer]
OverwriteReadOnly=NoToAll

[DlgOrder]
Dlg0=SdWelcome-0
Count=15
Dlg1=DlgMachine-0
Dlg2=DlgInstallMode-0
Dlg3=SdRegisterUser-0
Dlg4=SdLicense-0
Dlg5=DlgClientServer-0
Dlg6=DlgInstanceName-0
Dlg7=SetupTypeSQL-0
Dlg8=SQLComponentMult-0
Dlg9=DlgServices-0
Dlg10=DlgSQLSecurity-0
Dlg11=DlgCollation-0
Dlg12=DlgServerNetwork-0
Dlg13=SdStartCopy-0
Dlg14=SdFinish-0

[SdWelcome-0]
Result=1

[DlgMachine-0]
Type=1
Result=1

[DlgInstallMode-0]
Type=1
Result=1

[SdRegisterUser-0]
szName=MSEmployee
Result=1

[SdLicense-0]
Result=1

[DlgCDKey-0]
Result=1
CDKey=XXXXX-XXXXX-XXXXX-XXXXX-XXXXX

[DlgClientServer-0]
Type=2
Result=1

[DlgInstanceName-0]
InstanceName=MSSQLSERVER
Result=1

[SetupTypeSQL-0]
szDir=%PROGRAMFILES%/Microsoft SQL Server
Result=303
szDataDir=%PROGRAMFILES%/Microsoft SQL Server

[SQLComponentMult-0]
SQLProg/SQLServr/SCMDev-type=string
SQLProg/SQLServr/SCMDev-count=3
SQLProg/SQLServr/SCMDev-0=SQLProg/SQLServr/SCMDev/SCMh
SQLProg/SQLServr/SCMDev-1=SQLProg/SQLServr/SCMDev/SCMX86Lb
SQLProg/SQLServr/SCMDev-2=SQLProg/SQLServr/SCMDev/SCMALb
SQLProg/SQLServr/SSCE-type=string
SQLProg/SQLServr/SSCE-count=1
SQLProg/SQLServr/SSCE-0=SQLProg/SQLServr/SSCE/Com
SQLProg/SQLServr-type=string
SQLProg/SQLServr-count=7
SQLProg/SQLServr-0=SQLProg/SQLServr/Help
SQLProg/SQLServr-1=SQLProg/SQLServr/SCMDev
SQLProg/SQLServr-2=SQLProg/SQLServr/Rs1033
SQLProg/SQLServr-3=SQLProg/SQLServr/RsIntl
SQLProg/SQLServr-4=SQLProg/SQLServr/ActiveX
SQLProg/SQLServr-5=SQLProg/SQLServr/System
SQLProg/SQLServr-6=SQLProg/SQLServr/SSCE
SQLProg/UpgTools-type=string
SQLProg/UpgTools-count=5
SQLProg/UpgTools-0=SQLProg/UpgTools/UpgSys
SQLProg/UpgTools-1=SQLProg/UpgTools/ActiveX
SQLProg/UpgTools-2=SQLProg/UpgTools/Res1033
SQLProg/UpgTools-3=SQLProg/UpgTools/ResOther
SQLProg/UpgTools-4=SQLProg/UpgTools/Resld
SQLProg/ReplSupp-type=string
SQLProg/ReplSupp-count=4
SQLProg/ReplSupp-0=SQLProg/ReplSupp/ReplDat
SQLProg/ReplSupp-1=SQLProg/ReplSupp/RepComm
SQLProg/ReplSupp-2=SQLProg/ReplSupp/RepNoDk
SQLProg/ReplSupp-3=SQLProg/ReplSupp/ActiveX
SQLProg/SvrExt-type=string
SQLProg/SvrExt-count=3
SQLProg/SvrExt-0=SQLProg/SvrExt/Help
SQLProg/SvrExt-1=SQLProg/SvrExt/SvrExtRs
SQLProg/SvrExt-2=SQLProg/SvrExt/ResIntl
SQLProg/MSSearch-type=string
SQLProg/MSSearch-count=2
SQLProg/MSSearch-0=SQLProg/MSSearch/Help
SQLProg/MSSearch-1=SQLProg/MSSearch/ActiveX
SQLProg/Symbols-type=string
SQLProg/Symbols-count=2
SQLProg/Symbols-0=SQLProg/Symbols/EXE
SQLProg/Symbols-1=SQLProg/Symbols/DLL
SQLProg/Perfmon-type=string
SQLProg/Perfmon-count=1
SQLProg/Perfmon-0=SQLProg/Perfmon/System
SQLProg-type=string
SQLProg-count=15
SQLProg-0=SQLProg/SQLServr
SQLProg-1=SQLProg/UpgTools
SQLProg-2=SQLProg/ReplSupp
SQLProg-3=SQLProg/Install
SQLProg-4=SQLProg/System
SQLProg-5=SQLProg/SvrExt
SQLProg-6=SQLProg/Dat
SQLProg-7=SQLProg/DatSmpl
SQLProg-8=SQLProg/BaseSys
SQLProg-9=SQLProg/BaseBinn
SQLProg-10=SQLProg/MSSearch
SQLProg-11=SQLProg/BaseInst
SQLProg-12=SQLProg/Symbols
SQLProg-13=SQLProg/Perfmon
SQLProg-14=SQLProg/Root
MgtTool/SEM/ActiveX-type=string
MgtTool/SEM/ActiveX-count=2
MgtTool/SEM/ActiveX-0=MgtTool/SEM/ActiveX/Res1033
MgtTool/SEM/ActiveX-1=MgtTool/SEM/ActiveX/ResIntl
MgtTool/SEM/Office-type=string
MgtTool/SEM/Office-count=2
MgtTool/SEM/Office-0=MgtTool/SEM/Office/Res1033
MgtTool/SEM/Office-1=MgtTool/SEM/Office/ResIntl
MgtTool/SEM-type=string
MgtTool/SEM-count=12
MgtTool/SEM-0=MgtTool/SEM/HTML
MgtTool/SEM-1=MgtTool/SEM/MSD98
MgtTool/SEM-2=MgtTool/SEM/MSD98SYS
MgtTool/SEM-3=MgtTool/SEM/MSD98Res
MgtTool/SEM-4=MgtTool/SEM/MSD98Hlp
MgtTool/SEM-5=MgtTool/SEM/Help
MgtTool/SEM-6=MgtTool/SEM/Res1033
MgtTool/SEM-7=MgtTool/SEM/ResIntl
MgtTool/SEM-8=MgtTool/SEM/MSD98RsI
MgtTool/SEM-9=MgtTool/SEM/ActiveX
MgtTool/SEM-10=MgtTool/SEM/Office
MgtTool/SEM-11=MgtTool/SEM/Scripts
MgtTool/Profiler-type=string
MgtTool/Profiler-count=3
MgtTool/Profiler-0=MgtTool/Profiler/Help
MgtTool/Profiler-1=MgtTool/Profiler/Res1033
MgtTool/Profiler-2=MgtTool/Profiler/ResIntl
MgtTool/Qryanlz-type=string
MgtTool/Qryanlz-count=3
MgtTool/Qryanlz-0=MgtTool/Qryanlz/Help
MgtTool/Qryanlz-1=MgtTool/Qryanlz/Res1033
MgtTool/Qryanlz-2=MgtTool/Qryanlz/ResIntl
MgtTool/Wzcnflct-type=string
MgtTool/Wzcnflct-count=4
MgtTool/Wzcnflct-0=MgtTool/Wzcnflct/WzcnHlp
MgtTool/Wzcnflct-1=MgtTool/Wzcnflct/Wzcn1033
MgtTool/Wzcnflct-2=MgtTool/Wzcnflct/WzcnOthr
MgtTool/Wzcnflct-3=MgtTool/Wzcnflct/WzcnCmn
MgtTool-type=string
MgtTool-count=7
MgtTool-0=MgtTool/SEM
MgtTool-1=MgtTool/Profiler
MgtTool-2=MgtTool/Qryanlz
MgtTool-3=MgtTool/DTCCLi
MgtTool-4=MgtTool/Wzcnflct
MgtTool-5=MgtTool/UtilSys
MgtTool-6=MgtTool/UtilBinn
Connect-type=string
Connect-count=3
Connect-0=Connect/ConnSys
Connect-1=Connect/Conn9x
Connect-2=Connect/ConnNT
Books/Bookso-type=string
Books/Bookso-count=1
Books/Bookso-0=Books/Bookso/Utils
Books/BooksCD-type=string
Books/BooksCD-count=1
Books/BooksCD-0=Books/BooksCD/Utils
Books-type=string
Books-count=2
Books-0=Books/Bookso
Books-1=Books/BooksCD
DevTools/Dbg Int-type=string
DevTools/Dbg Int-count=2
DevTools/Dbg Int-0=DevTools/Dbg Int/Dbg Int Common
DevTools/Dbg Int-1=DevTools/Dbg Int/EXE
DevTools-type=string
DevTools-count=1
DevTools-0=DevTools/Dbg Int
CoreRepl-type=string
CoreRepl-count=2
CoreRepl-0=CoreRepl/Res1033
CoreRepl-1=CoreRepl/ResIntl
Core-type=string
Core-count=2
Core-0=Core/Res1033
Core-1=Core/ResOther
Repostry-type=string
Repostry-count=3
Repostry-0=Repostry/RepstSys
Repostry-1=Repostry/Res1033
Repostry-2=Repostry/ResIntl
CoreMisc/ActiveX-type=string
CoreMisc/ActiveX-count=2
CoreMisc/ActiveX-0=CoreMisc/ActiveX/Res1033
CoreMisc/ActiveX-1=CoreMisc/ActiveX/ResIntl
CoreMisc-type=string
CoreMisc-count=2
CoreMisc-0=CoreMisc/ActiveX
CoreMisc-1=CoreMisc/Res1033
Monarch-type=string
Monarch-count=2
Monarch-0=Monarch/Monr1033
Monarch-1=Monarch/MonrIntl
Jet-type=string
Jet-count=1
Jet-0=Jet/Sort
CoreCOM-type=string
CoreCOM-count=2
CoreCOM-0=CoreCOM/Res1033
CoreCOM-1=CoreCOM/ResIntl
CoreTool-type=string
CoreTool-count=2
CoreTool-0=CoreTool/Res1033
CoreTool-1=CoreTool/ResOther
SFExt/ActiveX-type=string
SFExt/ActiveX-count=2
SFExt/ActiveX-0=SFExt/ActiveX/Res1033
SFExt/ActiveX-1=SFExt/ActiveX/ResIntl
SFExt-type=string
SFExt-count=3
SFExt-0=SFExt/ActiveX
SFExt-1=SFExt/Res1033
SFExt-2=SFExt/ResIntl
Trace-type=string
Trace-count=2
Trace-0=Trace/Res1033
Trace-1=Trace/ResOther
MC-type=string
MC-count=3
MC-0=MC/MC1033
MC-1=MC/MCIntl
MC-2=MC/Help
SQLMgr-type=string
SQLMgr-count=2
SQLMgr-0=SQLMgr/Res1033
SQLMgr-1=SQLMgr/ResIntl
SvrTool-type=string
SvrTool-count=2
SvrTool-0=SvrTool/Res1033
SvrTool-1=SvrTool/ResIntl
DTSUI-type=string
DTSUI-count=2
DTSUI-0=DTSUI/Res1033
DTSUI-1=DTSUI/ResIntl
MSOlap-type=string
MSOlap-count=2
MSOlap-0=MSOlap/Res1033
MSOlap-1=MSOlap/ResIntl
ATL-type=string
ATL-count=2
ATL-0=ATL/winnt
ATL-1=ATL/win9x
Component-type=string
Component-count=28
Component-0=SQLProg
Component-1=MgtTool
Component-2=Connect
Component-3=Books
Component-4=DevTools
Component-5=CoreRepl
Component-6=Core
Component-7=Repostry
Component-8=CoreMisc
Component-9=Monarch
Component-10=Jet
Component-11=CoreInst
Component-12=CoreCOM
Component-13=CoreTool
Component-14=DBLibCli
Component-15=SFExt
Component-16=Trace
Component-17=MiscCore
Component-18=MC
Component-19=SQLMgr
Component-20=SvrTool
Component-21=DTSUI
Component-22=MSOlap
Component-23=ATL
Component-24=MFC42U
Component-25=VC
Component-26=VB
Component-27=OCX1
Result=1