MySql is free though licensing is a bit complicated because of a dual-license model. The community edition includes many "enterprise" sorts of features like replication and partitioning. If I recall, there are additional backup tools and monitoring in the paid enterprise edition. If you want to go completely free from the weird Oracle ownership stuff (which I think is wise, personally), there is the MariaDB fork which is entirely FOSS as far as I know. What "enterprise" features are you thinking aren't in the community edition?
MySql community edition has none of the limitations present in MS SQL Express edition. Honestly, not taking advantage of more than a gig of RAM or 1 cpu core is just stupid. Why would you even have a database server? I suppose if you are housing the db on the same machine as your app server then...well, you have plenty of other problems at that point. Sql Express is great for development (though I prefer developer edition myself). It is not meant for production websites, period. That's why Microsoft has a Web edition. I like SQL Server and use it but it is wrong to try and compare Sql Express and MySql community edition, they are completely different classes of software. That being said, I still think people should check out PostGres. A feature set comparable to Oracle/MS SQL/Sybase and genuinely FOSS, unlike MySql. Tasty DB goodness. Cheers, Judah On Mon, May 9, 2011 at 4:57 PM, Russ Michaels <r...@michaels.me.uk> wrote: > > Many people often wrongly assume that MySQL is simply FREE, which is not > correct. Many people are also completely unaware that there is a FREE MSSQL > Express edition. > The FREE version is the community edition, which also has limitations, look > them up, If you want enterprise features then you have to pay i'm afraid, > even with MySQL. > The FREE editions of both will meet most peoples needs even with their > limitations, it is really not very common to have databases of 10GB that > needs more than 1GB RAM or more than 1CPU, then you probably be using the > FREE editions anyway. > > > > On Tue, May 10, 2011 at 12:26 AM, Judah McAuley <ju...@wiredotter.com>wrote: > >> >> Or possibly Jordan has needed a database that runs on more than 1 CPU, >> uses more than 1GB of RAM or has a db size of more than 10GB :) >> >> >> On Mon, May 9, 2011 at 4:20 PM, Russ Michaels <r...@michaels.me.uk> wrote: >> > >> > Perhaps you tried to run MSSQL on linux Jordan, that would certainly >> > be humorous I imagine :-) >> > >> > >> > On Tue, May 10, 2011 at 12:12 AM, Gerald Guido <gerald.gu...@gmail.com >> >wrote: >> > >> >> >> >> > Russ Michaels wrote: >> >> > >> >> > don't forget that MSSQL express is also free and more powerful than >> mysql >> >> >> >> >> >> >Jordan Michaels <jor...@viviotech.net> wrote: >> >> >> >> > I find the "more powerful" comment humorous. >> >> >> >> This should be fun to watch :) I am making some popcorn. Anyone want >> some? >> >> >> >> G! >> >> >> >> On Mon, May 9, 2011 at 6:52 PM, Jordan Michaels <jor...@viviotech.net >> >> >wrote: >> >> >> >> > >> >> > I find the "more powerful" comment humorous. >> >> > >> >> > SQL Express limits are here: >> >> > http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx >> >> > >> >> > Migration from MS SQL to MySQL documentation is here: >> >> > >> >> > >> >> >> http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-indepth-sourcedb-mssql.html >> >> > >> >> > I've done it several times with no issues. >> >> > >> >> > -Jordan >> >> > >> >> > On 05/09/2011 03:38 PM, Russ Michaels wrote: >> >> > > >> >> > > don't forget that MSSQL express is also free and more powerful than >> >> mysql >> >> > > community edition so there is no need to migrate to MySQL unless >> your >> >> > also >> >> > > moving to Linux. >> >> > > There are however free migration tools on the mysql site that will >> do >> >> it >> >> > for >> >> > > you. >> >> > > >> >> > > On Mon, May 9, 2011 at 11:29 PM, Jenny Gavin-Wear< >> >> > > jenn...@fasttrackonline.co.uk> wrote: >> >> > > >> >> > >> >> >> > >> I'm interested in any info. Pit falls to avoid, best practises, >> etc. >> >> > >> >> >> > >> Many thanks, >> >> > >> >> >> > >> Jenny >> >> > >> No virus found in this outgoing message. >> >> > >> Checked by AVG - www.avg.com >> >> > >> Version: 9.0.900 / Virus Database: 271.1.1/3625 - Release Date: >> >> 05/08/11 >> >> > >> 19:34:00 >> >> > >> >> >> > >> >> >> > >> >> >> > >> >> >> > > >> >> > > >> >> > >> >> > >> >> >> >> >> > >> > >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344388 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm