使用Sql数据库作为VB.Net应用程序的附加数据库 [英] Using Sql Database as Attached Database for a VB.Net Application

问题描述

使用sql数据库作为项目的附加数据库还是将其作为sql服务器中的数据库添加是很好......


我已经在vb.net中使用Sql Server 2008数据库开发了一个应用程序...

现在，在我发布应用程序之后，我应该如何将sql数据源添加到客户端计算机，或者只是我应该将数据库作为附加数据库添加到项目中...


但是有人告诉我，当数据库的大小超出一定限制时，不支持将Sql数据库添加为附加数据库.是这样吗?

另外，我应该如何在项目s0中添加代码，以便在用户安装应用程序时，也应该在客户端sql服务器中创建sql数据库...

Is it good to use sql database as attached database for a project or to add that as a database in sql server...


I had developed a application in vb.net with Sql Server 2008 database...

Now after i have published the application how should i add the sql datasource to the client machine or just i should add the database as a attached database in the project...


But some one told me that adding a Sql Database as a attached database doesnot support when the size of the database increases beyond certain limit.. Is it so?

Else how should i add a code in my project s0 that when user install the application, the sql database should also be created in the client sql server...

推荐答案

这取决于您在做什么-没有答案.

如果希望该数据库由单个用户使用，而不与其他用户共享，则使用本地存储的数据库，可能是Access，SqlCE或SqlLite.

如果希望共享数据，则将其用作SQL数据库，并在安装产品时在sql服务器实例中创建它.这里需要执行所有步骤: http://techbrij.com /145/install-sql-server-database-with-visual-studio-setup [

It depends on what you are doing - there is no one answer.

If you are expecting the database to be used by a single user, with no sharing to others, then use a locally stored database, maybe Access, SqlCE or SqlLite.

If you expect the data to be shared, then use it as an SQL database, and create it in the sql server instance when you install the product. There is a run through of the steps needed here: http://techbrij.com/145/install-sql-server-database-with-visual-studio-setup[^] - it''s not terribly well written, but it should work.

The one thing you should not do, is include any form of SQL server installation with your software!

这篇关于使用Sql数据库作为VB.Net应用程序的附加数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！