aspose file tools*
The moose likes Object Relational Mapping and the fly likes Free Database Migration tool Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Free Database Migration tool" Watch "Free Database Migration tool" New topic
Author

Free Database Migration tool

mike La
Greenhorn

Joined: Jul 15, 2005
Posts: 5
Hi,
Does anyone know a free Database Migration tool from MS access to Oracle ?

Regards,
Mike
Mishra Pr
Greenhorn

Joined: Jul 15, 2005
Posts: 2
The free tool MigrateMSAccess at http://akcess.in/MigrateMSAccess.html supports Oracle and SQL server as target database to migrate from MS-Access.


Regards,
Mishra


Originally posted by mike La:
Hi,
Does anyone know a free Database Migration tool from MS access to Oracle ?

Regards,
Mike
Mishra Pr
Greenhorn

Joined: Jul 15, 2005
Posts: 2
Free tool DBMigration at http://akcess.in/DBMigration.html supports Oracle, SQL server, MySQL and PostgreSql as source and target database.

It generates data definition script, which contains statements for the primary key, foreign key and indexes apart from the drop table and Create table statements apart from generating DML statements for data insertion, data files and other supporting files for migration.

Regards,
Mishra.



Originally posted by mike La:
Hi,
Does anyone know a free Database Migration tool from MS access to Oracle ?

Regards,
Mike
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17250
    
    6

Another solution is to export the Access data into a delimited text file and use sqlldr for loading it into Oracle. You would need to set up the database table structures first.

Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
 
Consider Paul's rocket mass heater.
 
subject: Free Database Migration tool