11-08-13, 15:46 #1Registered User
- Join Date
- Sep 2013
Unanswered: converting DDL from DB2 to Oracle
This is the first time i'm converting a db2 luw 9.7 fp 8 database structure (no data) into Oracle 11.2. I've been trying sql developer for few days but the migration wizard is just not moving past the "creating tables" phase under "installing repository" phase of the migration. i haven't waited longer than 2 hours though - I feel as if it shouldn't take so long to convert just the structure
I read that i could multi-select the tables and then "copy to oracle" but that omit's relationships (SQL Developer: Migrating Third-Party Databases). I could take this route granted an easy process to set up parent-child relationships.
Could someone please guide me towards light on an automated process to convert my db2 database objects with relationships.
11-08-13, 15:51 #2Registered User
Provided Answers: 1You can lead some folks to knowledge, but you can not make them think.
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.