SQL或Access DB [英] SQL or Access DB

问题描述

大家好


我打算为家庭写一个股票和账户计划

业务，我明白这可能接近2

完成。该股票可能会遇到超过一千种商品和

会计方面将被用于希望多年，因此

条目可能很大。


删除是什么最好使用数据库引擎，Access我有/ b $ b部分Office 2002或者我应该真的在看SQL服务器？


两者之间的优缺点是什么？


数据库目前只能由一个客户端访问，但绝不会更多< br $> b $ b比2.


如果选择SQL Server，那么只有一个版本可用于

单个客户端。我记得使用MSDE时我的ASP.Net书可以用

用来创建初始数据库???


感谢您抽出宝贵时间阅读本文，在此规划阶段，任何建议都非常有用。


-

DaveG - 学习VB .Net慢慢。

Sk？日元 - 奥斯陆 - 挪威

Hi all

I am planning on writing a stock and accounts program for the family
business, I understand this is likely to take close to 2 years to
accomplish. The stock is likely to run into over a thousand items and
the accounting side will be used for hopefully many years so the
entries are likely to be vast.

The delema is what is best to use ase the DB engine, Access I have as
part of Office 2002 or should I really be looking at SQL server??

What are the pros and cons between the two??

The DB will only be accessed by one client at this time but never more
than 2.

If the choice is SQL Server is there a version available just for
single clients. I remember using MSDE when I did my ASP.Net book can
this be used to create the initial DB???

Thanks for taking the time to read this, any advice would be very
helpfull to me at this planning stage.

--
DaveG - Learning VB.Net slowly.
Sk?yen - Oslo - Norway

推荐答案

如果你说你将拥有大型数据库，那么访问量不是太大，它b / b
往往会被破坏等等。但我不会认为1000件商品是大量的商品。所以你应该重新检查一下，如果这个数据库确实是真的，那么
最终会很大。


我认为MSDE（或其下一个版本，SQL Express）是如果

你真的有一个大型数据库可能是你最好的选择。我认为你不需要全力以赴
并购买SQL Server。


" DaveG" <是ne ******* @ daveg.no.nospam>在留言中写道

新闻：O9 ******************** @ telenor.com ...

If you say you will have large databases, then Access isn''t too great, it
tends to get corrupted, etc. But I wouldn''t consider 1000 items to be a
large number of items. So you should re-examine, if this database will truly
end up being large.

I think MSDE (or its next version, SQL Express) is probably your best bet if
you really will have a large database. I don''t think you need to go all out
and buy SQL Server.

"DaveG" <ne*******@daveg.no.nospam> wrote in message
news:O9********************@telenor.com...

你好所有

我正计划为家庭业务编写股票和账户计划，据我所知，这可能需要近2年的时间才能完成。该库存可能会遇到超过一千种商品，并且会计方面将被用于希望多年，因此
条目可能很大。

删除是什么是最好使用数据库引擎，Access我有Office 2002的一部分或者我应该真的在看SQL服务器吗？

两者之间有什么利弊??这个数据库目前只能由一个客户端访问，但绝不会比2更多。

如果选择SQL Server有版本仅适用于单个客户。我记得使用MSDE时，我的ASP.Net书可以用来创建初始数据库???

感谢您花时间阅读本文，任何建议都会非常
在这个计划阶段对我很有帮助。

-
DaveG - 慢慢学习VB.Net。
Sk？yen - 奥斯陆 - 挪威

Hi all

I am planning on writing a stock and accounts program for the family
business, I understand this is likely to take close to 2 years to
accomplish. The stock is likely to run into over a thousand items and
the accounting side will be used for hopefully many years so the
entries are likely to be vast.

The delema is what is best to use ase the DB engine, Access I have as
part of Office 2002 or should I really be looking at SQL server??

What are the pros and cons between the two??

The DB will only be accessed by one client at this time but never more
than 2.

If the choice is SQL Server is there a version available just for
single clients. I remember using MSDE when I did my ASP.Net book can
this be used to create the initial DB???

Thanks for taking the time to read this, any advice would be very
helpfull to me at this planning stage.

--
DaveG - Learning VB.Net slowly.
Sk?yen - Oslo - Norway

Sql Server比以几乎所有可能的

方式访问要好得多。如果你有多个用户点击数据库，那么规则

就可以直接访问了。访问是联网的噩梦

场景b / c它不是一个网络数据库（虽然它可以作为

一个）。

Sql Server在安全性方面表现较好，并且备份相同

成立。如果您需要及时备份和恢复，那么Sql Server是唯一的选择。

考虑到Sql Server MSDE是免费的并且具有与

访问 - 我忘了访问甚至存在。

" DaveG" <是ne ******* @ daveg.no.nospam>在留言中写道

新闻：O9 ******************** @ telenor.com ...

