Oracle XE 或 SQL Server Express
我正在这里开始一个新项目（Windows 窗体）。 对于小型（像啤酒一样免费）DBMS 而言，当今的最佳选择是什么？
我在过去的项目中使用过 SQL Server Express，但我一次又一次听到人们说 Oracle 的产品更快、更强大。
它将在一家小公司（大约 20 个用户）中使用，并且不会很快达到 4 GB 限制:)
我不想在我的第一篇文章中引发一场激烈的战争，所以请向我指出一些显示如果可能的话，对两种产品进行良好的（和实际的）比较。
PS：我也听说过IBM DB2 Express，但我找不到有关它的任何信息。 （IBM 的营销材料不算：））
I'm starting a new project here (Windows Forms). What's the best option today for a small (free as in beer) DBMS?
I've used SQL Server Express on the past projects, but time and time again I hear people saying that the product from Oracle is faster and more powerful.
It will be used in a small company (around 20 users) and will not reach the 4 GB limit any time soon :)
I don't want to start a flame war on my first post, so please point me to some link showing a good (and actual) comparison between the 2 products, if possible.
PS: I've heard about IBM DB2 Express too, but I coudn't find any information about it. (Marketing material from IBM doesn't count :) )
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（9）
考虑到您概述的需求，很难争论任何一种方式都会比另一种更加突出。
我要说的是：
也就是说，我有更多的经验SS比Oracle所以YMMV。
It would be hard to argue either way given the needs you outlined, that either would shine over the other.
What I will say is this:
That said, I have much more experience with SS than Oracle so YMMV.
抱歉，没有链接，但有一个建议。 因为我们支持 Oracle 和 SQL Server，所以我知道修复“普通”Oracle 数据库并不是我所说的有趣的事情。 你必须为此付费，如果你没有工具可以为你更新 Oracle 系统，那么如果你问我的话，这将是一件痛苦的事情。 查看更新/修复如何支持 Oracle XE。 我不知道，我只使用“普通”Oracle（开发人员）数据库。
Sorry, no link, but one advice. Because we support Oracle and SQL Server, I know that getting fixes for the 'normal' Oracle database, is not something what I call fun. You have to pay for it, and if you have no tool which updates your Oracle system for you, it's a pain in the a.., if you ask me. Check out how the Oracle XE is supported with updates/fixes. I don't know, I only use the 'normal' Oracle (Developer) database.
我认为每隔一段时间重新思考一下事情是很好的，而且当你处于十字路口时考虑替代产品是非常明智的。
如果您擅长优化系统并且具有 dba 级别的技能，我会考虑 PostgreSQL。 我不认为自己是 dba，并且具有中等数据库技能，并且发现 SQL Server Express 非常易于使用。 另外，我的产品超出了 SQL Server Express 的限制 - 到 SQL Server Standard/Enterprise 的过渡是顺利的。
我意识到这在技术层面上并不重要，但拉里·埃里森用他的利润购买飞机和妓女。 比尔盖茨正在用他的方法解决对人类极其重要的问题。 在所有条件相同的情况下，我总是更愿意把钱给比尔·盖茨。
I think it's great to rethink things every once in a while and that it's very smart to consider alternative products when you are at a junction to do so.
If you are comfortable optimizing systems and are dba level in skills, I'd consider PostgreSQL. I do not consider myself a dba and have middling database skills and find SQL Server Express extremely easy to use. Also, I've had products exceed the limits of SQL Server Express - the transition to SQL Server Standard/Enterprise is seemless.
I realize that this doesn't matter at a technical level, but Larry Ellison buys jets and prostitutes with his profit. Bill Gates is solving problems of immense importance to humanity with his. All things being equal, I always prefer to give my money to Bill Gates.
这有什么用吗：
https://web.archive.org/web/1/http://downloads.techrepublic%2ecom%2ecom/5138-9592-6028761.html
注意需要注册
Is this any use:
https://web.archive.org/web/1/http://downloads.techrepublic%2ecom%2ecom/5138-9592-6028761.html
NB Registration is required
KiwiBastard的两个观点都非常好，我完全同意他的观点。
如果你确实想要一个类似于 MS SQL 的免费替代方案，并且在需要时支持增长，你可以看看 MySQL 或 PostgreSQL。 SQLite 似乎也是一个不错的选择。
如果您在一家拥有 20 名员工的公司工作，您当然可以买得起一台旧的 Linux 服务器。
Both of KiwiBastard's points are very good and I completely agree with him.
If you really want a free alternative that is similar to MS SQL and supports growth should you need it, you could have a look at MySQL or PostgreSQL. SQLite also seems a good choice.
Surely you can afford an old Linux server if you work in a company with 20 employees.
我会选择 SQL Server Express 解决方案，除非您绝对必须使用 Oracle 中 SQL Server 没有的功能，并且您没有可用的解决方法。
Oracle 优势示例：
也许你可以看出，我是 Oracle 的忠实粉丝！ 但我认为 Oracle Express 是对 SQL Server Express 的商业反应，而且我认为 Oracle 内心深处并不喜欢它。
在速度方面，对于如此小的数据集大小，两者都会很快。
I would go for the SQL Server Express solution, unless you absolutely have to use a feature in Oracle that SQL Server does not have and you have no usable workaround.
Example of Oracle's strengths:
Maybe you can tell, I'm a big Oracle fan! But I think that Oracle Express is a commercial reaction to SQL Server Express and I don't think Oracle really deep deep down likes it.
In terms of speed, both are going to be lighting quick with such a small dataset size.
100% SQL Express，比 Oracle 更易于安装和维护。
100% SQL Express, more easy to install and maintain than Oracle.
恕我直言，SQL Server 的主要问题长期以来一直是没有多版本读取一致性。 幸运的是，自 SQL Server 2005 以来，这个问题已通过快照隔离级别得到纠正。
如果您正在为需要最少维护知识的小型项目寻找良好的 RDBMS，SQL Server Express Edition 是一个不错的选择。 SQL Server Express Edition UI 比 RMAN 或“更容易”更容易理解- 使用 Oracle Database XE 附带的备份脚本，这需要使数据库脱机。
Oracle Database XE 位于我的 *** 列表中。 他们最近发布了一个未正确编译的 Linux ODBC 驱动程序（ld 返回缺少的符号所需的 ODBC 功能）才能完全可用（10.2.0.4）。 即使对于“免费”产品来说，由于缺乏对任何合理数量的质量保证的关注，我会三思而行是否要走这条路。
IMHO the major problem with SQL Server, has for a long time been, no multi-version read consistency. Fortunately this has been corrected since SQL Server 2005 with the snapshot isolation level.
If your looking for a good RDBMS for a small project requring minimal knowledge for maintenance, SQL Server Express Edition is a good pick. The SQL Server Express Edition UI is much easier to understand than RMAN or the "easier"-to-use backup scripts included with Oracle Database XE which requires offlining your database.
Oracle Database XE is on my *** list. They recently released an ODBC driver for Linux that wasn't compiled properly (ld returns missing symbols for required ODBC functions) to be at all usable (10.2.0.4). With this kind of lack of attention to any reasonable amount of QA even for a 'free' product I would think twice about going down that road.
对于DB2 Express-C，请参阅：
For DB2 Express-C see: