访问vs SQL [英] Access vs SQL

问题描述

Hello All，


我一直在开发一个需要使用DB的VB.NET应用程序。到目前为止，

我一直在使用Access。它有点慢，但一切正常。我现在处于
点，我需要决定是否应该继续使用Access或将数据库

移动到SQL。我正在努力为这样的举动提出一份优惠/缺点清单。我的

列表有点不平衡，因为我对SQL的经验很少，而且很有可能用于访问。


PROS迁移到SQL：

提高性能？

提高可靠性？

生命周期访问？

未来访问版本兼容性问题？


转向SQL的缺点：

我对SQL的了解有限

客户端不需要SQL服务器


我已经在PROS列表中添加了一些项目，但是有了？s，因为我不是真的知道这些项目。


如果有一些Access支持者和SQL支持者可以给我一些观点，那么我会更自在地做出决定。 />
事实，而不是我有限的知识。


TIA

李

Hello All,

I''ve been developing a VB.NET app that requires the use of a DB. Up to now,
I''ve been using Access. It''s a bit slow, but everything works. I''m at a
point now where I need to decide if I should stay with Access or move the DB
to SQL. I''m trying to come up with a list of Pros/Cons for such a move. My
list is a bit lopsided, as I have very little experience with SQL and quite
a bit with Access.

PROS for moving to SQL:
Increased Performance?
Increased Reliability?
Lifecycle of Access?
Future Access Version compatibility issues?

CONS for moving to SQL:
My limited knowledge of SQL
Clients not required to have an SQL server

I''ve added a few items to the PROS list, but with ?s, as I don''t really
know.

If there are a few Access advocates and SQL advocates out there that could
give me some viewpoints, I''d be more comfortable making a decision based on
the facts, rather than my limited knowledge.

TIA
Lee

推荐答案

MSDE是sql server的免费缩放版本。所以

客户端并不需要购买sql server。如果你使用msde设计一个应用程序

以后需要sql server的网络功能，那么你可以很容易地升级你的应用程序。

< a rel =nofollowhref =http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde/html/usingmsde.asp\"target =_ blank> http： //msdn.microsoft.com/library/de.../usingmsde.asp

http://www.microsoft.com/downloads/d...DisplayLang=en


Ken

--------------------

" lgbjr" < LG *** @ online.nospam>写在消息

新闻：ex ************** @ TK2MSFTNGP09.phx.gbl ...

Hello All，


我一直在开发一个需要使用DB的VB.NET应用程序。到目前为止，

我一直在使用Access。它有点慢，但一切正常。我现在处于
点，我需要决定是否应该继续使用Access或将数据库

移动到SQL。我正在努力为这样的举动提出一份优惠/缺点清单。我的

列表有点不平衡，因为我对SQL的经验很少，而且很有可能用于访问。


PROS迁移到SQL：

提高性能？

提高可靠性？

生命周期访问？

未来访问版本兼容性问题？


转向SQL的缺点：

我对SQL的了解有限

客户端不需要SQL服务器


我已经在PROS列表中添加了一些项目，但是有了？s，因为我不是真的知道这些项目。


如果有一些Access支持者和SQL支持者可以给我一些观点，那么我会更自在地做出决定。 />
事实，而不是我有限的知识。


TIA

Lee

Hi,

The MSDE is a free scaled back version of sql server. So the
client isn''t required to buy sql server. If you design an app using msde
and later need the networking features of sql server it is real easy to
upgrade you app.

http://msdn.microsoft.com/library/de.../usingmsde.asp

http://www.microsoft.com/downloads/d...DisplayLang=en

Ken
--------------------
"lgbjr" <lg***@online.nospam> wrote in message
news:ex**************@TK2MSFTNGP09.phx.gbl...
Hello All,

I''ve been developing a VB.NET app that requires the use of a DB. Up to now,
I''ve been using Access. It''s a bit slow, but everything works. I''m at a
point now where I need to decide if I should stay with Access or move the DB
to SQL. I''m trying to come up with a list of Pros/Cons for such a move. My
list is a bit lopsided, as I have very little experience with SQL and quite
a bit with Access.

PROS for moving to SQL:
Increased Performance?
Increased Reliability?
Lifecycle of Access?
Future Access Version compatibility issues?

CONS for moving to SQL:
My limited knowledge of SQL
Clients not required to have an SQL server

I''ve added a few items to the PROS list, but with ?s, as I don''t really
know.

If there are a few Access advocates and SQL advocates out there that could
give me some viewpoints, I''d be more comfortable making a decision based on
the facts, rather than my limited knowledge.

TIA
Lee

你有一个用于SQL的CON，客户端不需要有一个SQL服务器。

我请说'是PRO。


以下是一些需要考虑的其他主要问题：


Access在SQL时具有有限的并发连接支持服务器是设计为服务器的，因此它支持许多并发连接。

Access不支持存储过程但SQL Server支持。

访问没有实现任何数据库安全性（超出数据库密码），但SQL

服务器具有强大的安全模型。

" lgbjr" < LG *** @ online.nospam>在消息中写道

news：ex ************** @ TK2MSFTNGP09.phx.gbl ...

You''ve got a CON for SQL that "Clients not required to have an SQL server".
I''d say that''s a PRO.

Here are some other major issues to consider:

Access has limited concurrent connection support while SQL Server was
designed as a server, so it supports many concurrent connections.
Access does not support Stored Procedures but SQL Server does.
Access does not implement any db security (beyond a db password), but SQL
Server has a robust security model.
"lgbjr" <lg***@online.nospam> wrote in message
news:ex**************@TK2MSFTNGP09.phx.gbl...

Hello All，

我一直在开发一个需要使用DB的VB.NET应用程序。现在，我一直在使用Access。它有点慢，但一切正常。我现在需要决定是否应该继续使用Access或将数据库移动到SQL。我正在尝试为这样的举动提出一份优点/缺点清单。我的列表有点不平衡，因为我对SQL的使用经验很少，而且很少使用Access。

PROS转移到SQL：
性能提升？提高可靠性？
访问生命周期？
未来访问版本兼容性问题？

转向SQL的缺点：
我对SQL的了解有限
客户不需要有一个SQL服务器

我已经在PROS列表中添加了一些项目，但有了？s，因为我真的不知道。

如果有一些Access倡导者和SQL倡导者可以给我一些观点，我会更自然地根据事实做出决定，而不是我的有限TIA
李

Hello All,

I''ve been developing a VB.NET app that requires the use of a DB. Up to
now, I''ve been using Access. It''s a bit slow, but everything works. I''m at
a point now where I need to decide if I should stay with Access or move
the DB to SQL. I''m trying to come up with a list of Pros/Cons for such a
move. My list is a bit lopsided, as I have very little experience with SQL
and quite a bit with Access.

PROS for moving to SQL:
Increased Performance?
Increased Reliability?
Lifecycle of Access?
Future Access Version compatibility issues?

CONS for moving to SQL:
My limited knowledge of SQL
Clients not required to have an SQL server

I''ve added a few items to the PROS list, but with ?s, as I don''t really
know.

If there are a few Access advocates and SQL advocates out there that could
give me some viewpoints, I''d be more comfortable making a decision based
on the facts, rather than my limited knowledge.

TIA
Lee

Scott和Ken，

对于入住Access，你是对的，应该是PRO。


感谢您的提示。我想我知道这些事情，只是从我已经完成的

阅读。而且，我几乎可以肯定，正确的长期决定是将b / b转移到SQL Server。我想我可能会采取Ken的建议并带宝宝

迈出一步，通过使用MSDE启动可能是正确的方向。


我的基本知识关心的不是我缺乏SQL Server知识。我只觉得使用SQL Server来获取我的应用程序所需要的东西是有点矫枉过正的。因此，

要求我的客户购买SQL Server似乎是错误的。但是，这个想法

是基于我今天的应用程序所做的。


所以，还没有决定，但是，我认为MSDE给了我简单的可扩展性

的未来，今天没有过多的SQL Server。


谢谢！


Lee

" Scott M." < S - *** @ nospam.nospam>在消息中写道

新闻：eT ************** @ TK2MSFTNGP09.phx.gbl ...

Scott and Ken,

For staying with Access, you''re right, that should be a PRO.

Thanks for the tips. I guess I sort of knew these things, just from the
reading I''ve done. And, I''m almost certain that the right long term decision
is to move to SQL Server. I think I might take Ken''s advice and take a baby
step in what is probably the right direction by using MSDE to start.

My basic concern is not my lack of SQL Server knowledge. I just felt that
using SQL Server for what my app needs was a bit of overkill. And, thus,
requiring my clients to purchase SQL Server seemed wrong. But, this thinking
is based on what my app does today.

So, no decision yet, but, I think MSDE gives me the easy scalability for the
future, without the overkill of SQL Server today.

Thanks!

Lee
"Scott M." <s-***@nospam.nospam> wrote in message
news:eT**************@TK2MSFTNGP09.phx.gbl...

你有用于SQL的CON，客户端不需要具有SQL服务器。我会说那是一个PRO。

以下是一些需要考虑的主要问题：

在SQL Server出现时，Access的并发连接支持有限
设计为服务器，因此它支持许多并发连接。
Access不支持存储过程但SQL Server支持。
Access不实现任何数据库安全性（超出db密码），但SQL
服务器具有强大的安全模型。

" lgbjr" < LG *** @ online.nospam>在消息中写道
新闻：ex ************** @ TK2MSFTNGP09.phx.gbl ...

You''ve got a CON for SQL that "Clients not required to have an SQL
server". I''d say that''s a PRO.

Here are some other major issues to consider:

Access has limited concurrent connection support while SQL Server was
designed as a server, so it supports many concurrent connections.
Access does not support Stored Procedures but SQL Server does.
Access does not implement any db security (beyond a db password), but SQL
Server has a robust security model.
"lgbjr" <lg***@online.nospam> wrote in message
news:ex**************@TK2MSFTNGP09.phx.gbl...

Hello All，

PROS转移到SQL：
提高性能？提高可靠性？
访问生命周期？
未来访问版本兼容性问题？

转向SQL的缺点：
我对SQL的了解有限
客户不需要有一个SQL服务器

我已经在PROS列表中添加了一些项目，但有了？s，因为我真的不知道。

如果有一些Access倡导者和SQL倡导者在那里可以给我一些观点，我会更乐于根据事实做出决定，而不是我的有限知识。

TIA
李

Hello All,

I''ve been developing a VB.NET app that requires the use of a DB. Up to
now, I''ve been using Access. It''s a bit slow, but everything works. I''m
at a point now where I need to decide if I should stay with Access or
move the DB to SQL. I''m trying to come up with a list of Pros/Cons for
such a move. My list is a bit lopsided, as I have very little experience
with SQL and quite a bit with Access.

PROS for moving to SQL:
Increased Performance?
Increased Reliability?
Lifecycle of Access?
Future Access Version compatibility issues?

CONS for moving to SQL:
My limited knowledge of SQL
Clients not required to have an SQL server

I''ve added a few items to the PROS list, but with ?s, as I don''t really
know.

If there are a few Access advocates and SQL advocates out there that
could give me some viewpoints, I''d be more comfortable making a decision
based on the facts, rather than my limited knowledge.

TIA
Lee

这篇关于访问vs SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！