Member Avatar for Arjun_Sarankulu

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
  • 381 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by Arjun_Sarankulu

Recommended Answers

All 9 Replies

Member Avatar for debasisdas

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 because: n/a
Member Avatar for urtrivedi

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

Member Avatar for Arjun_Sarankulu

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.

Member Avatar for debasisdas

You want to insert into sql server or oracle ?

Member Avatar for Arjun_Sarankulu

I want to insert into oracle from sql server

Member Avatar for debasisdas

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 ?

Member Avatar for Arjun_Sarankulu

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

Member Avatar for debasisdas

From where you generate the .csv ?

Why not directly upload the csv into Oracle ?

Member Avatar for Arjun_Sarankulu

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.