Windows应用程序与sql server的部署 [英] windows applications deployment with sql server

问题描述

大家好:) :)

我已经用C#开发了一个Windows应用程序，并使用SQL Server 2008作为数据库，现在我为该应用程序部署并创建了一个.exe，现在我的问题是要在目标系统中安装它，是否必须在目标系统中安装SQL Server?还是不?

在此先感谢
Phanindra:)

解决方案

您不需要在计算机上安装SQL Server只是为了提供SQL连接...已安装了连接到SQL Server所需的驱动程序作为框架的一部分.

如果目标计算机已连接到网络或可以看到"已安装SQL Server的计算机，则只需更改连接字符串以指向SQL Server实例即可.

然后，您将客户端(运行程序的计算机)连接到服务器(运行SQL Server的计算机)，这是需要数据库访问的应用程序的经典设计


但是，如果您没有运行SQL Server的服务器\共享计算机，并且想在连接字符串中使用(localhost)，那么您将需要在目标计算机上安装SQL

Hi to all :) :)

I have developed a windows application in C# and used SQL Server 2008 as DB and now i deployed and created a .exe for that application , now my question is that to install it in target system , does the target system must be instlled with SQL Server or not?

Thanks in Advance
Phanindra :)

解决方案

You don''t need SQL Server installed on the machine just to provide SQL connectivity...the drivers required to connect to SQL Server are installed as part of the framework.

If the target machine is connected to a network or can ''see'' the machine that has SQL server installed, then just change the connection string to point at the SQL server instance

You then have a client (the machine running the program) connected to a server (machine running SQL Server), which is a classic design for application requiring database access


However, if you don''t have a server \ shared machine running SQL Server and you want to use (localhost) in your connection string, then you will need SQL installed on the target machine

这篇关于Windows应用程序与sql server的部署的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！