Home > Face-off: MySQL, PostgreSQL and SQL Server
Face-off:
EMAIL THIS

Face-off: MySQL, PostgreSQL and SQL Server

22 Sep 2006 | SearchSystemsChannel.com

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



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.



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



RELATED CONTENT
Database Deployment and Upgrade Projects
The changing database consolidation landscape
Maintaining performance after a database consolidation
Refining plans for database consolidation
Cleaning up with database consolidation services
Oracle Database 11g innovations: Get ahead of the game
Remote DBA services: Overcoming sales hurdles
Computer information systems for small and midsized businesses (SMBs)
Web-based database support
DBA services can make VARs money
Architectural solutions to Web-based applications with large datasets for VARs

Relational Database Management Systems (RDBMSes)
SQL Server 2008 Reporting Services for high-availability deployment
SQL Server 2008 Reporting Services for Internet deployment
SQL Server 2008 hardware and software requirements
Key features in SQL Server 2008 Reporting Services editions
Optimizing SQL Server 2008 performance
SQL Server 2008 features study guide
Troubleshooting a failed SQL Server 2008 installation
Microsoft SQL Server 2008 guide
Oracle Database 11g study guide
Federated databases

Additional Resources
Open source CRM software meets Software as a Service (SaaS) CRM
Open source email on the move
Open Source BI

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 ExchangeTipsMultimediaWhite PapersBlogsEvents
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




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