| So many businesses are showing interest in open source products that most independent software vendors (ISVs) and value-added resellers (VARs) have no choice but to integrate open source into their product suites and services. Although open source database management systems (DBMSs) aren't front and center of the open source push, their features and functionality will inevitably be considered in most shops.
This face-off helps you weigh the pros and cons of investing in and delivering open source over proprietary database offerings to customers, specifically open source MySQL and PostgreSQL vs. Microsoft SQL Server. If you've already settled on your product suite and need technical advice on database or data migration from one system to another, you'll also find best practices for running open source and proprietary systems to get you started.
|
MySQL
Opinion: MySQL CEO says watch out for vendor lock-in strategies and describes MySQL's partner programs and hosting strategy.
Overview: Companies are slowly migrating to open source. Find out who is migrating now and why.
|
SQL Server
Opinion: SQL Server offers more robust features at a lower price point than competing DBMSs.
Overview: Pushing a company's hot button to invest in SQL Server 2005 may be challenging -- but there are many new enhancements you can dangle in front of them.
|
PostgreSQL
Opinion: PostgreSQL is ready to replace Microsoft's SQL Server in the enterprise. Should you be on the bandwagon?
Opinion: PostgreSQL matches up to other commercial DBMSs and is suitable for both large and small enterprises.
|
| Running open source and proprietary systems
Best practices: Get help determining which customers you should and should not migrate from SQL Server to MySQL.
Best practices: Get help migrating to open source MySQL.
Best practices: PostgreSQL 8.0 to is the first version to include native Windows support. Get help running the systems together in this tip.
Best practices: Get DBMS feature and functionality comparisons to keep in mind when working with both SQL Server to MySQL.
Best practices: Learn how to share or convert data between open source MySQL and proprietary SQL Server.
|