Re: moving to Oracle need recomendations...

Bill Lucas,

I'm late to the party on this topic, so I'm sorry if my comments are out of place.

A few years back, I had to work on transferring data and data definitions from DEC Rdb databases to Oracle databases. DEC Rdb was actually bought out by Oracle in 1994, and now known as "Oracle Rdb". But it's still quite different, internally, from "Oracle classic", and should not be confused with what everyone knows as "Oracle".

Anyway, one very convenient vehicle for moving the metadata was a component of Power Designer called "Data Architect". It had facilities for reverse engineering a data model from an Rdb Database, and then converting the model from Rdb product specific to Oracle product specific, and then generating a create script. It sure took a lot of the dog work out of the conversion. My expectation is that a conversion from SQL server would be just as easy for DA to help with.

This doesn't address migrating the data, migrating the application code, or familiarizing yourself with the concepts. Migrating the data was even easier than migrating the model. Migrating the application turned out to involve a lot of rewriting at the same time, so the issue became moot. And changing your head set is probably the hardest part of the migration.

Good luck. Received on Wed Oct 16 2002 - 12:18:42 CDT