使用桌面应用程序部署SQL Server Express数据库？ [英] deploy SQL Server Express database with desktop app?

问题描述

我已经在.NET中创建了第一个基于数据库的桌面应用程序，无法了解如何使用应用程序安装程序部署数据库，以便数据库，应用程序和SQL Server一次性安装。 p>

如果我仅使用安装程序部署SQL Server的本机客户端和数据库，它会工作吗？

应用程序非常频繁地使用数据库。

解决方案

如果要使用它，您需要安装SQL Express引擎。仅部署客户端连接将为您提供客户端连接名称所暗示的内容：您将能够连接到SQL Server。但是只有正在运行的SQL Server实例才能读/写你的应用程序数据库。

SQL Express安装MSI实际上是非常可定制，并允许许多方案，包括无人值守的安装和远程部署。有关最基本的选项，请参阅在安装期间配置SQL Express 。您的应用程序安装程序将必须调用Express安装程序，传递所需的参数。

I've created my first database based desktop app in .NET and not able to understand how can I deploy the database with the application installer, so that the database, application and the SQL Server is installed in one go.

If I only deploy the native client for SQL Server and the database with the installer, will it work?

The application uses the database very frequently.

解决方案

You need to install the SQL Express engine if you want to use it. Deploying only the client connectivity will give you exactly what the 'client connectivity' name implies: you'll be able to connect to a SQL Server. But only a running SQL Server instance will be able to read/write your application database.

The SQL Express install MSI is actually very customizable and allows for a lot of scenarios, including unattended setup and remote deployment. For the most basic options, see Configuring SQL Express During Installation. Your application installer will have to invoke the Express installer passing in the desired parameters.

这篇关于使用桌面应用程序部署SQL Server Express数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！