| TOAD with Oracle and MS SQL Server [message #606250] |
Tue, 21 January 2014 12:34  |
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 #606252 is a reply to message #606250] |
Tue, 21 January 2014 12:47  |
Lalit Kumar B
Messages: 3174
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 |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
 |
Littlefoot
Messages: 21823
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
