EnterpriseDB announced some significant advances with their latest EnterpriseDB Advanced Server release. You can read an article at Sys-Con.
They've made several improvements but the three I think most important are the Automated Migration tool, the replication server and the multi-platform Developer Studio.
You can get more info about these at the EnterpriseDB product page
but a quick run down is that the the automated migration tool can log
into an Oracle instance and migrate the entire schema to an
EnterpriseDB database. Kind of cool actually.
More important I
think are the other two. The replication server can replicate between
Oracle and EnterpriseDB. That means data can go back and forth, not
just one way. I don't mean multi-master, which it's not. I mean that
you can use Oracle as a slave to an EnterpriseDB database or an
EnterpriseDB slave to an Oracle database. It can also replicate to and
from PostgreSQL. I'm doing some research right now on how that works
and I'll post more in the future.
The last really significant tool is Developer
Studio. That's the EnterpriseDB IDE for developers (sort of a
multi-database SQL Developer). It can run on multiple platforms and can
connect to Oracle, PostgreSQL and EnterpriseDB. There is also a source
level PL/SQL and PL/pgSQL debugger included. I'm also playing with this
and will have an update in the future.
If you're not familiar with EnterpriseDB, I've blogged about it in the past. Hard to believe it's been over a year since I first downloaded it.