使用SQL数据库快速部署Visual Studio 2010应用程序 [英] Quick deployment of Visual Studio 2010 app with SQL database

问题描述

我是Visual Studio 2010的新手，所以请跟我一起。回到使用VB6结合Access数据库的日子，我所要做的就是使用Package&部署向导并在安装程序中包含数据库文件。那么所有的客户端都要做的就是运行一个安装文件，应用程序会马上运行（数据库将被放置在应用程序路径中）。

I am new to Visual Studio 2010, so please bear with me. Back in the days of using VB6 combined with an Access database, all I had to do was to use the Package & Deployment wizard and include the database file in the setup. Then all the client had to do was run one setup file and the application would magically run right away (the database would be placed in the App Path).

是否有一些在VS 2010中创建一个安装文件的方式，它还将自动安装SQL Server Express，将数据库与应用程序本身一起附加？

Is there some way to create a setup file in VS 2010 which will also install SQL Server Express automatically, attach the database along with the application itself?

这是为不适用于安装了SQL Server，他们应该可以通过运行一个单一的安装程序来开始使用该应用程序。

This is meant for people who do not have SQL server installed and they should be able to start using the app by running one single setup.

谢谢！

推荐答案

是的，您的基于Windows Installer的安装程序并使用Visual Studio本身构建可以部署您需要的所有内容。阅读这个 MSDN上的文章更多细节（也许您不需要ClickOnce，但它包含很多链接）。

Yes, your setup based on Windows Installer and built with Visual Studio itself can deploy everything you need. Read this article on MSDN for more details (maybe you won't need ClickOnce but it contains a lot of links).

我猜测你需要关于你的选项的一些澄清（我假设你想使用一个Microsoft解决方案，因为你谈到了SQLExpress）。

I guess you need some clarification about your options (I assume you want to use a Microsoft solution because you talked about SQLExpress).

• Microsoft SQL Server ：全功能数据库引擎。它的成本（很多）和部署并不容易，因为我们会。


• Microsoft SQL Server Express：大哥的免费版（有一些限制）。相同的安装问题。适用于中等桌面或网络应用程序。


• Microsoft LocalDB：单个或多个文件，单个用户，对存储过程的支持和高级数据类型，如更高版本，易于部署和（可选）每用户执行。


• Microsoft SQL Server Compact 4.0：单个文件，单个用户，小型，正在进行中，非常简单，适用于小型/中型桌面应用程序和开发（具有Web应用程序的一些前提条件）部署。适用于小型单用户应用程序或用作本地数据存储（VS2k10 C ++ Intellisense，例如，使用SQLCE DB）。


• Microsoft JET引擎：旧的受欢迎的访问。如果你来自VB6，我想你知道这一点。

• Microsoft SQL Server: fully featured database engine. It costs (a lot) and deployment isn't easy as we would.
• Microsoft SQL Server Express: free edition (with some limits) of the big brother. Same installation issues. Perfect for medium desktop or web applications.
• Microsoft LocalDB: single or multiple file, single user, support for stored procedures and advanced data types as in higher versions, easy to deploy and (optionally) per-user execution. Perfect for small/medium desktop applications and developing (with some preconditions with web applications too).
• Microsoft SQL Server Compact 4.0: single file, single user, small, in-process, very easy to deploy. Perfect for small single user applications or used as local data storage (VS2k10 C++ Intellisense, for example, uses a SQLCE DB).
• Microsoft JET Engine: the old beloved Access. If you come from VB6 I guess you know this.

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