Forum Stats

  • 3,769,395 Users
  • 2,252,961 Discussions
  • 7,875,018 Comments

Discussions

Mysql to Oracle migration using other user

Voudas75
Voudas75 Member Posts: 7 Blue Ribbon
edited May 4, 2014 8:48PM in SQL Developer

Hello ,

Is it possible to modify the schema name of the the migrated schema on Oracle side during migration from Mysql ?

Default behavior is to create a new user with the same name as the mysql schema which is migrated .

Tagged:

Answers

  • Is it possible to modify the schema name of the the migrated schema on Oracle side during migration from Mysql ?
    Default behavior is to create a new user with the same name as the mysql schema which is migrated .
    

    Your question isn't clear.

    Are you using the Migration Wizard? If so you can specify the 'target database connection' as discussed in the Sql Dev user guide

    http://docs.oracle.com/cd/E25259_01/appdev.31/e24285/migration.htm

    Target Database
    
    The Target Database page of the wizard specifies the Oracle database to which the third-party database or databases will be migrated.
    Mode: Online causes the migration to be performed by SQL Developer when you have completed the necessary information in the wizard; Offline causes SQL Developer to generate scripts after you have completed the necessary information in the wizard, and you must later run those scripts to perform the migration.
    Connection: The database connection to the Oracle Database user into whose schema the third-party database or databases are to be migrated. To add a connection to the list, click the Add  icon; to edit the selected connection, click the Edit (pencil) icon.
    
This discussion has been closed.