为什么选择SQL Express over Access？ [英] Why choose SQL Express over Access?

问题描述

为什么选择SQL Express（需要安装的应用程序才能使用b $ b工作）而不是依赖于Access数据库的简单性？

解决方案

嗯，我不确定你的意思是需要安装的应用程序

才能工作。我刚刚下载了它，运行了设置&有效。而且，由于您不愿意这样做，因此您只需要为数据库需要的* b $ b指定* * *，这很难回答您的问题。 />

所以，正如我所看到的那样，SQLExpress优于Access的优势。

1）它是免费的。

2）它与Sql Server直接兼容。

原因列表不完整 -


- SQL Express （或一般的SQL Server）将更好地扩展到多个

用户。

- 它会给你一个出路。当你的数据库超过4GB时

- 从DBA的角度来看，维护起来会更容易（集中

备份*。*）

- 它将为您提供更丰富的功能集 - 通知，SQLCLR，更好

T-SQL *。*

- 它将为您提供更好的性能（无需OleDb）

- 您不必经常压缩它

- 更好地支持数据类型/索引等等。

- 其他原因。


Access为您提供的唯一优势是基于文件的部署。而且坦率地说，无论如何，无论如何，无论如何，无处不在 - 无论如何，我在所有这些名称中的松散轨迹都会成为桌面应用的更好选择。


- Sahil Malik
http：//www.winsmarts。 com

" ljh" <那么** @ where.else>在消息中写道

新闻：kP ******************* @ bignews3.bellsouth.net。 ..

为什么选择SQL Express（需要安装的应用程序才能工作）而不是没有依赖关系的Access数据库的简单性？

我的意思是你可以使用你的应用程序包含.mdb文件

而使用SQL Server Express需要你

安装SQL Server Express并让它在后面运行。


如果我使用SQL Server Express并需要重新发布它

我的应用程序，是否有静音安装？


< ja ********** @ gmail.com>在留言中写道

news：11 ********************** @ u72g2000cwu.googlegr oups.com ...

嗯，我不确定你的意思是要求安装的应用程序工作。我刚刚下载了它，运行了设置&有效。并且，由于您不愿意这样做是您为数据库需求指定的* ONLY *要求，因此很难回答您的问题。

所以，正如我所看到的，SQLExpress优于Access的优势。
1）它是免费的。
2）它与Sql Server直接兼容。

Why would you choose SQL Express (which requires an installed application to
work) over the simplicity of an Access database which has no dependencies?

解决方案

Well, I''m not sure what you mean by "requires an installed application
to work". I just downloaded it, ran the setup & it worked. And, since
your reluctance to do that is the *ONLY* requirement you specify for
your database needs, it''s really hard to answer your question.

So, the advantages of SQLExpress over Access, as I see them.
1) It''s free.
2) It''s directly compatible with Sql Server.

Short incomplete list of reasons -

- SQL Express (or SQL Server in general) will scale better to multiple
users.
- It will give you a "way out" when your DB exceeds 4GB
- It will be easier to maintain from a DBA point of view (centralized
backups *.*)
- It will give you a much richer feature set - notification, SQLCLR, better
T-SQL*.*
- It will give you better performance (No OleDb necessary)
- You won''t have to compact it as often
- Better support for data types/indexes etc. etc.
- Other reasons.

The only advantage Access gives you is "File based deployment". And frankly
SQL Anywhere (or was it everywhere - I loose track in all these name
changes) should be a better choice for desktop-ish applications anyway.

- Sahil Malik
http://www.winsmarts.com
"ljh" <So**@where.else> wrote in message
news:kP*******************@bignews3.bellsouth.net. ..

Why would you choose SQL Express (which requires an installed application
to work) over the simplicity of an Access database which has no
dependencies?

I mean that you can use Access databases simply by including the .mdb files
with your application, whereas using SQL Server Express requires that you
install SQL Server Express and have it running in the backgound.

In the event that I use SQL Server Express and need to redistribute it with
my app, is there a silent install available?

<ja**********@gmail.com> wrote in message
news:11**********************@u72g2000cwu.googlegr oups.com...

Well, I''m not sure what you mean by "requires an installed application
to work". I just downloaded it, ran the setup & it worked. And, since
your reluctance to do that is the *ONLY* requirement you specify for
your database needs, it''s really hard to answer your question.

So, the advantages of SQLExpress over Access, as I see them.
1) It''s free.
2) It''s directly compatible with Sql Server.

这篇关于为什么选择SQL Express over Access？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！