Mike29Palms
Instructor
What is the least painful way to convert an Access 2000 database to Oracle 9i? Are there any utilities to assist me or do I have to do everything manually? Any help would be greatly appreciated.
T
T
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Converting Access to Oracle 1
- Thread starter Mike29Palms
- Start date
- Status
-
1
- #2
Hi,
It depends on how many tables are involved and whether ypou want to trty and convert Query based tables and other Access-specific stuff.
Oracle has a Migration Workbench that can handle most conversion needs if yours is a complex Access database.
( you may need to register..do so, its free and they don't spam you)
If you simply want to create tables in Oracle , use the Export ( to an ODBC database) option from the File menu ( First, however, be sure that all table and field names are all UPPERCASE and that no 'special characters ( like spaces) are in the names).
If you have MEMO fields, change them to Text before exporting to make them easier to use in Oracle.
![[profile]](/data/assets/smilies/profile.gif "[profile] [profile]")
It depends on how many tables are involved and whether ypou want to trty and convert Query based tables and other Access-specific stuff.
Oracle has a Migration Workbench that can handle most conversion needs if yours is a complex Access database.
( you may need to register..do so, its free and they don't spam you)
If you simply want to create tables in Oracle , use the Export ( to an ODBC database) option from the File menu ( First, however, be sure that all table and field names are all UPPERCASE and that no 'special characters ( like spaces) are in the names).
If you have MEMO fields, change them to Text before exporting to make them easier to use in Oracle.
- Status
Similar threads
- Locked
- Question
- Locked
- Question