I've started using ADODB to code some of my stuff so that in the future I can use Oracle instead of MySQL.
I wanted to test this and make sure it works by using my current code with Oracle. My problem is that I need to copy my mysql database to Oracle. I did some searching and found that Oracle makes a Migration Workshop utility that will do this. However, right now I am running Oracle Personal Edition 8.1.6 and when I try to install the Migration Workshop says I need 8.1.7. Oracle does not have an 8.1.7 version that works on windows98.
I did a mysqldump using phpMyAdmin w/ complete inserts and tried running that .sql in SQL*Plus, but it just returned thousands of errors.
Anyone have the solution?
- Doug
I wanted to test this and make sure it works by using my current code with Oracle. My problem is that I need to copy my mysql database to Oracle. I did some searching and found that Oracle makes a Migration Workshop utility that will do this. However, right now I am running Oracle Personal Edition 8.1.6 and when I try to install the Migration Workshop says I need 8.1.7. Oracle does not have an 8.1.7 version that works on windows98.
I did a mysqldump using phpMyAdmin w/ complete inserts and tried running that .sql in SQL*Plus, but it just returned thousands of errors.
Anyone have the solution?
- Doug