分发基于SQL Server的应用程序的策略 [英] Strategies for distributing SQL-server-based application

问题描述

我已经基于SSCE在vb.net中编写了一个应用程序.现在，我需要转移SQL Server Express，因为我需要在共享(LAN)上运行该应用程序，并且多个用户需要同时访问数据库.
我绝对是SQL Server的新手.我需要了解以下内容:

1)我是否通过在VS 2008中添加新项来创建SQL Server数据库?还是只需要在SQL Server mgmt Express中创建它们?

2)如何分配这些数据库，就像SSCE数据库一样?

3)是否可以像在共享中使用Access DB一样使用这些数据库(只需放在共享文件夹中)?

4)如果对问题3否定，那么如何设置连接字符串，因为我不知道将安装我的应用程序的用户的计算机名称.

谢谢

Hi,
I have written an application in vb.net, based on SSCE. Now I need to shift in SQL Server Express because I need to run the application on Sharing (LAN) and several users need to access the database at the same time.
I am absolutely new to SQL Server. I need to know the following:

1) Do I create SQL Server DB by Adding New Item in my VS 2008? or they need to be created in SQL Server mgmt Express ONLY?

2) How do I distribute these database, same way like SSCE databses?

3) Can these databases be used like we use Access DBs in sharing (just put in the shared folder)?

4) If no to Question 3, how to set the connection string as I donot know the name of computer of the user who will install my application.

Thanks

推荐答案

1)找到一台中央计算机/服务器，它将作为数据库的基础.
2)将SQL Server实例安装到步骤1中确定的服务器上. 3)将您希望在应用程序之间共享的数据库安装到步骤2中创建的数据库实例中. 4)确保在应用程序中正确配置了连接字符串.
5)继续分发您的应用程序.如果客户端可以访问服务器，那么您就可以了.

当您继续在多个用户之间共享数据库时，我建议您使用数据库实例而不是共享文件(类似于Access).

1) Find a central computer/server which will act as a base for the database.
2) Install a SQL Server instance onto the server identified in step 1.
3) Install the database you wish to share among the applications into the DB instance created in step 2.
4) Make sure your connection strings are correctly configured in your appliation.
5) Go ahead and distribute your application. If the clients have access to the server then you should be ok.

The moment you go ahead and share a database between multiple users, I would suggest using a database instance and not a shared file (Access-like).

正如Marcus所指出的.

为了强调安全性考虑，用户不必知道数据库文件所在的位置，只要能够连接到SQL Server服务即可.

另外，您可能会发现有用的一些链接:
-安装SQL Server 2008 [ ^ ]
-如何:安装SQL Server 2008 R2(安装程序) [配置SQL Server 2008 R2 [保护SQL Server [备份概述 [

Exactly as Marcus pointed out.

To emphasis the security concerns, no user has to know where the database file reside, just to be able to connect to the SQL Server service.

Also few links you may find useful:
- Installing SQL Server 2008[^]
- How to: Install SQL Server 2008 R2 (Setup)[^]
- Configuring SQL Server 2008 R2[^]

And as you now have (almost) the full capabilities of the SQL Server in your hand, also have a look at these:
- Securing SQL Server[^]
- Backup Overview[^]

这篇关于分发基于SQL Server的应用程序的策略的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！