Solved

Tying Oracle 11g into SMSS 2012

Posted on 2013-12-30
2
238 Views
Last Modified: 2014-01-16
Is there a means to query a Oracle 11 database from SMSS 2012?

Thanks
0
Comment
Question by:fmi_techsupport
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 70

Accepted Solution

by:
Qlemo earned 250 total points
ID: 39746454
You mean SSMS? Yes, but only server-based, that is the SQL Server performs the query, and needs to be able to use the Oracle OLEDB driver (or ODBC) - via something called "Linked Server", the same feature used to query other SQL Server instances. The client is not involved in the connection.
0
 
LVL 15

Expert Comment

by:Aaron Shilo
ID: 39746823
hi

take a look at this guide from Sql Server mag on connecting to Oracle
using linked server

Connecting SQL Server and Oracle Using Linked Servers
0

Featured Post

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you considered what group policies are backwards and forwards compatible? Windows Active Directory servers and clients use group policy templates to deploy sets of policies within your domain. But, there is a catch to deploying policies. The…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

687 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question