We’ve recently engaged in a large Oracle to PostgreSQL migration project here at the old dayjob. While this isn’t extraordinary in its own right, it is a bit unique due to the size of the installation and the fact that while it is migrating away from Oracle, it isn’t getting very far from Oracle. So, how big is big? We have thousands of tables, some small (a few hundred rows) and some a bit larger (not the largest table, but a big one I can afford to run a select count() on): postgres=# select count() from ods.
It was a pleasure speaking at OSCON2005 on Wednesday on the topic of cross-vendor database replication approaches. Many attendees requested that I put the slides online. While there is a tremendous amount of commentary and critique that goes with the slides, I hope that they will be somewhat useful to a more general audience. Alas, here they are: DB Replication PDF DB Replication Keynote stack
