如何避免安装Service Pack? [英] How to avoid a service pack installation?

问题描述

我已经创建了一个单一设置，其中包含我的.net应用程序和在.net3.5框架中运行的数据库.
但是这里的问题是只有安装SQLExpress Service Pack才能执行我的应用程序，因此如何避免安装Service Pack(Service Pack的安装尺寸非常大，安装该应用程序需要很长时间)

您能否提出建议以避免长时间安装
Ambarish

I''ve create a single setup contain my .net application and database which runs in .net3.5 framework.
but here the problem is my application executes only if we install SQLExpress service pack so how to avoid this service pack installation(Service pack is very huge size setup and its taking long time to get the application installed)

Could you please give your suggestion to avoid this long time installation
Ambarish

推荐答案

如果在应用程序中使用MSSQL，则您的用户必须有权访问SQL Server才能使用它.但是，随应用程序安装一起发布SQL Express是不正常的-用户可能已经在现有计算机上安装了SQL Server.

如果这是一个单用户数据库系统，请考虑不使用SQL Server.如果改用SqlCE，则数据库代码包含在.NET框架中，因此不需要其他安装. SqlCE是MsSql的简化版本，仅适用于单个用户，不支持MsSql的某些更高级的功能.


这里我正在使用SQL Express 2005(.mdf)数据库.
当我同时安装SQlCE和.net应用程序时，我的应用程序显示错误错误已
建立与服务器的连接时发生.连接到sql server 2005时出现..error-26
定位指定的服务器/实例时出错"
请给我们建议"

我不确定您在此处尝试做什么:SQLCE不会打开.MDF数据库:如果您打算采用这种方法，则将其转换为SQLCE数据库.这里有一个实用程序可以做到:从SQL Server到SQL Server Compact Edition数据库复制实用程序 [ ^ ]

If you use MSSQL in your application, then your user must have access to SQL Server to use it. However, it is not normal to ship SQL Express with your app setup - the user may already have SQL Server installed on an existing computer.

If this is a single user database system, consider not using SQL Server. If you use SqlCE instead, the code for the database is included in the .NET framework so no additional installation is required. SqlCE is a cut down version of MsSql which is single user only, and does not support some of MsSql more advanced features.


"Here im using SQL Express 2005(.mdf)database.
When i Installed both SQlCE and my .net application and my application is showing an error "An error has
occured while establising a connnection to the server.when connecting to sql server 2005....error-26
error locating server/Instance specified"
Please give ur advice"

I''m not sure what you have tried to do here: SQLCE won''t open a .MDF database: convert it to an SQLCE database instead if you are going to go that route. There is a utility here to do that: SQL Server to SQL Server Compact Edition Database Copy Utility[^]

这篇关于如何避免安装Service Pack?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！