!?Access Oracle Oracle Migration Workbench MS-Access Oracle Creation Date: Oct 01, 2004 Last Update: Mar 08, 2005 Version: 1.1
!? Oracle Database 10g / GUI!? / Standard Edition!? /!?!? Oracle Database 10g Access Oracle.NET Oracle Windows!? Access Oracle Microsoft Access Oracle Oracle Migration Workbench Access Oracle 1. Oracle Migration Workbench 2. Oracle Migration Workbench for Microsoft Access 3. Oracle 4. Access 5. 3 Access / Oracle 4 -!? Access Oracle Oracle Migration Workbench - 2
PC OS: Microsoft Windows 2000 Professional + SP4 AP: Microsoft Access 2000 OS: Microsoft Windows 2000 Professional + SP4 DBMS: Oracle Database 10g Standard Edition for Windows -!? Access Oracle Oracle Migration Workbench - 3
Oracle Migration Workbench Oracle Migration Workbench Migration Workbench / OMWB Oracle Database Oracle8i /9i Oracle Database 10g Migration Workbench Migration Workbench Access Oracle Migration Workbench Migration Workbench 100% Pure Java GUI Migration Workbench Workbench 2 Oracle Database Migration Workbench 2005/2 Microsoft SQL Server 6.5,7.0,2000 Microsoft Access 2.0,95,97,2000 -!? Access Oracle Oracle Migration Workbench - 4
Migration Workbench 1 SQL*Loader -!? Access Oracle Oracle Migration Workbench - 5
Oracle Migration Workbench for Microsoft Access Access Migration Workbench PC PC Migration Workbench OS Access Access (mdb) PC Access Access Access 2000 Access 2000 Oracle OMWB Oracle Technology Network Japan OTN-J 2005/02/28 10.1.0.2 Oracle Migration Workbench 10.1.0.2 Omwb.zip Microsoft Access MSAccess.jar Oracle Migration Workbench Oracle Migration Workbench -!? Access Oracle Oracle Migration Workbench - 6
Oracle Migration Workbench Oracle Migration Workbench Microsoft Access 2.0 95 97 2000 9.2 for Microsoft Windows 98/2000/NT and Microsoft Windows XP 2005/02/28 Migration Workbench Web http://otn.oracle.co.jp/software/tech/migration/ ODBC Access ODBC Microsoft Data Access Components MDAC Microsoft Web http://www.microsoft.com/japan/msdn/data/ 1. Windows [ ] [ ] [ ] [ ] ODBC ODBC 2. 3. Microsoft Access Driver(*mdb) -!? Access Oracle Oracle Migration Workbench - 7
ODBC Migration Workbench Oracle Migration Workbench 10.1.0.2 Intel 80486 Pentium 233Mhz 128MB RAM 256MB 65MB Migration Workbench VGA SVGA Microsoft Windows 98/NT/2000/XP OS Microsoft Windows NT 4.0 Service Pack 6.0a Microsoft Windows 98/2000/XP Workbench 30MB -!? Access Oracle Oracle Migration Workbench - 8
Migration Workbench OTN-J Migration Workbench Migration Workbench zip 1. Windows 2. Migration Workbench ) D: Oracle 3. Omwb.zip Migration Workbench Omwb Migration Workbench Migration Workbench -!? Access Oracle Oracle Migration Workbench - 9
Omwb OMWB_DIR D: Oracle Migration Workbench D: Oracle Omwb OMWB_DIR Access OTN-J Access 1. Migration Workbench 2. MSAccess.jar OMWB_DIR Plugins ) D: Oracle Omwb Plugins Access Plugins -!? Access Oracle Oracle Migration Workbench - 10
Oracle OMWB Microsoft Access Oracle Access Oracle Access Access(2000) " (Northwind.mdb)" Access Microsoft Access 1. Access 2. Access Microsoft Access 3. Oracle Migration Workbench 10.0.2 3-7 Access Access Access 4. Access (Access MDB) Migration Workbench Access MDB Access 5. Access / Access XML Access Access XML Oracle Migration Workbench Exporter for Microsoft Access(Exporter) -!? Access Oracle Oracle Migration Workbench - 11
Access MDE MDB XML 1. Access Exporter Access 2.0, 95, 97 OMB_DIR msaccess_exporter omwb97.mde Access 2000 OMB_DIR msaccess_exporter omwb2000.mde OMWB Exporter 2. Export Export Database Schema... -!? Access Oracle Oracle Migration Workbench - 12
Exporter 3. Access (MDB ) XML Export XML MDB <MDB.xml> Northwind.xml Access 4. OK Exit Exporter 5. Access XML 3. Northwind.xml XML XML notepad Northwind.xml encoding="iso-8859-1" encoding="shift_jis" -!? Access Oracle Oracle Migration Workbench - 13
XML encoding Migration Workbench Oracle Oracle Migration Workbench Oracle Oracle 2 Migration Workbench Migration Workbench -!? Access Oracle Oracle Migration Workbench - 14
OMWB OMWB 1. Migration Workbench OK OMWB_DIR bin omwb.bat ) d: oracle Omwb bin omwb.bat OMWB_DIR bin omwb.bat Migration Workbench 2. Migration Workbench Default Repository (Default Repository Migration Workbench Oracle Lite ) -!? Access Oracle Oracle Migration Workbench - 15
3. Yes Close 4. Microsoft Access 2.0/95/97/2000 Plugin OK -!? Access Oracle Oracle Migration Workbench - 16
5. Capture Wizard ( OMWB ) Capture Wizard Capture Wizard Oracle Capture Wizard ( OMWB Action Capture Source Database ) 1. Capture Wizard Next 2. Select Database to Capture -!? Access Oracle Oracle Migration Workbench - 17
XML XML Add XML File Select XML File XML XML OK ) d: Oracle AccessDB Northwind.xml Microsoft Access XML File XML Next 3. Data Type Mappings Access Oracle Next -!? Access Oracle Oracle Migration Workbench - 18
4. Create Oracle Model Oracle Oracle Model OMWB No Next 5. Finish Capture -!? Access Oracle Oracle Migration Workbench - 19
6. 7. Capture OK -!? Access Oracle Oracle Migration Workbench - 20
OMWB 2 Migration Workbench OMWB OMWB Oracle 1. Tools Options... 2. Options 3. General Data file directory ( ) ) D: oracle oradata orcl OK Capture -!? Access Oracle Oracle Migration Workbench - 21
Tables Northwind Access2000 Northwind.mdb Relations Oracle Oracle -!? Access Oracle Oracle Migration Workbench - 22
Access Capture {5AD529B-BEA...} Oracle SQL ( mdb mdb ) Access XML XML XML 1. XML Northwind.xml notepad 2. OMWB Relations -!? Access Oracle Oracle Migration Workbench - 23
) ) -!? Access Oracle Oracle Migration Workbench - 24
3. XML 4. OMWB Capture Wizard Capture Wizard XML 5. OMWB Oracle Oracle 1. Action Create Oracle Model... 2. Destination Database Oracle Oracle8i/Oracle9i/Oracle10g Oracle9iLite Next -!? Access Oracle Oracle Migration Workbench - 25
3. Oracle 4. OK -!? Access Oracle Oracle Migration Workbench - 26
( Access ) Oracle 3 a) b) c) a) Migration Wizard 1. OMWB Action Migrate to Oracle... Next -!? Access Oracle Oracle Migration Workbench - 27
2. Destination Database Details Oracle. 3. Migrate Tablespace, Users, and User Tables Next -!? Access Oracle Oracle Migration Workbench - 28
4. Migrate Table Data Yes Next 5. Select Schema Objects to migrate Next -!? Access Oracle Oracle Migration Workbench - 29
6. Summary Finish 7. 8. Ignore Error Access2000 Northwind.mdb Northwind -!? Access Oracle Oracle Migration Workbench - 30
Oracle Migration Workbench Microsoft Access 2.0 95 97 2000 9.2 4 9. Access Access 10. OK -!? Access Oracle Oracle Migration Workbench - 31
11. OK Access Oracle Oracle oracle Oracle northwind -!? Access Oracle Oracle Migration Workbench - 32
Access Oracle Access Access Access Access 2 Access Oracle Access Access Oracle ODBC Oracle PC Oracle Oracle Net Oracle ODBC Oracle Oracle Client Oracle Data Access Software ODAC Oracle Client Oracle ODBC Driver Access PC -!? Access Oracle Oracle Migration Workbench - 33
ODAC OTN-J Oracle ODBC Drivers for Oracle 10.1.0.2 ODAC ODBC Oracle Oracle Oracle Net DB Access Northwind.mdb Access Oracle ODBC 1. Access Northwind.mdb 2. 3. (T) ODBC Databases -!? Access Oracle Oracle Migration Workbench - 34
4. 5. Oracle ODBC -!? Access Oracle Oracle Migration Workbench - 35
Oracle ODBC Oracle in < Oracle > ) Oracle in OracleClient10g_home1 6. 7. -!? Access Oracle Oracle Migration Workbench - 36
8. Oracle OK Oracle Model OMWB ( POINT ) ( ) OMWB Oracle Access oracle 9. OK -!? Access Oracle Oracle Migration Workbench - 37
10. 8. Oracle OK 11. Oracle <. > NORTHWIND. 12. NORTHWIND.~ Access OK 9 / / / / / / / / -!? Access Oracle Oracle Migration Workbench - 38
13. Access 14. < >_< > Access Oracle BK_< > NORTHWIND _ 15. BK_< > BK_ 16. NORTHWIND_ -!? Access Oracle Oracle Migration Workbench - 39
17. Access -!? Access Oracle Oracle Migration Workbench - 40
Oracle Net DB Oracle Oracle Net ODBC ODBC Oracle Net PC Oracle Oracle Client Oracle Net 1. Net Configuration Assistant NetCA Oracle Oracle Client ORACLE_HOME ORACLE_HOME bin netca.bat 2. Oracle Net Configuration Assistant 3. -!? Access Oracle Oracle Migration Workbench - 41
4. Oracle 5. TCP -!? Access Oracle Oracle Migration Workbench - 42
6. TCP/IP 7. 8. Oracle ODBC Oracle -!? Access Oracle Oracle Migration Workbench - 43
9. NetCA 8. PC Oracle Oracle 1. 2. prompt> lsnrctl status -!? Access Oracle Oracle Migration Workbench - 44
3. Presentation HTTP/FTP Oracle 1521 4. Oracle XDB XML DB SID -!? Access Oracle Oracle Migration Workbench - 45
SID ODBC 1. Oracle ODBC Oracle Universal Installer ODBC Oracle Client Oracle Database Server/Client Oracle Data Access Software for Windows (OTN-J ) Oracle ODBC Driver Universal Installer ODBC -!? Access Oracle Oracle Migration Workbench - 46
2. Oracle ODBC Windows [ ] [ ] [ ] [ ] ODBC ODBC User DSN Oracle in <Oracle_HOME > Oracle ODBC OK TNS Oracle Net -!? Access Oracle Oracle Migration Workbench - 47
-!? Access Oracle Oracle Migration Workbench - 48
Copyright 0000 Oracle Corporation Japan. All Rights Reserved. Oracle Oracle Corporation Oracle Corporation -!? Access Oracle Oracle Migration Workbench - 49