| Connecting SQL server 7 database thru Oracle [message #51988] |
Mon, 24 June 2002 22:40  |
priya
Messages: 108
Registered: February 2000
|
Senior Member |
|
|
Hi all
we are currently working on a project which requires us to fetch data from SQL Server 7 into oracle tables after validating/referncing or crosschecking certain values from the Oracle table
Please help
|
|
|
|
|
|
|
|
| Re: Connecting SQL server 7 database thru Oracle [message #52104 is a reply to message #51988] |
Tue, 02 July 2002 07:31  |
Craig
Messages: 28
Registered: October 2001
|
Junior Member |
|
|
Sai is right.
In SQL Server 7 there is a DTS utility which will re-direct to Oracle. It is very straight forward. Do all your checking from the Oracle side. Oracle is listed in the drop down box to transfer by SQL Server7, I have done this loads of times
Use Ole db to transfer.
HTH
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
