超过2GB限制的SQL Server Express替代品 [英] SQL Server Express alternatives beyond 2GB limit

问题描述

在我们的项目中（使用.NET完全开发），我们使用大小为2 GB的中型数据库。目前我们正在使用SQL Express版本;

In our project (which is fully developed using .NET), we use a medium sized database about 2 GB in size. Currently we are using SQL Express edition;

SQL Server Express的备用程序如何执行？我主要考虑MySQL和PostgreSQL。 （Windows 7 x86，x64）

How do the alternates for SQL Server Express perform? I am mainly considering MySQL and PostgreSQL. (Windows 7 x86, x64)

• 使用MySQL或PostgreSQL有什么优势吗？


• 
  
• 支持二进制数据？





这三个数据库的性能比较？

• Is there any compelling advantage to using MySQL or PostgreSQL?
• What about the native .NET object support?
• Built in XML types?
• Supporting Binary data?
• Support of a similar tool like Management Studio?
• Installation ease?
• Memory footprint?
• Performance comparisons of these 3 databases?

是否值得考虑这些选择，尤其是考虑到我们是一个.NET商店？

Is it even worth considering these alternatives, especially considering the fact that we are a .NET shop?

我已提及以下相关问题：

I have referred to these related questions:

• http://stackoverflow.com/questions/1371560/db2-vs-postgresql-vs-sql-server


• http：// stackoverflow .com / questions / 3779088 / database-that-c​​an-handle-500-millions-rows


• http://stackoverflow.com/questions/336275/mysql-versus-sql-server-express

• http://stackoverflow.com/questions/1371560/db2-vs-postgresql-vs-sql-server
• http://stackoverflow.com/questions/3779088/database-that-can-handle-500-millions-rows
• http://stackoverflow.com/questions/336275/mysql-versus-sql-server-express

推荐答案

我是一个不相信只是因为你是一个.NET商店，你必须使用Microsoft SQL Server产品的人，虽然微软喜欢它，如果你这样做。当然，它与微软的本地库和开发工具非常好地联系在一起。对我来说，这是SQL Server的优势真正停止的地方，它是更多的与其他数据库系统一个平衡的领域。

I'm a person who doesn't believe just because you are a .NET shop that you have to use a Microsoft SQL Server Product, although Microsoft loves it if you do. Of course it ties in really nicely with the native libraries and development tools from Microsoft. To me that's where the advantages really stop for SQL Server and it's more of a even playing field with other database systems.

MySQL - 远离它，事情变得丑陋并且会变得丑陋，现在Oracle拥有它。在我看来，当你可以免费使用PostgreSQL而不用担心时，不值得花费使用第二个速率的开源数据库。

MySQL - Stay away from it, things have gotten ugly and will get uglier now that Oracle owns it. Not worth having to pay to use a second rate open source database in my opinion when you can use PostgreSQL for free and without fear.

PostgreSQL - 一个很好的选择。 BSD许可证是免费使用和更改源。对数据批次的功能没有限制。但如果安装时间是你的驱动原因离开SQL Express PostgreSQL安装在Windows或Linux上相当快，我有多快我不知道，因为我不在乎我的系统需要1分钟或10分钟。在Linux机器上，如果你预先编译它或者使用程序包安装，它真的很快，我会说不到10分钟。

PostgreSQL - A really good option. BSD license is free to use and change the source. No limit on data lot's of features. But if install time is your driving reason to leave SQL Express PostgreSQL does install pretty fast on Windows or Linux, how fast I don't know because I don't care if it takes 1 minute or 10 minutes on my systems. On a Linux box it's really fast if you pre-compile it or use a package install, I would say less than 10 minutes.

原生.NET对象支持？不确定是什么。

What about the native .NET object support? Not sure what this is.

内置XML类型？ PG是的。

Built in XML types? PG yes.

支持二进制数据？ PG是的。

Supporting Binary data? PG yes.

支持像Management Studio这样的类似工具吗？ PG是pgadmin或一些其他第三方供应商。

Support of a similar tool like Management Studio? PG yes pgadmin or a few other third party vendors.

安装方便吗？容易与更多的选择比SQL Server。例如，你可以编译不同的页面大小，如果你想。

Installation ease? Easy with more options than SQL Server. For example you can compile with different page size if you wanted to.

内存占用？可以小或大，这取决于如何调整内存设置。

Memory footprint? Can be small or large depending on how you adjust memory settings.

这3个数据库的性能比较？好了SQL express不能容纳超过4到10GB，忘记多少2008 express可以做。所以你不是在这里比较苹果和橘子。但我会说，如果使用正确，他们都可以表现良好。 PG执行得很好。

Performance comparisons of these 3 databases? Well SQL express can't hold more than 4 to 10GB forget how much 2008 express can do. So you aren't comparing apples to oranges here. But I would say all of them can perform well if used correctly. PG performs very well.

是否值得考虑这个选择（特别是考虑到我们是一个.NET商店）？是的，值得考虑，但取决于成本对你重要。我的猜测是在某一点，你会出来的快速版本，并已开始购买付费版本。微软知道如何销售，它是模型的一部分，你会成长快。
如果你有机会测试它并验证它在你的环境中使用这个时间来比较，你不能走错PostgreSQL。不要只是默认SQL Server，因为你的一个.NET商店。

Is it even worth considering this alternative (especially considering the fact that we are a .NET shop)? Yes it's worth considering but depends if cost matters to you. My guess is at some point you will out grow the express edition and have to start buying a payed version. Microsoft knows how to sell and it's part of the model that you will out grow express. You can't go wrong going with PostgreSQL if you have the chance to test it and validate it in your environment use this time to compare. Don't just default to SQL Server because your a .NET shop.

以前的帖子，增加了这一点，今天更真实。
http://archives.postgresql.org/pgsql-advocacy /2005-07/msg00008.php

Older post that adds to this and is even more true today. http://archives.postgresql.org/pgsql-advocacy/2005-07/msg00008.php

这篇关于超过2GB限制的SQL Server Express替代品的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！