Solved

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

Posted on 2008-10-14
3
342 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

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

821 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