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?

[Webinar] Streamline your web hosting managementRegister Today

x
 
mohammadzahidConnect With a Mentor Commented:
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
 
JHallidayConnect With a Mentor Chief 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_ZConnect With a Mentor Commented:
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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
slightwv (䄆 Netminder)Connect With a Mentor 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 PatelConnect With a Mentor Assistant 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
All Courses

From novice to tech pro — start learning today.