Home » SQL & PL/SQL » Client Tools » TOAD with Oracle and MS SQL Server
TOAD with Oracle and MS SQL Server [message #606250] Tue, 21 January 2014 12:34 Go to next message
bws93222
Messages: 27
Registered: April 2009
Junior Member
We use TOAD and Oracle but we also have a MS SQL Server database
that I would like to get access to.

I know TOAD can be used with MS SQL. Would it be complicated
to set up our existing TOAD to also acess MS SQL?--if so
what's the easiest way to do it? It can be read-only.

Thx.
Re: TOAD with Oracle and MS SQL Server [message #606251 is a reply to message #606250] Tue, 21 January 2014 12:40 Go to previous messageGo to next message
Michel Cadot
Messages: 59414
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Why do you post this in an Oracle forum and not in a TOAD/Quest or MS SQL Server one?
This has indeed nothing to do with Oracle.

[Updated on: Tue, 21 January 2014 12:41]

Report message to a moderator

Re: TOAD with Oracle and MS SQL Server [message #606252 is a reply to message #606250] Tue, 21 January 2014 12:47 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2444
Registered: May 2013
Location: World Wide on the Web
Senior Member
Since the Client Tools forum has description as : Tools for executing SQL and PL/SQL commands: SQL*Plus, iSQL*Plus, SQL Developer and SQL Worksheet. Including 3rd party tools like TOAD, DB Artisan, SQL Navigator, PL/SQL Developer, etc., so, here is a link from TOAD world regarding Toad for SQL Server
Re: TOAD with Oracle and MS SQL Server [message #606255 is a reply to message #606252] Tue, 21 January 2014 13:06 Go to previous messageGo to next message
Michel Cadot
Messages: 59414
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

And the site is name OraFAQ: ORACLE FAQ's.
Everything here is related to Oracle.
And TOAD means TOAD FOR ORACLE, this is obvious.
And once again stay at your place, I am a moderator, you are not.
Whatever I say is rule for you, only another moderator can contradict it.

[Updated on: Tue, 21 January 2014 13:06]

Report message to a moderator

Re: TOAD with Oracle and MS SQL Server [message #606257 is a reply to message #606250] Tue, 21 January 2014 13:11 Go to previous message
Littlefoot
Messages: 19687
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
bws93222

Would it be complicated to set up our existing TOAD to also acess MS SQL?


I'd say that it is not complicated. It is impossible (*). Have a look at TOAD Multi-DB Suites and Quote:

You'll get support for Oracle, SQL Server, and IBM DB2 LUW or Sybase platforms -- in a single, value-priced package.



(*) Not exactly impossible - with ODBC, you'd be able to communicate with a SQL Server database from Oracle. As you said that "read only" is OK, I suppose that this would be an acceptable solution. Check this walkthrough written by Maaher for some more info.
Previous Topic: How to capture Error Code in sqlplus
Next Topic: ORA-12541: TNS :No listener
Goto Forum:
  


Current Time: Tue Oct 21 15:48:38 CDT 2014

Total time taken to generate the page: 0.13758 seconds