Re: Oracle RDB on VAX/Open MVS

Metalink Note: 135929.1 may get you started. A google search comes up with some migration service providers. If you don't have metalink access - get it.

Been too many years since I've been on Rdb to comment in more detail, but Oracle's locking model is different, so that might be the most fundamental change in your apps. See the concepts manual at tahiti.oracle.com, see the sql manual for data type issues. See Tom Kyte's books for how to do your apps right, and some hints on how to migrate db apps specific to other db engines. Here's the dialect comparo: http://download-west.oracle.com/docs/html/A53248_01/toc.htm

So much of this depends on exactly what has been done in your apps, it's hard to say what needs to be done. The further from plain-ol'-SQL you've gotten, the more work there will be. The data migration part will likely be the simplest.

There are cross-db languages and tools, but they do you no good unless you are already using them. Since they tend to be lowest-common-denominator, you would be better off doing a migration directly to native Oracle, where there are many advanced features.

jg

-- 
@home.com is bogus.
http://www.traipse.com/thing_in_a_jar/