aspose file tools*
The moose likes JSP and the fly likes I need help with Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSP
Reply locked New topic
Author

I need help with "primary and foreign key" in my data migration code

sneh gaurav
Greenhorn

Joined: May 07, 2011
Posts: 3
Hi
i am a student and i am in a jam over how to migrate between databases while keeping the primary key and foreign key intact.....

the conversion are of six types....

1. MS Access to MS SQL
2. MS Access to Oracle
3. MS SQL to Oracle
4. MS SQL to MS Access
5. Oracle to MS SQL
6. Oracle to MS Access

all the coding is done in jsp.

its my final year and i need this to work.....

Links to my jsp which contain the code..
open in notepad or any text editor.

http://www.mediafire.com/?3k04g5ydpllvs79
http://www.mediafire.com/?dc88aa4lu9ju690
http://www.mediafire.com/?7bfox2u8t2o88r2
http://www.mediafire.com/?iq1erf5ck7xf15u
http://www.mediafire.com/?wqfai85npy95b9e
http://www.mediafire.com/?hsssicizbesr76k
http://www.mediafire.com/?0q8436pbswrytwu
Matthew Brown
Bartender

Joined: Apr 06, 2010
Posts: 4464
    
    8

[Duplicate of http://www.coderanch.com/t/537056/ORM/java/help-primary-foreign-key-data]

Hi Sneh,

Welcome to The Ranch!

Can you stick to one thread per question, please? Thanks. I've locked this one, as although the code may be in JSP it's database related, so the other forum seems more appropriate.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: I need help with "primary and foreign key" in my data migration code