CODEWITHSUNDEEP
sql-server-2005oracle-database
kacalapy
kacalapy

Reputation: 10164

Query Oracle DB from SQL 2005?

I have some ODBC connection information for an Oracle database, and I wanted to know if it is possible to query this database from SQL Server 2005?

Also, can I have a SQL job to extract data into my SQL DB?

Upvotes: 1

Views: 72

Answers (2)

bernd_k
bernd_k

Reputation: 11966

I think you have enough information to set up a linked server. My practical experience showed some limitations, when it came to querying CLOB columns, but that seems to be a basic limitation of other tools based on OLEDB too. For special cases I use PowerShell scripts to extract data, which I do not get with the usual tools.

Upvotes: 0

Conrad Frix
Conrad Frix

Reputation: 52675

Linked Servers will let you do this.

SSIS can also be used to extract the data

Upvotes: 1

Related Questions