Converting MS Access Queries to Oracle SQL

[CharlieMike73]

Hi,

Can anyone tell me of a good tool to convert Microsoft Access Queries to the Oracle Syntax?

I can find plenty to convert to MySQL and other RDBMS, but not for Oracle!

All help is appreciated.

Thnx,
Charlie

 

[CharlieMike73]

I shouold add . . .

We have a MS Access Frontend which has many many Access queries connecting to the Oracle tables, and I need to migrate the queries from access to pure Oracle; there are too many to do manually so I want to know if anyone knows of a tool to convert them quickly (one at a time or all at once).

As this is a once off task, a free app. or fully functional trial would be pref.

Any help is appreciated.

 

[DBAwhosaysNIE]

I haven't used it since '97 but Oracle has a "migration workbenck" for M$ Access (assume they still do). I would guess it would convert query objects in your mdb to views.

if you have a copy of ERWin that would probably do it too (convert Access query objects to views).

one problem you could have is if you have raw SQL in forms/reports (instead of table/query references) though pasting the SQL into query objects should at least get you a converted string you could bind via ODBC (if you're keeping Access as a UI). the biggest problem I can see you might have is if you have VBA code that dynamically generates SQL strings in which case you're probably screwed.

I did a bunch of this in 97/98 but have been out of the Access business for some time so there may be newer tools/techniches I'm not up on.

good luck!

 

[CharlieMike73]

Thnx for the reply, I am going to the web (intranet) for the UI Leaving Access all together where possible (so far looking like 99%-100% escape) pending a time saving query convertion.

It is not so much knowing the syntax, its the sheer number of queries to be converted and the time it takes to recode each one and test them.

Anyone else with other ideas please feel free to jump in!

Anyway, thank you DBAwhosaysNIE.