Improve company productivity with a Business Account.Sign Up

x
?
Solved

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

Posted on 2008-10-14
3
Medium Priority
?
355 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 600 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 900 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
Simulator games are perfect for generating sample realistic data streams, especially for learning data analysis. It is even useful for demoing offerings such as Azure stream analytics, PowerBI etc.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…

601 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