Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
sneh gaurav
Greenhorn
Posts: 3
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.....
 
Timothy Schmelter
Greenhorn
Posts: 7
  • 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Sneh,

This is a forum to help provide pointers to learn Java, so you're unlikely to find someone willing to simply review hundreds of lines of source code in multiple files so that they can do your homework for you. To get help here, or on any forum, distill your question to its simplest form, post the minimum amount of code needed to fully express your question, and keep your questions focused. In short, ShowSomeEffort. At a minimum, ask a question. Your post simply said "I need it to work." A worthy goal, to be sure, but hard to define.

Based on the one file I did inspect, you're using a JSP to do *everything*, from database setup to conversion to writing to the new database. This is bad practice; you should be using JSPs for presentation and delegating your business logic (i.e., the tasks of uploading files, converting them, writing to databases, etc) to separate, specialized classes. This allows you to break problems into common parts and reuse solutions in multiple locations, rather than recoding everything from scratch each time.

Best of luck on your project. If you have specific questions, do the work and put together a question here and I'm sure we'll jump on it--this community seems very eager to help out people who want to help themselves.

--Tim
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic