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.

Recommended Answers

All 9 Replies

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.

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

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.

You want to insert into sql server or oracle ?

I want to insert into oracle from sql server

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 ?

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

From where you generate the .csv ?

Why not directly upload the csv into Oracle ?

I got the solution
INSERT INTO [ABC]..[ABC].[CUSTOMER] SELECT * FROM xyz.DBO.Customer

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.