?
Solved

Mysql to Oracle Migration

Posted on 2014-01-07
3
Medium Priority
?
462 Views
Last Modified: 2014-06-10
Hi ,

 I had migrated 2 Databases say Test1 & test2 from Mysql to Oracle using the Standard Mysql Migration using Oracle developer tool, it showed success.

What I would like to know the DB name of these test1 & test2 in Oracle.
What would be the username & passwords to access these databases.
0
Comment
Question by:asivaprasad
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 12

Accepted Solution

by:
Praveen Kumar Chandrashekatr earned 2000 total points
ID: 39761850
>>What I would like to know the DB name of these test1 & test2 in Oracle.<<

for migrating the data from MYSQL to ORACLE you need to first create the database in oracle and should make use of it for migration. so the DB name will be the same to which you migrated the data. If you have not created the oracle instance before migration then what was the connection string you gave while migration also let us know what is teh tool you used for migration.

Here are few doc which take you through the migration steps using oracle SQL developer tool.

http://www.oracle.com/technetwork/issue-archive/2007/07-sep/o57sql-100253.html

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

Expert Comment

by:Steve Wales
ID: 40123995
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question