如何使用sql server环境制作exe文件 [英] how to make an exe with sql server environment

问题描述

我制作了一个窗口应用程序，在其中我将前端用作C#，将后端用作sql server 2008 R2.
现在，我想制作一个应该附加数据库的exe文件，如果我将其安装在另一个系统上，则无需安装sql server.可能吗?如果是，那怎么办?

谢谢！!!

I make a window application where i used front end as C# and back end as sql server 2008 R2.
Now i want to make an exe in which database should be attached and If i install it another system then there is no need to install sql server. Is it possible? if yes then how?

Thank You !!

推荐答案

不适用于SQL Server数据库，不可以.

您可以使用某些数据库-但是您通常会丢失任何多用户组件，每个用户都必须拥有数据库的单独副本，并且彼此之间无需共享数据.对于某些应用程序，这是可以的，例如，当您有效地将数据库用作结构化的本地数据存储时.对于其他人则不是.

以这种方式处理的最简单的可能是SQLCE和SQLite，它们都不需要安装服务器.上面是Access，然后您就可以进入安装某种服务器"领域了.

使用基于非服务器的解决方案可能还会有其他限制，但是它们将取决于您要使用的解决方案.

Not with SQL Server databases, no.

You can with some DB''s though - but you will generally lose any multiuser component, with each user having to have a separate copy of the database and with no data being shared between them. For some applications this is ok, such as when you are effectively using the database as a structured local data store. For others it isn''t.

The easiest ones to handle in this manner are probably SQLCE and SQLite, both of which require no server to be installed. Above that is Access, and then you are pretty much into the "install a server of some kind" territory.

There may be other limitations with using a non-server based solution, but they will depend on which solution you go for.

您需要创建两个单独的安装程序.一个用于客户端，另一个用于服务器.

在客户端安装程序中，您需要安装C#应用程序并更新ConnectionString.

从服务器安装程序中，您需要安装SQL Server并在其中安装数据库.

这是完成工作的简单方法.

希望这些信息对您有帮助，

谢谢
-Amit Gajjar.

Hi,

You need to create two separate installer. one for Client and another for Server.

From Client installer you need to install your C# application and to update your ConnectionString.

From Server installer you need to install SQL Server and install database in it.

This is the simple way of your work get done.

Hope this information helps you,

Thanks
-Amit Gajjar.

这篇关于如何使用sql server环境制作exe文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！