Solved

export table definition to Oracle

Posted on 2000-05-08
5
1,069 Views
Last Modified: 2008-02-01
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
Comment
Question by:freedmanrp
  • 3
  • 2
5 Comments
 
LVL 10

Expert Comment

by:paasky
Comment Utility
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
 
LVL 10

Accepted Solution

by:
paasky earned 100 total points
Comment Utility
(my address apaasky@hotmail.com)
0
 
LVL 9

Expert Comment

by:ornicar
Comment Utility
You can also use the Oracle Migration Workbench. It can be downloaded from www.technet.oracle.com.
0
 
LVL 10

Expert Comment

by:paasky
Comment Utility
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
 
LVL 9

Expert Comment

by:ornicar
Comment Utility
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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now