This content has been marked as final. Show 4 replies
SQL*Developer is intended for one-off migrations and there is nothing in the migration tools to only pick up rows that have been inserted into the non-Oracle database since the migration.
If you need to do this regularly there are several possible options -
- investigate using materialized views between Oracle and MySQL
- write MySQL changes into a MySQL table then copy that table to Oracle using Dg4ODBC
- if it is possible connect from MySQL to Oracle and write changes directly.
The following note in My Oracle Support discusses further -
How to replicate Data between Oracle and a Foreign Datasource (Doc ID 283700.1)
Many Thanks for the reply with the available options. Just what I needed.
After multiple errors like 'failed to create rollback segment' due to huge tables and new rows (and columns!) in the mysql database I tried a python script to move the problem tables (the big ones).
That took less than a day for what took at least a week earlier and gave me a lot more control over what got moved. This became possible also because new rows could be clearly identified with a date column in them.