|
Access-to-Oracle is a program to migrate Microsoft Access databases to
Oracle server.
Features
- All versions of MS Access (including MS Access 2010) are supported
- All versions of Windows and Unix Oracle servers are supported
- Converts indexes with all necessary attributes
- Converts password protected MS Access databases
- Converts MS Access databases protected with user-level security
- Option to convert partial data using SELECT-queries
- Option to convert individual tables
- Option to merge MS Access data into an existing Oracle tables
- Option to synchronize Oracle database with MS Access data
- Stores conversion settings into profile
- Command line support
- Quick Launch
- Easy-to-use wizard-style interface
- Full install/uninstall support
Limitations
- Convert MS Access tables only (forms, queries, reports are not supported)
- Does not convert system (hidden) tables
Requirements
- MS Access installation
- Necessary privileges to write into the destination database
|
|
|
Quick Lauch
Synchronization
People(
ID Integer NOT NULL,
FName Text(50)/VARCHAR2(50),
LName Text(50)/VARCHAR2(50),
EMail Text(50)/VARCHAR2(50),
Primary Key (ID)
);
This table has the following contents in MS Access database:
2 |
Andrew |
White |
a.white@corporation.com |
3 |
Phil |
Johnson |
p.johnson@gmail.com |
In Oracle database:
1 |
John |
Smith |
j.smith@msn.com |
2 |
Andrew |
White |
a.white@yahoo.com |
After migrating MS Access data to Oracle in "Synchronize"
mode MS Access table is kept untouched and Oracle table is modified as
(pay attention to the cell marked red):
1 |
John |
Smith |
j.smith@msn.com |
2 |
Andrew |
White |
a.white@corporation.com |
3 |
Phil |
Johnson |
p.johnson@gmail.com |
Try before you buy
Ordering
|
|