asked on

Importing/Migrating from Oracle to MSSQL

Just to be clear - im a beginner at Oracle.

I need to convert a in use important database from Oracle to MSSQL. What is the best way of doing this?

ASKER CERTIFIED SOLUTION

Metehan Ozcullu

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

frankEQS

ASKER

Using SSMA to connect to my SQL server works fine.

But when i try to connect to my Oracle DB i get error:

Connection to Oracle established successfully.
Connection string: Provider="OraOLEDB.Oracle.1";Data Source="EQS";ChunkSize=65535;User ID="eqsdba";
Error occurred while collecting data.

Ive tried connecting with Oracle Client too.

This is all the error information i get. i dont understand why. I have a Oracle 9i.

frankEQS

ASKER

this is error i get when using "Oracle client" to connect:

Connection to Oracle established successfully.
Connection string: Data Source="EQS";Unicode="True";User ID="eqsdba";
Error occurred while collecting data.

Jacobfw

See several instances where this error is reported becuase the MySQL version is not a base version.

Ver 5.05.1a

but works fine for

Ver 5.1

frankEQS

ASKER

I have a Oracle DB, not MySQL.

Unsure what a solution for Oracle is.

Jacobfw

Can you provide all version numbers?
SSMA
Oracle
SQLServer
Oracle Client

frankEQS

ASKER

SSMA - 5.1.1106
Oracle enterprice manager - 9.2.0.1.0 (unsure what version number you need here)
SQL server - 2005 and 2008 R2 (i have more test)
Oracle client - SQL plus? (or??)

Jacobfw

Can you confirm the ORACLE_HOME variable is set and configured for the Oracle Client on the machine you are running SSMA?

Can you confirm that you have installed the SSMA for Oracle Extension Pack?

frankEQS

ASKER

Well i could try.

as i said, im have never used Oracle, so this is all new to me.

Jacobfw

To Check for Oracle_Home:
http://www.orafaq.com/wiki/ORACLE_HOME

Did you install Oracle Client on this machine? (Oracle Net and SQL Plus for instance)

SOLUTION

Jacobfw

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

frankEQS

ASKER

I did not install Oracle. Im trying to migrate away from Oracle becouse we have no experience with this.

It seems like in regedit oracle home is: c:\oracle\ora92

frankEQS

ASKER

This task was aborted.

Im dividing the points.

frankEQS

ASKER

I did not continue to investigate this error, but the recommended software seemed to do the job.