...
- Basic experience with Dbvisit Replicate, familiar with running the setup wizard. If not, please follow the step by step guide in Oracle to MySQL using Swingbench example.
- Knowledge of Oracle and MySQL, able to connect to the database and know how to execute scripts, know the login credentials.
- Some knowledge of Unix OS, i.e. is able to run commands and navigate on the filesystem, view/edit files.
...
2. Exclude the unsupported columns, if any. The process described in detail in Oracle to MySQL using Swingbench guide.
3. Run the <REPLICATION_NAME>-all.sh or <REPLICATION_NAME>-all.bat script depending on your OS. Check the output and remember or write down the SCN from the prepare section. Lines of interest will look the following way:
...
In this section the csv_exp tool will be used to export data from Oracle to CSV files, which is available hereon Github.
Please note that csv_exp is provided AS-IS, without any warranty and/or support (see LICENSE for more details).
...