Linux SoftwareDatabaseDatabase APIsJDatabaseImport 0.1

JDatabaseImport 0.1


JDatabaseImport is a simple tool created to import data between different databases. How does it work? You can work with it in
Developer:   Guilherme Silveira
      more software by author →
Price:  0.00
License:   The Apache License 2.0
File size:   0K
Language:   
OS:   
Rating:   0 /5 (0 votes)
Your vote:  
enlarge screenshot


JDatabaseImport is a simple tool created to import data between different databases.

How does it work?

You can work with it in two ways, either using a configuration file or accessing its api using Java.

Example:

The following code show an example of a file called *export.xml*:

< export >
< from >
< driver >org.hsqldb.jdbcDriver< / driver >
< url >jdbc:hsqldb:hsql://localhost/source< / url >
< username >sa< / username >
< password >mysapass< / password >
< / from >
< to >
< driver >com.mysql.jdbc.Driver< / driver >
< url >jdbc:mysql://localhost/target< / url >
< username >root< / username >
< password >myrootpass< / password >
< / to >
< table name="firstTable"/ >
< table name="secondTable" >
< ignore >fieldToBeIgnored< / ignore >
< / table >
< table name="thirdTable"/ >
< / export >

Note that JDatabaseImport *will not* generate the target tables, but only import data from one source into the other.

In order to run JDatabaseImport, you need to put all drivers in the classpath and run it. The following code is an example on how to use it to import from mysql to hsqldb
java -cp mysql-connector-3.1.1.jar:hsqldb.jar:jdatabaseimport.jar br.com.caelum.jdatabaseimport.Main export.xml

What's New in This Release:
  • This initial release has been tested with hsqldb, MySQL, Derby, and Oracle using some field types and different configurations.
    tags table name  url username  username password  url jdbc  driver url  the following  following code  import data  

    Download JDatabaseImport 0.1


     http://prdownloads.sourceforge.net/jdatabaseimport/jdatabaseimport-0.1-all.zip?use_mirror=jaist
     http://prdownloads.sourceforge.net/jdatabaseimport/jdatabaseimport-0.1-all.zip?use_mirror=superb-east
     http://prdownloads.sourceforge.net/jdatabaseimport/jdatabaseimport-0.1-all.zip?use_mirror=easynews


    Authors software

    VRaptor 2.2.3 (by Guilherme Silveira)
    VRaptor is a web based mvc and ioc framework which was based on many frameworks and ideas (Seam, Stripes, Hibernate Annotations, Webw

    Pulga 1.1.4 (by Guilherme Silveira)
    Pulga is a program for numerical simulation of dynamical systems

    JDatabaseImport 0.1 (by Guilherme Silveira)
    JDatabaseImport is a simple tool created to import data between different databases.

    How does it work?

    You can work with it in


    Similar software

    JDatabaseImport 0.1 (by Guilherme Silveira)
    JDatabaseImport is a simple tool created to import data between different databases.

    How does it work?

    You can work with it in

    Easysoft ODBC-JDBC Gateway 2.0 (by Easysoft Limited)
    Easysoft ODBC-JDBC Gateway lets ODBC-enabled applications such as Business Objects, Microsoft Access, Microsoft Excel and Microsoft S

    Java SQL Admin Tool 2.4.0 (by Fredy Fischer)
    Admin is entirely written in Java

    DBD::mSQL 1.2219 (by Jochen Wiedmann)
    DBD::mSQL / DBD::mysql is a Perl module with mSQL and mysql drivers for the Perl5 Database Interface (DBI).

    SYNOPSIS

    use DB

    DBD::mysql 3.0007 (by Jochen Wiedmann)
    DBD::mysql is a Perl module with MySQL driver for the Perl5 Database Interface (DBI).

    SYNOPSIS

    use DBI;

    $dsn = "DBI:

    Gaudi - Database Visual Editor 1r1 (by Memoria Persistente)
    Gaud? - Database Visual Editor is a Java application that allows you to visually design the tables of a database using a JDBC 2.0 (or

    Gentry 0.1.11 (by Ed Davison)
    This program stemmed from a need to be able to data enter data into an SQL table without having to actually type the SQL over and ove

    db2dot 0.2.2 (by db2dot Team)
    db2dot reverse engineers an existing database and produces an ER diagram in dot format.

    The dot file can be fed through graphviz's

    hsqldb Database Engine 1.8.0 (by The hsqldb Development Team)
    HSQLDB is the leading SQL relational database engine written in Java

    MyJSQLView 2.63 (by MyJSQLView Team)
    MyJSQLView provides an easy to use Java based user interface frontend for viewing, adding, editing, or deleting entries in a MySQL da


    Other software in this category

    db4o 8.0 (by Carl Rosenberger)
    db4o is designed to be a simple, easy-to-use, and fast, native object database

    MetaBoss 1.4.0001 (by metaboss)

    Sequoia 2.10.3 (by Emmanuel Cecchet)
    Sequoia is a transparent middleware solution for offering clustering, load balancing and failover services for any database

    PHP Generic Access Control List 3.3.7 (by IpSo)
    PHP Generic Access Control List is a PHP class that offers Web developers a simple, yet immensely powerful "drop in" permission syste

    phpDVD 1.0.4 (by Ugo Scarlata)
    phpDVD is a simple PHP script to keep track of your DVD collection

  •     search


    Featured Software

    jEdit 4.3 pre8
    jEdit is an Open Source text editor written in Java

    Opera 9.02
    Surf the Internet in a safer, faster, and easier way with Opera browser

    GNU Aspell 0.60.4
    GNU Aspell is a Free and Open Source spell checker designed to eventually replace Ispell


    Subscribe in Rojo
    Google Reader
    Add to My Yahoo!

    Add to My AOL
    Subscribe with Bloglines
    Subscribe in NewsGator Online
    Add 'nixbit linux software' to Newsburst from CNET News.com
    del.icio.us nixbit linux software


    Top tags