0

I have a table customer in ms sql and i have same table in Oracle.
I want to insert data from ms sql to Oracle.
I am not getting the solution.

3
Contributors
9
Replies
10
Views
6 Years
Discussion Span
Last Post by Arjun_Sarankulu
0

From MsSQL export data into a .csv file and use SQL Loader to load the same into Oracle. source and destination table fields should be compatible.

Edited by debasisdas: n/a

0

if its one time you can export it to excel or csv then import it in oracle

or you can develop some front end in vb.net or php and connect to both database and transer data from one to another database

0

Thanks Debasis i know the above part
And i developed the front end from where i wiil take csv which will insert the data to sql server
and i have to write 1 stored procedure through which i have to insert data from ms sql server to oracle.

0

And i developed the front end from where i wiil take csv which will insert the data to sql server

then what does this mean ?

0

From csv file i will dump the data to sql server database (in Customer table)
And through stor procedure i will insert it into Oracle table customer

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.