SQL Server Link to Oracle

[net123]

Hello - I would like to know if any of you have ever imported data from an Oracle database to a SQL Server 2000 database.

Also, what books do you recommend on this subject (are there any books describing this)? Any links available would also be of extreme helpfulness.

Thank you in advance.

 

[ClaireHCM]

(1)First install Oracle client on your sql server box.
(2)Create system dsn (for heterogeneous system like oracle,db2,sybase)to indicate sql server where should communicate
(3)Add linked server in enterprise manager
These are the basic 3 steps that to make sql server communicate with oracle server.

There are some good website:
databasejournal.com
sqlmag.com
You can get some replated info. from these webstie

 

[rostler]

Hi,

I have successfully imported several million records from Oracle using the DTS. The DTS import wizard is pretty good for getting started and gives you a lot of flexibility if you need to do any transformations on your data as you migrate it.

Richard