Solved

Mysql to Oracle Migration

Posted on 2014-01-07
3
411 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
3 Comments
 
LVL 12

Accepted Solution

by:
praveencpk earned 500 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

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Via a live example, show how to take different types of Oracle backups using RMAN.

920 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now