SQL Developer Migration wizard
From: Lynne Flatley <lflatley_at_gmail.com>
Date: Wed, 14 Oct 2020 12:21:27 -0400
Message-ID: <CAH+eeUnFv=OWx0DUy0CcGCqAkjHB5Wd1rZ633g2ZVUwZaNj5sw_at_mail.gmail.com>
We have a MySQL database that we would like to convert to Oracle. I set up SQL Developer (19.4) to use the MySQL jar file (5.1.29) so I am able to view the MySQL schema and I can migrate tables by right-clicking on a table or a set of tables and selecting Oracle copy but I would really like to set a script that will migrate all of them via the script, i.e. not having to manually right-click to initiate each table's conversion.
Date: Wed, 14 Oct 2020 12:21:27 -0400
Message-ID: <CAH+eeUnFv=OWx0DUy0CcGCqAkjHB5Wd1rZ633g2ZVUwZaNj5sw_at_mail.gmail.com>
We have a MySQL database that we would like to convert to Oracle. I set up SQL Developer (19.4) to use the MySQL jar file (5.1.29) so I am able to view the MySQL schema and I can migrate tables by right-clicking on a table or a set of tables and selecting Oracle copy but I would really like to set a script that will migrate all of them via the script, i.e. not having to manually right-click to initiate each table's conversion.
Using the migration project wizard, SQL Developer creates the migration repository but when I try to run it, I get a constraint issue (null not allowed)
[image: image.png]
ORA-01400 cannot insert NULL into MIGRATION_REPO.MD_PROJECTS.ID
<http://migration_repo.md_projects.id/>
I was thinking of removing the column constraint of not allowing NULL for all tables in the Migration repository?
Thanks in advance for any ideas that you have.
Lynne Flatley
+JMJ+
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 14 2020 - 18:21:27 CEST
- image/png attachment: image.png
