Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
 Posted - 2010-09-23 : 12:30:40
|
| We are trying to replicate from Oracle 11G to SQL Server 2008R2. OS: windows server 2008R2 64bit. SQL server version: SQL 2008 R2 - 64bit.I installed the oracle 11G 64bit client. Then restarted the SQL Server services. I still can't see the oracle provider under LinkedServer---->Providers within Sql server management studio. So now I am thinking of uninstalling the oracle 64bit client and instead install oracle 32bit client. Before doing that I want to check with you all. Any ideas will be greatly appreciated. Thanks. |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2010-09-23 : 19:16:59
|
| From experience with pulling data from Oracle, I would suggest that you create an SSIS package to pull data from Oracle to SQL, rather then querying from Linked Server.-Igor |
 |
|
|
|
|
|
Replication from Oracle to SQL Server