If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Oracle > Conversion from DB2 to Oracle

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Nov 2012
Posts: 4
Conversion from DB2 to Oracle

Hi,
I would like to migrate a DB2 database to Oracle without using the Oracle PL SQL Developer migration tool. I would like to use some batch scripts to achieve the same. Is it possible to convert DB2 scripts to Oracle specific scripts by using some commands from CLP?
Thanks in advance,
Fighter
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 7,594
>Is it possible to convert DB2 scripts to Oracle specific scripts by using some commands from CLP?


what is "CLP"?
__________________
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Don't say, show. Don't promise, prove.
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Oct 2010
Location: Orlando, FL
Posts: 261
CLI maybe? He's wanting to use manual created scripts rather than a migration tool. I'm assuming he meant 'CLI'.
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Nov 2012
Posts: 4
Hi,
Yes I meant CLI. Is it possible?

Thanks and Regards
Fighter
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 7,594
>Yes I meant CLI. Is it possible?
In the future please be more vague describing what you have & what you want to make providing answers & solutions more challenging.
Since we don't know your Operating System name or version, it is difficult to know what is available via the "CLI".
What exactly do you expect or desire to be the output/results?
Does DB2 have the ability to produce DDL & DML that reflects the existing application?
__________________
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Don't say, show. Don't promise, prove.
Reply With Quote
  #6 (permalink)  
Old
Registered User
 
Join Date: Nov 2012
Posts: 4
The DB2 version I have is DB2 v9.5.0.5 (Fixpack 5). The Oracle version I have is Oracle Database 11g Enterprise Edition 11.2.0.2.0. DB2 offers command line tools which helps us in extracting the DDLs of all the entities in the DB2 database.DB2 also offers tools to create INSERT statements in DB2 language. Now, I have to convert this DB2 specific insert statements into Oracle specifc Insert statements. In fact, we can assume that the schema in Oracle is already present. So the requirement is to move the data from DB2 to Oracle using SQLPlus commands.
Thanks,
Fighter
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On