如何使用我的应用程序安装SQL SERVER作为先决条件？ [英] How to install SQL SERVER as prerequisite with my application?
问题描述
我知道这个问题在这个伟大的网站上无限次问，但我仍然感到困惑，需要一个适当的指导。
我有一个vb项目使用sql server 2008 r2
现在我想发布我的项目安装项目和以下需要在客户使用它之前完成。
1.我想安装SQL作为先决条件
2.安装将在应用程序安装期间完成。
3.无提示安装。
4.将检查sql实例
5.修改现有或继续安装。
7.如果发生任何错误，需要绕过或跳过。
6.预先配置TCP IP并启用所有必需的协议
7.附加数据库或sql脚本来创建表。
8.安装应用程序。
我尝试过： < br $>
试图打开一个安装项目，但从未安装或永远不会启用tcp ip。有时这个应用程序无法安装在此系统上收到的错误。
I know this question asked infinite times in this great site but Im still confused and need a proper guide.
I have a vb project uses sql server 2008 r2
Now I want to publish my project with setup project and following needs to be done before client using it.
1. I want to install SQL as prerequisites
2. Installation will be done during application installation.
3. Silent installation.
4. Will check for sql instances
5. modify existing or continue installation.
7. If any error occurs needs to bypass or skip.
6. Preconfigured with TCP IP and all required protocols enabled
7. attach database or sql scripts to create tables.
8. install application.
What I have tried:
Tried to open a setup project but never installs or never get tcp ip enabled. Some times this application cannot be installed on this system error recieved.
推荐答案
静默安装在从命令提示符安装SQL Server Microsoft Docs [ ^ ]
但是，通常SQL服务器是单独安装的对于单个应用程序，在公司网络上只能运行一次。这样，不同的客户端共享相同的数据。
如果应用程序使用独立数据，那么使用SQL Compact（CE）可能是正确的版本。此版本通常用作单个应用程序的独立数据库，不需要实际安装，但可以嵌入到应用程序设置中。
Silent installation is explained in Install SQL Server from the Command Prompt | Microsoft Docs[^]
However, typically SQL server is installed separately for a single application, only once on a company network. This way different clients share the same data.
If the application uses stand-alone data then using SQL Compact (CE) might be the correct edition. This edition is typically used as a stand-alone database for a single application and does not require actual installation but can be embedded into the application setup.
这篇关于如何使用我的应用程序安装SQL SERVER作为先决条件？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
