如何使用SQL Server部署VB.NET winform应用程序并使其可用于其他PC [英] How to deploy VB.NET winform application with SQL server and make it usable on other pcs

问题描述

我开发了一个链接到SQL SERVER数据库的winform应用程序。我想部署这个项目，以便我可以给朋友安装在他们的计算机上使用。



示例：就像我可以使用其他应用程序，如MS-WORD和更多。



非常欢迎视频，手册和演示。



提前致谢。



项目应采用标准格式。



请允许我在星期天为此辩护



我的尝试：



我不知道。我尝试过的都没有用。那是试图发布

I have developed a winform application linked to an SQL SERVER database. I want to deploy this project so that I can give friends to install for use on their computers.

Example: Just as I can use other app like MS-WORD and more.

Video, handbook and demonstrations are highly welcome.

Thanks in advance.

The project should be in a standard format.

Pls, I need to defend this on Sunday

What I have tried:

I have no idea. All I've tried did not work. That's trying to publish

推荐答案

SQL服务器旨在由多个用户共享。因此，您需要在所有用户都可以访问的系统上安装SQL Server实例。然后，您只需将应用程序及其先决条件发布到每个用户的PC。谷歌会发现很多关于这个主题的文章。

SQL server is designed to be shared by multiple users. So you need to install the SQL Server instance on a system that is accessible to all the users. You then just need to publish the application, and its prerequisites, to each user's PC. Google will find many articles on the subject.

正如理查德所说，SQL Server旨在作为一个多用户数据库，这意味着它是基于服务器的，是一个重量级的安装，需要知识和努力安装和维护正确。您不应该考虑在任何系统上为您的用户安装SQL Server，因为它首先消除了使用多用户数据库的所有优势！



如果您只期望单个用户，然后不使用SQL服务器 - 使用SQLite，Sql Compact，甚至是Access - 它们除了需要的DLL文件之外，不需要添加任何重要的yoru安装程序。您的应用程序的更改（如果写得好）应该相对简单，以支持它。

As Richard says, SQL Server is intended as a multiuser database, which means it is server based and a heavyweight installation which takes knowledge and effort to both install and maintain properly. You should not consider installing SQL Server on any system for your users as that removes all the advantages of using a multiuser DB in the first place!

If you are expecting only a single user, then don't use SQL server - use SQLite, Sql Compact, or even Access instead - they require nothing significant to be added to yoru instal program other than the required DLL files. The changes to your app (if it was written well) should be relatively trivial to support it.

这篇关于如何使用SQL Server部署VB.NET winform应用程序并使其可用于其他PC的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！