OMWB will proceed to create a number of tables to hold meta-data. Run the Oracle Migration Workbench and connect as the Repository User. Step 4 – Run the Oracle Migration Workbench Ensure that the MySQL (source) database is available as well as the Oracle target database.
Note that when migration is complete this schema can be removed again. Following instructions in the doc and connected as SYSDBA in SQL*Plus, I created a database user.
#Oracle database workbench install#
Install MySQL plugin – copy MySQL4.jar to plugins folder.Install Oracle Migration Workbench by extracting the zip-file.I had to download the MySQL Connector/J 3.0.x driver as well (from MySQL’s Site).
The Reference Guide on Windows is here as well as the Release Notes. I started out by downloading the Oracle Migration Workbench from OTN as well as the MySQL 4.0 plugin.
Step 1: Download all required software and documentation In this post, I will roughly describe how such a migration can be done quite easily using the Oracle Migration Workbench (OMWB). That means we have to migrate the data from MySQL to Oracle. This analysis for obvious reasons is to take place from within an Oracle database. We would like to do some analysis on these statistics, for several reasons: to try out the Oracle Warehouse Builder 10gR2 Beta Paris Release we have currently available, to develop a number of articles and demos around Oracle BI technology in general and of course to learn more about the visitors to our weblog: where do they come from, what days of the week do they visit, which times of the day (when is the best time for us to do maintenance, like an upgrade of WordPress to release 1.5), what topics are they primarily interested in, which browsers do they use etc. All statistics on the visits to the posts in the AMIS Technology Weblog are gathered in a MySQL database that sist underneath WordPress.
0 kommentar(er)
