SQL Server - Need Help Linked server and Oracle publication
Asked By prathap chowdary on 09-May-12 03:30 AM
Hi,
This is Prathap......
I need information for Linked server and Oracle publication. actually i know how to create linked servers for sql servers.
But i want to know how to extract data from oracle database through linked server ?
and i need to know through replication......one option is available....oracle publication........
Please any one help me.......it is urgent requirement.......
Regards,
Prathap.
3407.
[)ia6l0 iii replied to prathap chowdary on 09-May-12 09:45 AM
Do you want to query a remote oracle database from SQL Server?
prathap chowdary replied to [)ia6l0 iii on 12-Jun-12 04:02 AM
Hi,
Thanks for your reply......
Now i have created Linked server for ORacle server.
like this way...........
EXEC sp_addlinkedserver @server = 'TestOraLink', @srvproduct = 'Oracle', @provider = 'OraOLEDB.Oracle', @datasrc = 'TESTDB'
EXEC sp_addlinkedsrvlogin 'TestOraLink', false, 'CMS', 'CMS', 'CMS'
or else GUI its very easy.......
Regards,
Prathap.
3407.
Replication from Access to SQL Server SQL Server
Is it possible to replicate data from Access (2000 or 2003) to SQL Server (2000 or 2005)? SQL Server Replication Discussions SQL Server (1) Microsoft Access (1) Oracle (1) SQL Server 2000 can function
Combining Data from Oracle & SQL Server SQL Server
Combining Data from Oracle & SQL Server SQL Server I have Title IDs in a SQL Server table and the Title ID Details in Oracle tables. Right now I am managing this though a linked server. Is there a way
explain the differences between oracle and sql server SQL Server is MicroSoft Product Oracle is Multinational Company am not asking about the companies
Get current date In sql server , oracle and MYSQL SQL Server
Get current date In sql server , oracle and MYSQL Get current date In sql server , oracle and MYSQL In sql server Select
Security at Row Level Within SQL Server SQL Server
Oracle has a feature called "Virtual Private Databases" (VPD), that enables you to configure permissions at row level. Is there an equivalent feature in SQL Server?" SQL Server Security Discussions SQL Server (1) Oracle (1) Databases (1) Russel (1) Wang (1) Publicsector
SQL Server vs PostGress , DB2 and Oracle SQL Server
We are looking @ changing our Oracle DB with either SQL Server 2008 R2, PostGress or DB2. Does SQL SErver 2008 R2 support Pl / SQL? SQL Server
replication sql 2000 - -> sql 2005 SQL Server
replication sql 2000 - -> sql 2005 SQL Server , sql, 2005" / > Is it possible to replicate a db from sql server 2000 to sql server 2005? When I set the publications, I look this "select all of the types
what is the difference between sql server and oracle? Get the ppt of difference between sql and oracle http: / / nocoug.org / download / 2004-05
Is there sth like Direct-Path-Loads in SQL-Server SQL Server
I am familiar with direct-path-loads and SQL*Loader on Oracle. Does anyone know if sth like this is available on SQL-Server? SQL Server Discussions SQL Server (1) Oracle (1) Hi Franz Tibor replied to this in
data-transformation : Oracle to SQL Server SQL Server
I need to transfer data from an Oracle db to SQL Server db This is no the entire database , nor a subset of tables , but rather specific