Objectives:

Prerequisites:

• Linux OS
• mysqlclient (mysql-devel needed)
• sqlplus
• sqlloader
• OCI (oracle instant client devel version, basic not enough)
• the sql script which creates and drops the Oracle schema (should match the MySQL schema)
• The LFC service should be stopped

Installation

• create a new directory
• download the tar file (available at the bottom of the page)
• unzip the tar (tar xzvf).Omit the complaints. It is composed of :
  • src directory with all the sources
  • incl directory with the header
  • readme file (similar to the wiki page)
  • output directory (config_file.data to be filled in and the application MigrateLFC will be here)
  • Makefile (must be edited to put the correct location of the oracle and mysql lib)
• fill in the config_file with the proper information. Each entry must be terminated by ; (a semi column)
• Add to the LD_LIBRARY_PATH, the path to liboci.so and to libmyslqclient.so
• chmod +x MigrateLFC
• launch the application ./MigrateLFC

if one error occurs, the policy is to drop the Oracle schema and DB and goes to the initial state.

Files

The application generates log files which give information about loading data. There is also a log file for the application (MigrateLFC_logfile.log). If the migration has been successful, all the log files can be deleted. This operation has to be done manually.

Remark

The application does not drop the MySQL DB even if the application is successful. The pwd of DBs are removed from the config_file.data

FAQ