在我的应用程序中包含SQL Server 2008 Express的命名实例 [英] Including a named instance of SQL Server 2008 Express with my application
问题描述
我正在开发将要分发的应用程序收缩包装。我们已经拥有使用我们的应用程序分发SQL Server 2008 Express Edition的权限，但是如何做到这一点更困难。现在我们正在使用一个标准的Visual Studio安装项目，我显然希望能够很容易地完成一些可配置的合并模块，但显然没有这样的东西存在，或者我不会在这里发布;）
我已经开始下去的路是将自解压EXE与我们的软件包相结合，然后使用自定义安装操作来提取它，并将命令行参数传递给SQL安装程序，以创建我们的命名实例。这里是问题出现的地方。
提取没问题。我可以从Windows运行该脚本，并且按照它应该安装SQL Server，但是我无法从我的自定义操作运行SQL安装程序，因为它说已经有另一个安装进行中。这个其他的安装当然是我的应用程序，而且直到SQL Server完成后才会结束，所以我们基本上处于死锁状态，直到SQL终于放弃了错误。
我想要的是我的应用程序的SQL服务器的命名实例，它随它一起安装并被卸载。写我自己的安装程序不是一个选择，因为时间，我的同事说InstallShield不是一个选择，因为复杂性（我从来没有使用过，所以我会接受他的话）。有人有任何想法吗？
我将继续为自己的问题回答自己的问题，来自我已经能够告诉的一切的SO ...中的这种信息，只是不可能安装SQL Server的自定义实例（2008年，甚至2005年），链接到安装自定义软件，而不需要自定义引导程序或第三方安装程序产品（InstallShield等）的路。这听起来像SQL Server Compact版本可能更适合。
Good morning, all. This is my first question on stackoverflow, so hopefully this isn't something that's been beaten to death and I haven't been able to find it.
I'm developing an application that is going to be distributed shrinkwrapped. We have gotten the rights to distribute SQL Server 2008 Express Edition with our application, but exactly HOW to do this is a little more difficult. Right now we're using a standard Visual Studio setup project, and I was obviously hoping for something very easy, like a configurable merge module, but obviously no such thing exists or I wouldn't be posting here ;)
The road I had started going down was to include the self-extracting EXE with our package, then use a custom install action to extract it and pass command line arguments to the SQL installer to create our named instance. Here's where the problem comes in.
Extraction is fine. I can run the script from Windows and it installs SQL Server just as it should, but I can't run the SQL installer from my custom action because it's saying that there is already another installation in progress. This other installation is, of course, my application, and it isn't going to end until SQL Server finishes, so we're essentially at a deadlock until SQL finally gives up and errors out.
What I WANT is a named instance of SQL server for my application that is installed with it and gets uninstalled with it. Writing my own installer is not an option because of time, and my coworker says InstallShield is not an option because of complexity (I've never used it, so I'll take his word for it). Does anyone have any thoughts?
I'm going to go ahead and answer my own question for the sake of anyone else who comes looking for this sort of information on SO...from everything that I've been able to tell, it just isn't possible to install a custom instance of SQL Server (2008 anyway, and probably 2005) that is linked to the installation of custom software without going down the road of either a custom bootstrapper or a third-party installer product (InstallShield and the like). It sounds like SQL Server Compact edition might be better suited.
这篇关于在我的应用程序中包含SQL Server 2008 Express的命名实例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
