有必要在客户端系统上安装sql server management studio以进行wpf applcation [英] it's necessary to install sql server management studio on Client system for wpf applcation
问题描述
我是窗口应用程序的新手，所以我不知道在系统上安装setup（.exe）文件。
这里，我用sql创建一个应用程序数据库，它完全安装在客户端系统上，但我不知道如何进行设置（.exe）以及如何使用它的数据库。
有必要在客户端计算机上安装sql server management studio系统
任何人请帮帮我.......
i Am new for window application so i have no idea for installation of setup(.exe) file on system.
here, i make a application using sql database and it's Complete to install on client system but i don't Know how to make setup(.exe) and how can i use it's database.
it's necessary to Install sql server management studio on client computer system
any one please help me .......
推荐答案
如果您正在使用在您的应用程序中的SQL Server，然后客户端计算机必须能够看到SQL Server的实例，以便您的应用程序工作。
但是......
您不应在安装中包含SQL Server。有几个原因：
0）您只能出于版权原因分发SQL Server Express - 而不是SQL Server完整版。
1）他们可能已经拥有SQL Server安装在网络上。如果是这样，那么他们可能会想要使用该版本。
2）如果他们确实安装了SQL服务器并且你开始扩散SQL服务器Express实例，那么你将会惹恼数据库管理员...
3）SQl Server的单站点安装比用户控制下的一些分散版本更有可能被备份。
4）对于普通用户来说，安装和管理Sql服务器非常复杂 - 这不是一个好主意！
5）它将破坏使用Sql Server而不是SqlCE或SQLite的主要优势 - 多用户访问。如果每个人都安装了自己的SQL服务器副本，那么您将拥有数据库的多个副本，每个副本由一个人使用。这会引起一些混乱，并且（取决于你如何编写原始数据库）在实现问题时可能需要付出相当大的努力才能组合成单个实例。
SQL服务器的优势几乎总是只在多用户应用程序中：如果您的应用程序不需要与其他用户共享数据库，那么您应该考虑更改软件以使用更简单的单用户数据库，例如SQLCE，SqLite或Access - 这些都不需要复杂的服务器安装（只需要几个简单的DLL文件，app安装程序可以将这些文件作为正常安装的一部分添加）。
If you are using SQL Server in your application, then the client computer must be able to see an instance of SQL Server in order for your app to work.
But...
You should not include SQL Server in your installation. There are a couple of reasons:
0) You can only distribute SQL Server Express for copyright reasons - not SQL Server full version.
1) They may already have SQL Server installed on the network. If so, then they will presumably want to use that version.
2) If they do have SQL server installed and you start proliferating SQL server Express instances, you are going to annoy the heck out of the database administrator...
3) A single site installation of SQl Server is a lot more likely to be backed up than a number of scattered version under user control.
4) Sql server is quite complex for a "normal" user to install and administer - it is not a good idea!
5) It will destroy the primary advantage of using Sql Server over SqlCE or SQLite - multiuser access. If everyone installs their own copy of SQL server, then you will have multiple copies of your database, each used by a single person. This will cause some confusion, and (depending on how you wrote the original database) may take some considerable effort to combine into a single instance when the problem is realized.
The advantage of SQL server is almost always only in multiuser applications: if your application does not need to share it's database with other users then you should consider changing your software to use a simpler, single user database such as SQLCE, SqLite, or Access - none of which need a complicated server installation (just a couple of simple DLL files which the app installer can add as part of "normal" installation).
有必要在客户端计算机系统上安装sql server management studio
it's necessary to Install sql server management studio on client computer system
如果客户端想在sql上直接浏览或运行sql语句数据库然后你可能需要sql管理工作室，否则不需要。
if client want to brows or run sql statements directly on sql database then you may need sql management studio, otherwise no need.
这篇关于有必要在客户端系统上安装sql server management studio以进行wpf applcation的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
