问题用installaware安装sql server [英] question install sql server with installaware

问题描述

我有一个问题，我有一个使用SQL数据库的vb net项目，我可以部署项目，还可以使用Project在一个软件包中使用的表来部署SQL Server Express，而不是手动安装SQL Server，例如installaware？



谢谢

Kyriakos

I have a question, I have a vb net Project which uses SQL database, can I deploy the Project but also SQL Server Express with tables which Project uses in one package and not install SQL Server manually, with something like installaware?

Thank you
Kyriakos

推荐答案

基本上你可以包括安装数据库服务器到您的应用程序安装。例如，您可以使用配置文件进行安装，并包括在应用程序设置中运行静默安装。查看使用配置文件安装SQL Server 2016 [ ^ ]



但是，在做这几件事之前，您应该考虑在安装应用程序时是否始终安装数据库服务器。



通常，数据库服务器只安装一次，多个客户端使用相同的数据库。在这种环境中，包括安装到您的应用程序安装是没有意义的。



另一件事是目标站点可能已经安装了服务器并且他们想要使用现有的安装，再次安装新的服务器不是一件好事。



第三件事是，如果数据库是随软件一起安装的，那就是单个用户场景，那么Express可能不是正确的版本。 Compact通常用于这种情况，并且不需要任何单独的安装。

Basically you could include the installation of the database server to your application installation. You can for example use a configuration file for the installation and include running a silent installation to your app setup. Have a look at Install SQL Server 2016 Using a Configuration File[^]

However, before doing that few thing you should consider if the database server is always installed when the application is installed.

Typically the database server is installed only once and the same database is used by multiple clients. In this kind of environment including the installation to your application installation would not make sense.

Another thing is that the target site may already have a server installed and they want to use the existing installation, again installing a new server wouldn't be a good thing.

And the third thing is that if the database is installed with the software and it's a single user scenario, then perhaps Express is not the correct edition. Compact is often used in such scenarios and it does not require any separate installation.

这篇关于问题用installaware安装sql server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！