Face-off: MySQL, PostgreSQL and SQL Server go head to head

Face-off: MySQL, PostgreSQL and SQL Server go head to head

As open source database management systems have matured to provide greater features and functionality, they've become significant forces for their proprietary counterparts to contend with in the database arena. Not simply toys for hobbyists or tools to address non-mission-critical business needs, MySQL and PostgreSQL databases have become legitimate options for cost savings in the enterprise. But how do they really stack up against proprietary databases like SQL Server? Will switching to an open source database ultimately save you money?

In this special report, SearchOpenSource.com and SearchSQLServer.com editors team up to bring you both the pros and cons of investing in MySQL, PostgreSQL or SQL Server databases. Read the opinions of industry experts then

    Requires Free Membership to View

    Login

    By submitting your registration information to SearchSQLServer.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSQLServer.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.


Premium Access

Register now for unlimited access to our premium content across our network of over 70 information Technology web sites.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

This was first published in May 2006

.hPwfcbzFvsc.0@.1dd09692!action=postFirst&setContentUrl=1>Sound Off! to share your own.

For those of you working with both open source and proprietary databases, stay tuned for an upcoming special report on how to integrate and work with such mixed systems under the same roof.


Beware proprietary vendors bearing free software. MySQL AB CEO Marten Mickos warns users to watch out for vendor lock-in strategies and overpriced service organizations.

How can you move from the oligarchy of commercial databases to the democracy of open source? The migration is relatively straightforward, but it must be accomplished with a well-structured plan.

SQL Server offers more robust features at a lower price point than competing database management systems, making its growing popularity no surprise to columnist Adam Machanic.

Your decision to upgrade to SQL Server 2005 may come down to upgrade cost and time versus business improvement and competitive advantage. Determine if an immediate upgrade is right for your organization.

Is OS database PostgreSQL ready to replace Microsoft's SQL Server in the enterprise? Web application developer and author W. Jason Gilmore tackles the question in this column.

Learn how PostgreSQL matches up to other commercial database systems, why it's suitable for large- and small-scale enterprises and how it offers admins and users more control.
Back to top