Oracle Database - How to export oracle database (or tables ) from oracle to sql server

Hi,

An oracle database is exported to Oracle 10g server machine from remote pc. Now, i have to export the tables from the oracle database to Sql server .

Please guide me the better ways of doing it.

thank you,

Ramm

Hi,
You can try this free tool SwisSQL Oracle to SQL Server Free Online Migration ( Conversion )
Check out the URL:
www.swissql.com/products/oracle-to-sqlserver/oracle-to-sql-server.html

Use SQL Server Integration Services -
http://www.codeproject.com/KB/books/SQL_Server_Integration.aspx

Hi,
This are 2 options:-
(1) Visit following website
http://www.microsoft.com/sql/solutions/migration/oracle/default.mspx
Microsoft SQL Server Migration Assistant (SSMA) for Oracle is a free tool for migrating Oracle databases to Microsoft SQL Server 2005. SSMA for Oracle converts Oracle database objects (including stored procedures) to SQL Server database objects, loads those objects into SQL Server, migrates data from Oracle to SQL Server, and then validates the migration of code and data.


(2)
I will recommend to install ORA drivers on SQL Server 2005 or you can use OLE DB for Oracle in SSIS Data Connection. OLE DB Drivers for SQL Servers are available on Oracle website.
Use SQL Server 2005 SSIS to open Data connection for Orcale & Import to Staging Database which will hold all your tables. finally do some massaging on those tables before they can be exported to TEST Database where you can do some testing looking forward to Production Server.
What i mentioned is not that easy but will give you some basic idea. Also make sure that your SQL Server 2005 is atleast on Service Packs 2.

Hi,
Also check this article for Step-By-Step Guide to Importing Data from Oracle XE to SQL 2005 :
http://www.devshed.com/c/a/Oracle/StepByStep-Guide-to-Importing-Data-from-Oracle-XE-to-SQL-2005/

Hi,

I am using the following procedure to export tables from oracle databse to sql tables http://www.codeproject.com/KB/books/SQL_Server_Integration.aspx

But when I test the connection from the oracle datbase, after entering username and password ( screenshot in page12 of above file),

TEST CONNECTION FAILED BECAUSE OF an error in initializing provider. ORA-12154 : TNS COULD not resolve the connect identifier specified

please help me in resolving this.

thank you,

ramm

http://www.scribd.com/doc/14717775/SQL-Server-Integration-Services-with-Oracle-Database-10g

its in PAGE 15...

actually I am facing trouble to access the database. when I click Test Connection the error msg mentioned above is seen..

please help me

thanks

Ramm