search
HomeDatabaseMysql TutorialInstallShield2008中集成安装SQLServerExpress2005的方法

1) SQL Server 2005的版本有哪些 如下是关于SQL Server的版本信息: NO SQL Server名称 RTM SP1 SP2 SP3 1 SQL Server 2008 10.00.1600.22 2 SQL Server 2005 9.0.1399 9.0.2047 9.0.3042 9.00.4035 3 SQL Server 2000 8.00.194 8.00.384 8.00.532 8.00.760 4

1) SQL Server 2005的版本有哪些
如下是关于SQL Server的版本信息:
NO SQL Server名称 RTM SP1 SP2 SP3
1 SQL Server 2008 10.00.1600.22
2 SQL Server 2005 9.0.1399 9.0.2047 9.0.3042 9.00.4035
3 SQL Server 2000 8.00.194 8.00.384 8.00.532 8.00.760
4 SQL Server 7.0 7.00.623 7.00.699 7.00.842 7.00.961

关于该版本号在注册表中的位置, 对于SQL Server 2005, 我们可以使用如下的方法来准确的获得类似上面的表格的版本号信息:
1) HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server/InstalledInstance
该键值的内容是所有的已安装的实例的名称, 类型是REG_MULTI_SZ, 就是一个字符串列表. 枚举其中的所有的实例名, 对每一个实例名, 执行如下步骤.
2) HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server/Instance Names/SQL
在该键值下, 以之前得到的实例名为键名, 得到一个字符串值, 该字符串就是该实例的ID.
3) 用第2步中取得的ID名, 组成如下的注册表路径:
HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server/ID/MSSQLServer/CurrentVersion
如果第2步中没有取得ID名, 则直接用实例名代入. 取该键下面的"CurrentVersion"字符串, 即可得到指定实例的版本号.

2) 如何在InstallShield中包含SQL Server 2005的安装
有两种方法可以将SQL Server的安装包包含进来:
1) 将安装文件打包到安装包的压缩文档中
2) 直接将安装文件放到安装包的Disk1目录下
第一种封装性更好一些, 不过加大了安装包启动时的解压缩时间.

步骤为:
1) 打开InstallShield 2008并载入工程文件
2) 在"Installation Designer"视图, 定位到"Behavior and Logic" -> "Support Files/Billboards" -> "Support Files" -> "Language Independent". 在右侧的文件列表中添加SQL Server的安装文件.

3) SQL Server 2005的安装包的命令行安装的式样是什么
SQL Server 2005允许无人值守的安装方式, 只要事先在配置文件中写好相应的内容即可:
[Options]
ADDLOCAL=SQL_Engine
INSTANCENAME=MyInstanceName
DISABLENETWORKPROTOCOLS=2
SECURITYMODE=SQL

将以上内容保存到如"sqlinstall.ini"文件中, 并与SQL Server的安装包一样放置到2)中所述的位置, 安装的时候通过如下的命令行, 将该配置文件传递给安装程序:
例如: SUPPORTDIR+SQLEXPR.exe "/q /qn /settings SUPPORTDIR+sqlinstall.ini";
其中, "SQLEXPR.exe"就是SQL Server 2005 Express SP2的安装包, "SUPPORTDIR"是InstallShield的宏, 即InstallShield的解压目录.


4) InstallShield中如何编写安装脚本
如下安装SQL Server时的脚本代码, 供参考.

// 构造安装命令行所要用到的一些变量
szPath = SUPPORTDIR;
LongPathToShortPath( szPath );

szApplication = szPath ^ SQL_INSTALL_EXE_FILEPATH;

szCommand = "/q /qn /settings " + szPath ^ SQL_INSTALL_INI;
szCommand = szCommand + " SAPWD=" + g_szSapwd;

