• Status: Solved
  • Priority: High
  • Security: Public
  • Views: 273
  • Last Modified:

Best Oracle Client (free) similar to SSMS

I was using SSMS till now as I had to connect to only SQL Server DB. I now need to access Oracle DB remotely. Many websites mention it is possible to access Oracle DB via SSMS through a linked server. Assuming the linked server needs to be setup on the Oracle server machine and not on my machine (correct me if wrong), I do not see this as a possibility because of certain limitations. Are there any other free tools close to SSMS users here have experienced? Please share.
0
sukhoi35
Asked:
sukhoi35
2 Solutions
 
PortletPaulfreelancerCommented:
You may want to read about setting-up a linked server. You will need Oracle client software installed where SSMS is running.
e.g.
Oracle 11g to SQL 2008
http://www.itprotoday.com/microsoft-sql-server/connecting-sql-server-and-oracle-using-linked-servers

Oracle 11g to SQL 2014
https://www.mssqltips.com/sqlservertip/4396/creating-a-sql-server-2014-linked-server-for-an-oracle-11g-database/
0
 
Pawan KumarDatabase ExpertCommented:
>>I now need to access Oracle DB remotely. Many websites mention it is possible to access Oracle DB via SSMS through a linked server.
Yes it is possible to access the oracle DB from SQL Server. ( SSMS ) through a linked server.

Sample calling of SP from SSMS(SQL code)
DECLARE @Inout INT
SET @Inout = 10
EXEC ('BEGIN Sp_Name (?); END;', @Inout OUTPUT) AT [YourlinkedServeName]  
SELECT @Inout

Open in new window


Also note that you need to install proper drivers to make this working. Please prefer Oracle 12 client.

>>Assuming the linked server needs to be setup on the Oracle server machine and not on my machine (correct me if wrong),
No you have to set up the linked server on your MS SQL Server DB and with proper access. Once all is set we can use 4 part name to access the things
ServerName.TablName.schema.TableName

>>Are there any other free tools close to SSMS users here have experienced?
There are many tools. https://alternativeto.net/software/oracle-sql-developer/
DBeaver is free that you can try. There are others also which i have not explored.

>> My fav tools are dbForge Studio AND Toad for Oracle <<  This is an industry-standard tool for application development. >>
0
 
Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
While I don't work on Oracle, I hear from my friends and colleagues that Toad for Oracle is a good one and provides a reasonable degree of comfort.
0
 
sukhoi35Author Commented:
Thanks for your responses!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now