Sunday, August 19, 2007

EnterpriseDB Compatibilty features

A question that I am asked very often it exactly what features are compatible between EnterpriseDB and Oracle. The short story is that the areas that you think of as "development", i.e. SQL, Code, etc are the areas where the compatibility exists.

Maintenance tasks are generally familiar as is the overall architecture. Any modern database will have logging, recovery, backups, etc. In EnterpriseDB, the way you code an application will be compatible with Oracle and the maintenance of an EnterpriseDB database will be familiar.

EnterpriseDB has published a white paper called, Delivering Oracle Compatibility. This paper outlines the exact points of compatibility very succinctly. I hope they keep it updated for each release.

This bulleted list from the white paper outlines it pretty well:

  • Oracle SQL Compatibility. EnterpriseDB Advanced Server executes Oracle-specific SQL syntax.
  • PL/SQL Compatibility. EnterpriseDB Advanced Server executes PL/SQL, Oracle’s unique language for triggers, stored procedures, packages, and functions.
  • Data Dictionary Views. EnterpriseDB provides the most common Oracle catalog views.
  • Programming Flexibility and Drivers. EnterpriseDB supports the most common programming languages used to create database applications for Oracle including compatibility and interoperability with the Oracle Call Interface (OCI)™.
  • Migration Tools. EnterpriseDB provides a suite of automated tools to move Oracle data, packages, triggers, stored procedures, and functions to EnterpriseDB in one simple step.
  • Replication. EnterpriseDB Replication Server can replicate Oracle databases in near real-time to: improve database performance, run reporting and as the foundation for other applications at a small fraction of Oracle’s cost.
  • Enterprise-Class Reliability and Scalability. EnterpriseDB Advanced Server is a suitable replacement for Oracle in high-volume, mission-critical applications.
  • Oracle-Like Tools. EnterpriseDB Advanced Server includes a robust set of integrated tools that will be familiar to professional Oracle DBAs and developers.
The white paper lists specific functions and features that are Oracle compatible. If you are considering EnterpriseDB, you should read it. The one thing it doesn't list are those items that ARE NOT compatible, i.e. missing functions, incompatible syntax, data types issues. Fortunately, you can find those in my book. ;-)


Software Blogs - Blog Catalog Blog Directory Software blogs Top Blog Sites Blog Flux Directory Lewis Cunningham