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.

Take care,