By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,408 Members | 1,840 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,408 IT Pros & Developers. It's quick & easy.

Migrating from Access to Oracle

P: 60
hi..
i need ur help in switching from MSAccess to Oracle.

And this is my problem:
Currently im having a lot of records in access(which is currently our back-end).
Now i want to switch from Access to Oracle. I've to move all the records(a huge data base) in the Access database to Oracle.
Being new to this i dont know how to get with it!!!!!
Please help me in my problem. Is there any tool availale to over come this?
Waiting for your replies..........
Mar 1 '07 #1
Share this Question
Share on Google+
9 Replies


100+
P: 153
hi..
i need ur help in switching from MSAccess to Oracle.

And this is my problem:
Currently im having a lot of records in access(which is currently our back-end).
Now i want to switch from Access to Oracle. I've to move all the records(a huge data base) in the Access database to Oracle.
Being new to this i dont know how to get with it!!!!!
Please help me in my problem. Is there any tool availale to over come this?
Waiting for your replies..........

How many rows are we talking about?
Are the table structures going to be identicle?
Are you able to take the database offline while making the move?
Mar 1 '07 #2

P: 16
there is an oracle tool that do this.

if you don't find that.

you can do an odbc connection from access to oracle and then insert your data
from access to oracle

but first check for the oracle tool it's a good tool and it works fine




How many rows are we talking about?
Are the table structures going to be identicle?
Are you able to take the database offline while making the move?
Mar 4 '07 #3

P: 60
its not a matter of rows.........
its the matter of a number of tables the data base....
Mar 4 '07 #4

P: 60
Since im new to this concepts....... can you please tell me something about that tool....? what tool is it and how to use it?
Mar 4 '07 #5

10K+
P: 13,264
Changed thread title.
Mar 6 '07 #6

P: 16
Since im new to this concepts....... can you please tell me something about that tool....? what tool is it and how to use it?
check taht

http://download-east.oracle.com/docs/html/B10255_01/ch1.htm#1023960
Mar 7 '07 #7

P: 2
Please take a look at this link. APEX is a very nice product from Oracle that will allow you to build a web based application.

http://www.oracle.com/technology/products/database/application_express/migrations/mig_index.html
Mar 7 '07 #8

venkataramana22
P: 5
hi..
i need ur help in switching from MSAccess to Oracle.

And this is my problem:
Currently im having a lot of records in access(which is currently our back-end).
Now i want to switch from Access to Oracle. I've to move all the records(a huge data base) in the Access database to Oracle.
Being new to this i dont know how to get with it!!!!!
Please help me in my problem. Is there any tool availale to over come this?
Waiting for your replies..........

hi palani,
to transfer tables fom access try dis

convert the access tables into text files
and create a ctl file for that,in that ctl file u have to menssion in oracle in which table u want to dump.
for that u have to create a strucure in in oracle.
after that in cmd promt
type......

sqlldr scott\tiger@<hostname> <path of ctl file with extension>
dis will solve ur problem
example of ctl file.......type in notepad and save it as .ctl

load data
infile 'f:\rc.txt'
insert into table alarmtype
fields terminated by ','
(CardNo,Enabled,CardID,Staff,Holder,DepartmentNo,P ositionName,PIN,
UserDefinable1,UserDefinable2,Site,Area,StartDate, ExpiredDate,Photo,Description)
Mar 14 '07 #9

P: 60
Thank you for your help.
I'll try those things and see whats happennig
Mar 14 '07 #10

Post your reply

Sign in to post your reply or Sign up for a free account.