We're about to enter the second year of planning our next big Oracle migration. LOL Every time it gets close, they get cold feet and delay again.

The criticality of the system is off the charts, so any error would end up front page news. I get it. But, at some point, you have to just bite the bullet.

Reply to this note

Please Login to reply.

Discussion

I don't know how big your system is but my experience is that this is a lot easier than what it seems, especially if you have good testing. I was able to build tests and translate 40 plsql stored procedures every day. After you learn the gotchas, the rest is easy. And I can only imagine that the language now is a lot similar than what it was back in the day.

Biggest and most-critical one I've ever migrated. And no downtime, ever, so it has to be migrated in production.

They hired me, just to test moving this one database. That's how bad it is. LOL