[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1361
  • Last Modified:

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?



0
frankEQS
Asked:
frankEQS
  • 8
  • 5
2 Solutions
 
mozculluCommented:
SQL Server Migration Assistant will do this:

http://www.microsoft.com/sqlserver/en/us/product-info/migration.aspx
0
 
frankEQSAuthor Commented:
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.

1
 
frankEQSAuthor Commented:
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.
1
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
JacobfwCommented:
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
0
 
frankEQSAuthor Commented:
I have a Oracle DB, not MySQL.

Unsure what a solution for Oracle is.
0
 
JacobfwCommented:
Can you provide all version numbers?
SSMA
Oracle
SQLServer
Oracle Client
0
 
frankEQSAuthor Commented:
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??)

0
 
JacobfwCommented:
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?
0
 
frankEQSAuthor Commented:
Well i could try.

as i said, im have never used Oracle, so this is all new to me.
0
 
JacobfwCommented:
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)
0
 
JacobfwCommented:
Installation requirements for SSMA for Oracle

Supported Operating Systems: Windows 7

Requirements for the SSMA for Oracle client:


•Microsoft Windows Installer 3.1 or a later version.
•The Microsoft .NET Framework version 2.0 or a later version. You can obtain it from the .NET Framework Developer Center.
•Oracle Client 8.1.7 or a later version, and connectivity to the Oracle databases that you want to migrate. The Oracle client version must be the same version as, or a later version than, the Oracle database version.
•Access to and sufficient permissions on the computer that hosts the target instance of SQL Server.
•1 GB RAM.

Requirements for the SSMA for Oracle Extension Pack:
•SQL Server 2005 or higher.
•Microsoft Windows Installer 3.1 or a later version.
•Oracle Client 8.1.7 or a later version, and connectivity to the Oracle databases that you want to migrate. The Oracle client version must be the same version as, or a later version than, the Oracle database version.
0
 
frankEQSAuthor Commented:
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
0
 
frankEQSAuthor Commented:
This task was aborted.

Im dividing the points.
0
 
frankEQSAuthor Commented:
I did not continue to investigate this error, but the recommended software seemed to do the job.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 8
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now