Solved

how to insert data from sql server 2000 to a table that is located on oracle 10g?

Posted on 2008-10-14
3
338 Views
Last Modified: 2013-12-18
hi all,
i have to retrieve data from sql server 2000 and put them into a table which is located on oracle 10g.
i dont know how to achieve that. do you have any idea? using c# application?

thanks
viola
0
Comment
Question by:viola123
3 Comments
 
LVL 60

Assisted Solution

by:chapmandew
chapmandew earned 200 total points
ID: 22710466
You should be able to do this using DTS.  Right click the SQL Server db , select tasks, then import data.  From there you can select the Oracle server as your source...a wizard should guide you through the rest.
0
 
LVL 20

Accepted Solution

by:
Sirees earned 300 total points
ID: 22710484
0
 
LVL 6

Author Comment

by:viola123
ID: 22726438
hi all,
thanks a lot. i am currently using c# application to do that cos i have to make sure every record is exported correctly and log the failed ones. but DTS can do that as well.

thanks
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Replace &lt; with < 14 57
My Query is not giving correct result. Please help 5 32
How to free up undo space? 3 31
Need a starter for ETL protocol? 4 45
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
Via a live example, show how to take different types of Oracle backups using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now