how to export sql table to oracle

How to export sql table to to oracle table fastest way using asp.net (c#, sql SSIS, or oracle)
Bharat GuruAsked:
Who is Participating?
 
mohammadzahidCommented:
It depends, if it is a one time thing, then simply export data to a csv file and load using Oracle SQL Loader. SSIS package is a development and there learning curve involved.
If it is on going task then I would create a SSIS package and schedule task to run at a certain time.
0
 
JHallidayChief Technical OfficerCommented:
You can use the SQL Server Management administrative application to connect directly to the Oracle database using ODBC and export the data that way.  Alternatively export the data to a CSV file and re-import it into Oracle.
0
 
Docteur_ZCommented:
I'd make an SSIS package for Extract from MSSQL, transfer to Oracle and Load into Oracle.
And use a code like this (down to divya comment), but I've no way of testing it.
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
slightwv (䄆 Netminder) Commented:
Strictly from a .Net solution (and assuming you take my suggestion from your other question and move to ODP.Net),  Check out array binding:

http://www.oracle.com/technetwork/issue-archive/2009/09-sep/o59odpnet-085168.html

Connect to SQL Server, load the data into a dataset/datatable/???  then connect to the Oracle database and load it.
0
 
Alpesh PatelAssistant ConsultantCommented:
if single table then export data from SQL server and use SQL developer to migrate to ORacle and load.
0
 
Bharat GuruAuthor Commented:
Thnaks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.