如何正确部署一个SQL Server实例以在多个客户端上创建应用程序？ [英] How Do I Properly Deploy One SQL Server Instance Tied To Winforms Application On Multiple Clients?

问题描述

我是一名学生正致力于一个宠物项目，以改进win表格，c＃和MSSQL。



应用程序的想法是针对SQL Server的一个实例Express将托管在Windows Server 2008计算机上，客户端在其计算机上安装应用程序，并能够使用它更新服务器上托管的数据库。



现在，到目前为止，我已经使用VS 2008和SQL Express在我的机器上进行了工作，它工作正常，现在想在服务器上部署数据库。但是我缺乏这样做的经验，因为我以前工作过的以前的项目都有本地数据库复制捆绑包和安装文件。



现在剩下的就是;

a）从我的本地机器创建/传输本地存储的SQL Server（Express）实例服务器。



b）使用我建立的Windows窗体应用程序，通过建议的连接，即LAN或远程连接，让客户端机器能够访问数据库。



有人可以指点如何实现这一目标或链接到足以涵盖主题的文章吗？



提前谢谢。

I am a student working on a pet project to improve on win forms, c# and MSSQL.

The idea for the application is for an instance of SQL Server Express to be hosted on a Windows Server 2008 machine with clients installing the application on their machines and being able to update the database hosted on the server using it.

Now, I've worked on it on my machine thus far using VS 2008 and SQL Express, it works fine and would now like to deploy the database on the server. But I lack the experience to do so as previous projects I've worked on in the past had local DB copies bundles with the install file.

Now what remains is to;
a)Create/transfer the locally stored instance of the SQL Server(Express) from my local machine to the server.

b)Give client machines the ability to access the db via the recommended connection i.e LAN or remote connection using the windows forms application I have built.

Can someone please give pointers on how to achieve this or give links to articles which adequately cover the subject matter?

Thanks in advance.

推荐答案

嗯，可以部署SQL Server或SQL Server Express。您甚至可以在应用程序中嵌入SQL Server Express：

http://social.technet.microsoft.com/wiki/contents/articles/940.how-to-embed-sql-server-express-in-an -application.aspx [ ^ ]，

http://technet.microsoft.com/en-us/library/bb264562%28v=sql.90%29.aspx [ ^ ]，

http://msdn.microsoft.com /en-us/library/aa983326%28v=vs.90%29.aspx [ ^ ]。



但是，在大多数情况下，更可行的解决方案只是声称数据库服务器产品，或某些兼容版本的一组兼容产品，先决条件。它可以容纳更多用户。某些用户可以拥有自己的某些兼容商业版许可证。他们可能（并且合理地）更喜欢重复使用它，而不是添加一些冗余软件。

-SA

Well, deployment of SQL Server or SQL Server Express is possible. You can even embed SQL Server Express in your application:
http://social.technet.microsoft.com/wiki/contents/articles/940.how-to-embed-sql-server-express-in-an-application.aspx[^],
http://technet.microsoft.com/en-us/library/bb264562%28v=sql.90%29.aspx[^],
http://msdn.microsoft.com/en-us/library/aa983326%28v=vs.90%29.aspx[^].

However, in most cases, more viable solution would be just claiming a database server product, or a set of compatible products of certain compatible versions, as the prerequisite. It can suite more users. Some users can have their own license for some compatible commercial version. They would probably (and reasonably) prefer reusing it, instead of adding some redundant software.

—SA

这篇关于如何正确部署一个SQL Server实例以在多个客户端上创建应用程序？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！