JoachimGermer
Programmer
How can I migrate Oracle 7.1 Unix to IBM DB2 very easy
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How can I migrate Oracle to IBM DB2 1
- Thread starter JoachimGermer
- Start date
- Status
-
1
- #2
Guest_imported
New member
- Jan 1, 1970
- 0
- 0
- 0
If it's consulting help you need, my company specializes in these migrations. We have tools to handle not only the data but also the stored procedures, triggers, etc. Automation is about 80%. See us at
Guest_imported
New member
- Jan 1, 1970
- 0
- 0
- 0
The utility program nxtract converts oracle dump files to a format that DB2 reads.
use google to find the details on nxtract.
use google to find the details on nxtract.
Your migration will be easier if you try the following steps:
- export your data of your tables to flat files;
- pay attention to date format: convert these dates into char format that db2 understands: it will be easier to do that if you use views to perform this conversion when exporting the data to flat files.
- export your data of your tables to flat files;
- pay attention to date format: convert these dates into char format that db2 understands: it will be easier to do that if you use views to perform this conversion when exporting the data to flat files.
- Status
Similar threads
- Locked
- Question