Ask Experts Questions for FREE Help !
Ask
    jonmich's Avatar
    jonmich Posts: 12, Reputation: 1
    New Member
    		  
    #1

    Mar 23, 2005, 12:23 AM
    From access to oracle
    Hello

    Can anyone help me, I have to convert an access database to an oracle database.
    Is there someone who can help me?
    LTheobald's Avatar
    LTheobald Posts: 1,051, Reputation: 127
    Ultra Member
    		  
    #2

    Mar 23, 2005, 05:55 AM
    Try the Oracle Migration Workbench (free download):

    http://www.oracle.com/technology//te...nch/index.html
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #3

    Mar 23, 2005, 06:41 AM
    The tool LT linked to looks good. However, since Access and Oracle are very different tools, it might be better to design the database in Oracle taking advantage of Oracle's strengths. Then Append the data to the Oracle tables. You can do this by connecting to the Oracle database from within Access using ODBC. Then run append queries, adding the data to the Oracle tables as appropriate.
    jonmich's Avatar
    jonmich Posts: 12, Reputation: 1
    New Member
    		  
    #4

    Mar 23, 2005, 06:58 AM
    I don't understand
    Could yo give me a litle bit more explanation Scott?
    I don't quite understand what you mean
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #5

    Mar 23, 2005, 04:46 PM
    What didn't you understand. Not sure how I can restate it.
    jonmich's Avatar
    jonmich Posts: 12, Reputation: 1
    New Member
    		  
    #6

    Mar 23, 2005, 11:48 PM
    How I have to append the data to the oracle database?
    Is this just by export in the menu?
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #7

    Mar 24, 2005, 06:32 AM
    No, you have to create an Append query. Very likely, the structure in Oracle will be different then the structure in Access. Not vastly different, but possible different enough so that you can't just copy table to table.

    Look up Append queries in Access Help. It will explain how to create them.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Oracle [ 3 Answers ]

Hi, I just installed Oracle 9i,I have been working on oracle since one year(in college).At that time I was not requiring to use the oracle options i.e. I did'nt needed to specify which database serivice to use and all that I just had to run query in SQL *plus. At this time I am working...

Oracle [ 2 Answers ]

What is the diffrence between oracle database and oracle 9i developer suite

Oracle Software [ 2 Answers ]

Please provide the list of Oracle customer lists

Oracle 8i [ 2 Answers ]

We are in Oracle platform based application development. We are user Developer6i as front-end. We are facing a big problem regarding implemenation of the executables. We have to install all the forms FMX files there at client side. Is there is any way to combine all the executable objects into...

View more questions Search