Migrate Access 2000 database to Oracle 9i

Oracle 9i provides powerful migration functions to migrate data from multiple databases to Oracle. The new Oracle migration tool provides a simple solution for migrating data from Access 2000 to Oracle 92010. This solution overcomes Chinese garbled characters and string truncation issues, the entire migration process from Access 2000 to Oracle 92010 is as follows.

1. download the latest version of OMWB (Oracle Migration Workbench)

Install and download the Oracle Migration Workbench Release 9.2.0.1.2 for MicrosoftWindows98/NT/2000/XP and plug-ins for Migration from Access 2.0, 95, 97 or 2000 to the Oracle platform, the latest versions of both are 92012. First install OMWB in a different home directory from Oracle, and then install the Access Plug-in to the same directory.

2. Prepare data sources for Migration

Go to the \ OMWB \ msaccess_exporter directory in the Omwb main directory, open the omwb2000.mde file, and enter the Access database file to be migrated and the XML description file to be generated for the database, at this time, you will find that an XML file with the same name is generated in the same path as Access. Open this file, which records the columns, relations, and view definitions of Access database tables. OMWB supports Access to Chinese table names and column names. However, before generating an XML file, you must modify \ Omwb \ msAccess_exporter \ schema. dtd file, Change encoding = "ISO-8859-1" in the first line to encoding = "GBK", and then generate an XML file for the database by opening the omwb2000.mde file, at this time, the table name and column name are successfully displayed in Chinese. Before migrating to Oracle, you must use the same method to modify the generated XML file encoding to encoding = "GBK ".

1 2 Next Page

[Content navigation]
Page 1st: migrate Access 2000 database to Oracle 9i	Page 2nd: migrate Access 2000 database to Oracle 9i