• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1115
  • Last Modified:

export table definition to Oracle

How do I export the table definitions of an Access database (including column names, field types and sizes) so I can run create table SQL in Oracle?
0
freedmanrp
Asked:
freedmanrp
  • 3
  • 2
1 Solution
 
paaskyCommented:
freedmanrp, send me your email address and I will send you an MSAccess97 to Oracle utility I've done for my own use.

Regards,
paasky
0
 
paaskyCommented:
(my address apaasky@hotmail.com)
0
 
ornicarCommented:
You can also use the Oracle Migration Workbench. It can be downloaded from www.technet.oracle.com.
0
 
paaskyCommented:
ornicar, is it same that cames with Oracle installation CD-ROM? If it is, it requires connection to Oracle database to work and doesn't create SQL files... that's why I decided to create tool of my own. I can email it to anyone who is interested.

Regards,
Paasky
0
 
ornicarCommented:
Hi Paasky,
You are right, it does not create sql scripts.
I am very interrested in your tool me too, could you email it to me? I would be very pleased (Edited by C101))
Thanks, and again, you are doing a great job!
Cheers.
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now