java method/utility/program for database transfer


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: java method/utility/program for database transfer

Hybrid View

  1. #1
    Join Date
    Aug 2004
    Location
    13 00 N, 122 00 E
    Posts
    4

    java method/utility/program for database transfer

    to all geniuses out there,
    does anyone here know a java program that would transfer my MS ACCESS2000 tables to MYSQL?i already know the easy way which is by exporting,what i need is a java program that will do this.i already have done a program that will transfer a mysql database to another mysql database,the problem is i cant do it from msaccess2000 to mysql.i simply cant get the right sql statement to do it.

    >select * into sample from login;
    *sample is the database from mysql*
    *login is the database from msaccess*
    i cant figure out a way so that the tables from the login database(msaccess) will be transfered to sample database which is in mysql.

    any site or example will be highly appreciated...
    thanks

    deckdeck

  2. #2
    Join Date
    Jun 2004
    Posts
    199
    Another way is to create a link to the MySQl table in Access and run the query. That should work. I've done it with MS Access and SQL Server. And I think DB2.

    But if you have to do it from Java there is an Eclipse plugin for copying databases that are accessable from JDBC - http://dbcopy.sourceforge.net/en/dbcopy/index.html.
    I've not use it yet.

  3. #3
    Join Date
    Aug 2004
    Location
    13 00 N, 122 00 E
    Posts
    4
    mnuttall,
    i am pretty new in java programming and i dont know how to make links from access to mysql.how did u do it?could you show me some of your codes???and by the way the link you have given me is not workin, i wil try to check it later.
    nwy,i rily do apreciate the reply.thanks...

    deckdeck

  4. #4
    Join Date
    Jun 2004
    Posts
    199
    http://dbcopy.sourceforge.net/en/dbcopy/index.html

    Somehow a period got on the end. Pretty easy to solve.


    Links have nothing to do with Java. You do those in Access. Create a new table and do a link.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center