Sql Server is soooo much better than access in just about every conceivable
way. If you are going to have multiple users hitting the db, then rule
access out right off of the bat. Access is a nightmare in networked
scenarios b/c it''s not meant to be a network db (although it can function as
one).
Sql Server is light years better in security and as far as back up the same
holds. If you need point in time backup and recovery, then Sql Server is
the only choice.
Considering that Sql Server MSDE is free and has the same capacity as
Access- I''d forget that access even existed.
"DaveG" <ne*******@daveg.no.nospam> wrote in message
news:O9********************@telenor.com...

你好所有

我正计划为家庭业务编写股票和账户计划，据我所知，这可能需要近2年的时间才能完成。该库存可能会遇到超过一千种商品，并且会计方面将被用于希望多年，因此
条目可能很大。

删除是什么是最好使用数据库引擎，Access我有Office 2002的一部分或者我应该真的在看SQL服务器吗？

两者之间有什么利弊??这个数据库目前只能由一个客户端访问，但绝不会比2更多。

如果选择SQL Server有版本仅适用于单个客户。我记得使用MSDE时，我的ASP.Net书可以用来创建初始数据库???

感谢您花时间阅读本文，任何建议都会非常
在这个计划阶段对我很有帮助。

-
DaveG - 慢慢学习VB.Net。
Sk？yen - 奥斯陆 - 挪威

Hi all

I am planning on writing a stock and accounts program for the family
business, I understand this is likely to take close to 2 years to
accomplish. The stock is likely to run into over a thousand items and
the accounting side will be used for hopefully many years so the
entries are likely to be vast.

The delema is what is best to use ase the DB engine, Access I have as
part of Office 2002 or should I really be looking at SQL server??

What are the pros and cons between the two??

The DB will only be accessed by one client at this time but never more
than 2.

If the choice is SQL Server is there a version available just for
single clients. I remember using MSDE when I did my ASP.Net book can
this be used to create the initial DB???

Thanks for taking the time to read this, any advice would be very
helpfull to me at this planning stage.

--
DaveG - Learning VB.Net slowly.
Sk?yen - Oslo - Norway

嗨Dave，


我必须全心全意地同意我们的MVP专家。如果你有一个客户超过
，那么你就不应该考虑Access。关于MSDE，你是正确的

。它是免费的，我自己一直在用它来开发

几个月。我最近下载了较新的sql express，但是没有

有时间正确查看它。


是的，你不仅可以创建你的数据库使用MSDE中的工具（例如

osql）和相应的脚本，您还可以使用MSDE作为sql server完全运行数据库应用程序

。去吧，这很有趣！ :-)


Rgds，


Phil

" DaveG" <是ne ******* @ daveg.no.nospam>在留言中写道

新闻：O9 ******************** @ telenor.com ...

Hi Dave,

I have to agree wholeheartedly with our MVP expert. When you have more than
one client then you shouldn''t really be considering Access. You are correct
regarding MSDE. It is free and I have been using it myself for development
for a few months. I recently downloaded the newer sql express but haven''t
had the time to look at it properly.

Yes, you can not only create your db using the tools within MSDE (such as
osql) and appropriate scripts, you can also fully run your db applications
with MSDE as your sql server. Go for it, it''s fun!! :-)

Rgds,

Phil
"DaveG" <ne*******@daveg.no.nospam> wrote in message
news:O9********************@telenor.com...

你好所有

我正计划为家庭业务编写股票和账户计划，据我所知，这可能需要近2年的时间才能完成。该库存可能会遇到超过一千种商品，并且会计方面将被用于希望多年，因此
条目可能很大。

删除是什么是最好使用数据库引擎，Access我有Office 2002的一部分或者我应该真的在看SQL服务器吗？

两者之间有什么利弊??这个数据库目前只能由一个客户端访问，但绝不会比2更多。

如果选择SQL Server有版本仅适用于单个客户。我记得使用MSDE时，我的ASP.Net书可以用来创建初始数据库???

感谢您花时间阅读本文，任何建议都会非常
在这个计划阶段对我很有帮助。

-
DaveG - 慢慢学习VB.Net。
Sk？yen - 奥斯陆 - 挪威

Hi all

I am planning on writing a stock and accounts program for the family
business, I understand this is likely to take close to 2 years to
accomplish. The stock is likely to run into over a thousand items and
the accounting side will be used for hopefully many years so the
entries are likely to be vast.

The delema is what is best to use ase the DB engine, Access I have as
part of Office 2002 or should I really be looking at SQL server??

What are the pros and cons between the two??

The DB will only be accessed by one client at this time but never more
than 2.

If the choice is SQL Server is there a version available just for
single clients. I remember using MSDE when I did my ASP.Net book can
this be used to create the initial DB???

Thanks for taking the time to read this, any advice would be very
helpfull to me at this planning stage.

--
DaveG - Learning VB.Net slowly.
Sk?yen - Oslo - Norway

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