Results 1 to 10 of 10
  1. #1
    Join Date
    Aug 2003
    Posts
    9

    Unanswered: Urgent:Migration from MS-Access to Oracle

    Hi All,
    I am in an urgent need of migrating an Access table to a similar table in Oracle.Oracle table should be created at run time.

    Basic Procedure as far as i know

    1.Retrieve the database structure of the access table to be migrated

    2.Analyse the structure and create a similar database structure in Oracle.

    3.The no. of fields and it's datatype of the destination(Oracle) should match correctly with the source(Access).

    4.After the model has been created,the data is sent from Access to Oracle.

    I have to do this in java.So kindly help me out by giving me the java coding for doing the migration

    Thanks in Advance

    Regards
    Frank

  2. #2
    Join Date
    Jan 2004
    Location
    Somewhere on the 3rd planet.
    Posts
    13
    /*
    Tell your employer, there's a good one here :-)

    I also recommend you to look here:
    http://java.sun.com/j2se/1.3/docs/ap...tMetaData.html

    Also check out if the Access type names are OK with Oracle.

    And yes. I bet your next posting would be:
    "how to create a table with java?" :-)) No offence meant.
    */

    //Demonstrates accessing to the column names and types.
    import java.io.*;
    import java.sql.*;

    public class TableCols {
    public static void main(String [] args) {

    Connection con;
    Statement stt;
    ResultSet rs;
    ResultSetMetaData rsmd;
    int cols;
    try {

    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newI nstance();
    try {
    conStud = DriverManager.getConnection("YourDataSource", "YourID", "YourPass");
    } catch (Exception ex) {throw new Exception(ex.getMessage());}

    stt = con.createStatement();

    rs = stt.executeQuery("select * from YourTable");

    rsmd = rs.getMetaData();
    cols = rsmd.getColumnCount();

    for(int i=1; i<cols; i++) {
    System.out.println(rsmd.getColumnName(i));

    //HERE - output of column type
    System.out.println(rsmd.getColumnType(i));

    }
    rs.close();
    stt.close();
    con.close();

    }
    catch (ClassNotFoundException ex) {
    System.out.println("Donnerwetter! CNFE : "+ex.getMessage());
    }
    catch (SQLException ex) {
    System.out.println("Donnerwetter! SQL : "+ex.getMessage());
    }
    catch (Exception ex) {
    System.out.println("Donnerwetter! Exception : "+ex.getMessage());
    }
    }

    }
    Best regards,
    WGM

  3. #3
    Join Date
    Aug 2003
    Posts
    9
    hi wgm,
    Can you give me the full coding

  4. #4
    Join Date
    Jan 2004
    Location
    Somewhere on the 3rd planet.
    Posts
    13
    I could, but they definitely are not paying me your money.
    I've told you where to start. So, play around.
    Best regards,
    WGM

  5. #5
    Join Date
    Aug 2003
    Posts
    9

    Thumbs up Money

    Hi wgm,

    How much you want.Let's go for a deal.

    Regards
    Frank

  6. #6
    Join Date
    Jan 2004
    Location
    Somewhere on the 3rd planet.
    Posts
    13
    Look at your e-mail box.
    It's all there.
    Best regards,
    WGM

  7. #7
    Join Date
    Aug 2003
    Posts
    9

    Thumbs up Thanks a Lot

    Hi WebGm,

    Thanks a Lot for the coding.I appreciate your generousity towards me.Definitely in the future ,I need your full co-operation. Give me ur address so that I can send u something which I can afford.

    Thanks a Lot once again.


    Regards
    Frank

  8. #8
    Join Date
    Aug 2003
    Posts
    9

    Smile HI

    Hi wgm,

    How r u doing .ur coding was damn superb.What abt ur address man! Keep in touch.


    Regards
    Frank

  9. #9
    Join Date
    Jan 2004
    Location
    Somewhere on the 3rd planet.
    Posts
    13
    Hi, Marian
    Sorry for not being online for a reasonable time. It's all about the thing that I've changed my job and have been getting used to it.

    I'm glad that you've liked my prog.

    You can send me an e-mail using the form at my profile at this site. Just click my nickname under the avatar. The server will tell me that it was YOU who've sent me an email, so I'll know who's asking.

    Hope to hear from you very soon.
    Best regards,
    WGM

  10. #10
    Join Date
    Aug 2003
    Posts
    9

    Smile Urgent :Access constraints

    Hi wgm,
    I migrated Access data and it's tables from Access to Oracle using JAVA. But i am not able to migrate the table's constraints .
    Regarding this ,help me how to migrate the constraints, indexes etc.,.
    I also want to know the location where these internal tables(representing the relationships and the constraints) are located and how to retrieve them. I have to do this using java.Kindly help.

    Waiting for ur reply.Thanks in advance.



    Regards
    Marian Franklin.J

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •