Re: Tool for Access 2000 to Oracle

From: Elaine <perfectp_at_alaska.net>
Date: 2000/04/30
Message-ID: <vnQMOXXPg1q6LABmYmeWXuE9Ls0v@4ax.com>#1/1

ER Studio from Embarcadero may be able to snag the Access table structure and create the Oracle DDL from that. (I'm just testing it at work in between a major project deadline.)

But you may not want the exact structure in Oracle that you have in Access, because of the ability to create db level triggers, etc. How much do you know about using Oracle?

Plan, plan, plan, or you won't get the performance you want at all. Some things Oracle does majorly faster than Access, and other times it's quicker to make a temp table in Access, snag the data from Oracle, and use Jet to, for example, find unmatched or duplicate data.

I personally would probably not convert, but rather would use a tool like SQL Navigator (Quest (?) Software) to create the tables, indice, views, and triggers in Oracle, then port the Access data in.

IOW, you'll need to look at the process as practically a new project.

HTH,
Elaine

On Fri, 28 Apr 2000 15:50:50 -0400, <A_at_A.COM> managed to spit out:

>Is there a tool that will allow me to migrate from an Access 2000 to an
>Oracle database?
>
>I know there is a Workbench application, but according to the FAQ there is
>no support for Access 97.
>
>Please copy me on your reply at robertnzana_at_mindspring.com
>
>Thanks in advance.
>

Elaine Nance
Consultant - Developer
Juneau, Alaska

---

Computers are useless. They can only give you answers.

• Pablo Picasso --

  ---

Some Access links:
ATTAC Consulting Group - MS Access Tips & Code

        http://ourworld.compuserve.com/homepages/attac-cg/ATip.htm Tony's Main Microsoft Access Page

        http://www.granite.ab.ca/accsmstr.htm
Trevor's MS Access FAQ

        http://easyweb.easynet.co.uk/~trevor/AccFAQ/ C. Tripp's Developer and Job Search Links to Everywhere

        http://www.candace-tripp.com Received on Sun Apr 30 2000 - 00:00:00 CDT