// 显示"等待安装..."的提示信息
SdShowMsg( @LOC_AR_INSTALLING_SQL_SERVER, TRUE );
LaunchApplicationInit();
nResult = LaunchAppAndWait(szApplication, szCommand, WAIT);
if ( nResult // 安装程序运行失败,如果安装失败, 则提示用户是否需要显示SQL Server的Log文件. 该Log文件是由SQL Server安装程序生成的
SdShowMsg( @LOC_AR_INSTALLING_SQL_SERVER, FALSE );

// 询问是否打开Log文件
nResult = PmAskYesNo( szStringListOut, "", SEVERE );
if ( nResult = YES ) then
LaunchAppAndWait( "notepad.exe", SQL2005LOG, NOWAIT );
endif;
return FALSE;
endif;
SdShowMsg( @LOC_AR_INSTALLING_SQL_SERVER, FALSE ); // 关闭提示对话框

if (LAAW_PARAMETERS.nLaunchResult = 0) then
// 检查是否成功安装
if (ElExistInstance2(g_szInstance) != g_szInstance) then
// 询问是否打开Log文件
nResult = PmAskYesNo( szStringListOut, "", SEVERE );
if ( nResult = YES ) then
LaunchAppAndWait( "notepad.exe", SQL2005LOG, NOWAIT );
endif;
return FALSE;
else // 如果安装成功则创建数据库
if ( FALSE = CreateDB() ) then
PmMessageBox( "Create Database Failed!", "", SEVERE );
return FALSE;
endif;
endif;
else
nResult = PmAskYesNo( szStringListOut, "", SEVERE );
if ( nResult = YES ) then
LaunchAppAndWait( "notepad.exe", SQL2005LOG, NOWAIT );
endif;
return FALSE;
endif;

Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
How does MySQL handle data replication?How does MySQL handle data replication?Apr 28, 2025 am 12:25 AM

MySQL processes data replication through three modes: asynchronous, semi-synchronous and group replication. 1) Asynchronous replication performance is high but data may be lost. 2) Semi-synchronous replication improves data security but increases latency. 3) Group replication supports multi-master replication and failover, suitable for high availability requirements.

How can you use the EXPLAIN statement to analyze query performance?How can you use the EXPLAIN statement to analyze query performance?Apr 28, 2025 am 12:24 AM

The EXPLAIN statement can be used to analyze and improve SQL query performance. 1. Execute the EXPLAIN statement to view the query plan. 2. Analyze the output results, pay attention to access type, index usage and JOIN order. 3. Create or adjust indexes based on the analysis results, optimize JOIN operations, and avoid full table scanning to improve query efficiency.

How do you back up and restore a MySQL database?How do you back up and restore a MySQL database?Apr 28, 2025 am 12:23 AM

Using mysqldump for logical backup and MySQLEnterpriseBackup for hot backup are effective ways to back up MySQL databases. 1. Use mysqldump to back up the database: mysqldump-uroot-pmydatabase>mydatabase_backup.sql. 2. Use MySQLEnterpriseBackup for hot backup: mysqlbackup--user=root-password=password--backup-dir=/path/to/backupbackup. When recovering, use the corresponding life

What are some common causes of slow queries in MySQL?What are some common causes of slow queries in MySQL?Apr 28, 2025 am 12:18 AM

The main reasons for slow MySQL query include missing or improper use of indexes, query complexity, excessive data volume and insufficient hardware resources. Optimization suggestions include: 1. Create appropriate indexes; 2. Optimize query statements; 3. Use table partitioning technology; 4. Appropriately upgrade hardware.

What are views in MySQL?What are views in MySQL?Apr 28, 2025 am 12:04 AM

MySQL view is a virtual table based on SQL query results and does not store data. 1) Views simplify complex queries, 2) Enhance data security, and 3) Maintain data consistency. Views are stored queries in databases that can be used like tables, but data is generated dynamically.

What are the differences in syntax between MySQL and other SQL dialects?What are the differences in syntax between MySQL and other SQL dialects?Apr 27, 2025 am 12:26 AM

MySQLdiffersfromotherSQLdialectsinsyntaxforLIMIT,auto-increment,stringcomparison,subqueries,andperformanceanalysis.1)MySQLusesLIMIT,whileSQLServerusesTOPandOracleusesROWNUM.2)MySQL'sAUTO_INCREMENTcontrastswithPostgreSQL'sSERIALandOracle'ssequenceandt

What is MySQL partitioning?What is MySQL partitioning?Apr 27, 2025 am 12:23 AM

MySQL partitioning improves performance and simplifies maintenance. 1) Divide large tables into small pieces by specific criteria (such as date ranges), 2) physically divide data into independent files, 3) MySQL can focus on related partitions when querying, 4) Query optimizer can skip unrelated partitions, 5) Choosing the right partition strategy and maintaining it regularly is key.

How do you grant and revoke privileges in MySQL?How do you grant and revoke privileges in MySQL?Apr 27, 2025 am 12:21 AM

How to grant and revoke permissions in MySQL? 1. Use the GRANT statement to grant permissions, such as GRANTALLPRIVILEGESONdatabase_name.TO'username'@'host'; 2. Use the REVOKE statement to revoke permissions, such as REVOKEALLPRIVILEGESONdatabase_name.FROM'username'@'host' to ensure timely communication of permission changes.

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Safe Exam Browser

Safe Exam Browser

Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

mPDF

mPDF

mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Atom editor mac version download

Atom editor mac version download

The most popular open source editor