Solved

Mysql to Oracle Migration

Posted on 2014-01-07
3
421 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

785 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