Forum Stats

  • 3,733,357 Users
  • 2,246,747 Discussions
  • 7,856,667 Comments

Discussions

MySQL to Oracle Migration

Raghav_DBA
Raghav_DBA Member Posts: 95
edited March 2019 in MySQL Community Space

For learning I am migrating  one MYSQL database to ORACLE using SQL Developer.

pastedImage_0.png

As per screenshot My TEST database has only one table

pastedImage_1.png

But migration is failing for some other object which even not existing in MYSQL test database.

Answers

  • Gaz in Oz
    Gaz in Oz Member Posts: 3,776 Bronze Crown
    edited March 2019

    Screenshots relay zero actionable information.

    "TEST" is definitely different to test in the mysql database.

    What mysql database actually contains an object "TEST"."MD_PROJECTS"?

    What database do you think you are connecting to?

    What are the connection details? - show them.

    ...and the obvious question, did you check the logs and what did they have to say about your situation?

  • Dave Stokes-MySQL Community Team-Oracle
    Dave Stokes-MySQL Community Team-Oracle MySQL Community Manager TexasMember Posts: 350 Employee
    edited March 2019

    This is a MySQL forum so a question about migrating away from MySQL this forum is not going to gather a lot of answers.  You would probably do better asking a Goldengate or Oracle DBA forum.

  • Raghav_DBA
    Raghav_DBA Member Posts: 95
    edited March 2019

    Hi Gaz,

    I first screenshot you can see test database in MYSQL has only one object(detail table).

Sign In or Register to comment.