Home > Face-off: MySQL, PostgreSQL and SQL Server go head to head
Face-off:
EMAIL THIS LICENSING & REPRINTS

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

30 May 2006 | SearchOpenSource.com and SearchSQLServer.com editors

Expert advice on database administration
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google

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 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.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


RELATED CONTENT
SQL Server competitors
SQL Server DBMS' growing popularity is no coincidence
Forrester Research on Oracle Real Application Clusters
Getting BI with a little help from your friends
BI better bought than built, study says
Are you ready for single-platform databases?
Are single-platform databases in your future?
SQL Server 2005 bitmap index?
Security is the catch word for SQL Server's sequel
Oracle 10g priced to compete with SQL Server
Report: Oracle pricing won't lure SQL Server users
SQL Server competitors Research

SQL Server 2005 (Yukon)
SQL Server consolidation: Why it's an optimization technique
Parent-child dimensions in SQL Server 2005 with Analysis Services MDX
Using SQL Server datetime functions GETDATE, DATENAME and DATEPART
SSIS error message due to installation problem on SQL Server 2005
SQL Server data conversions from date/time values to character types
Basics for working with DATETIME and SMALLDATETIME in SQL Server 2005
How to configure Database Mail in SQL Server 2005 to send mail
How to use rank function in SQL Server 2005
Manage traces in SQL Server 2005 Analysis Services with XMLA commands
Tutorial: SQL Server 2005 Analysis Services
SQL Server 2005 (Yukon) Research

SQL Server ROI and TCO
Chapter 2: Planning your SQL Server consolidation
Pitfalls of SQL Server sprawl
SQL Server consolidation pros and cons
Top 10 SQL Server tips of 2005
Step-by-Step Guide: How to spec your SQL Server hardware needs
Top 10 SQL Server tips of 2005
SQL Server consolidation pros and cons
Fast Guide: Avoiding data integrity gotchas
SQL Server Express a sign of LAMP's success
Security is the catch word for SQL Server's sequel
SQL Server ROI and TCO Research

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
application server  (SearchSQLServer.com)
Yukon  (SearchSQLServer.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary


HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 2005 - 2008, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts