They can be on the same box but memory and CPU may be an issue since they both like
hog each.
Dave
-Original Message-
Sent: Friday, September 27, 2002 11:56 AM
To: Multiple recipients of list ORACLE-L
Can Oracle 8.1.7 and SQL Server 2000 be installed on the same box or will they
yes, but not recommended for busy systems.
ok for sandbox though.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, September 27, 2002 11:56 AM
Can Oracle 8.1.7 and SQL Server 2000 be installed on the same box or will
they
conflict?
--
Title: RE: Oracle , SQL*Server Concurrent SELECT
Any
Links , Docs on the Same ?
-Original Message-From: Shripad Bharati
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 02, 2002 9:48
AMTo: VIVEK_SHARMASubject: RE: Oracle , SQL*Server
Concurrent SELECT
U can use Oracle's
Title: RE: Oracle , SQL*Server Concurrent SELECT
Metalink has some papers and docs on this. Also
there is a book called "Oracle Distributed Systems" by Charles Dye. Also,
when in doubt you can always RTFM. ;o)
Dave
-Original Message-From: VIVEK_SHARMA
[mailto:[EMAIL
Also, I believe there is JDBC for MSSQL now - previous there was some
sort of JDBC-ODBC bridging thing, or something like that. So you could
probably use Java stored procedures in Oracle, maybe with a PL/SQL
wrapper, and get at your MSSQL data like that via stored procedure
calls. Hmm.
g
What did you use for the generic connectivity? Merant?
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275
Fuelspot
73
Hmm, very interesting, that may be a good option.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275
Fuelspot
73 Princeton
Or , =gulp= , you could use ASP/COM type objects too. and use the
infamous ODBC...
greg
-Original Message-
Sent: Wednesday, October 03, 2001 9:15 AM
To: Multiple recipients of list ORACLE-L
Hmm, very interesting, that may be a good option.
Do not criticize someone until you
Title: Oracle -> SQL Server
I have
not used it but Oracle Transparent Gateway can query against a SQL Server
database. This is a very expensive product.
Rick
-Original Message-From: Christopher Spence
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 02, 2001 2:41
PMTo:
Title: Oracle -> SQL Server
The only thing that I can think of would be the Oracle Transparent
Gateway for SQL Server. Although on the surface it appears to be a fairly
complex tool, which means it may not be worth the effort over just going ahead
and migrating. Just a thought.
-::YEX::-
Sure, Oracle Transparent Gateway for SQL Server.
--- Christopher Spence [EMAIL PROTECTED] wrote:
I know there is a way in SQL server to query oracle tables, is there
a way
to do the reverse?
I am looking at trying to create access from an Oracle DB to SQL
Server data
until we convert the
There was a transparent gateway for SQL server, but I dunno whether Oracle
still maintains it
or not.
-Original Message-
Sent: Tuesday, October 02, 2001 2:41 PM
To: Multiple recipients of list ORACLE-L
I know there is a way in SQL server to query oracle tables, is there a way
to do
Title: Oracle -> SQL Server
Hi
Look into hetereogenous services, at least i
had it working on NT. I don't know if this worksfor Unix
Jan Benjamins
- Original Message -
From:
Christopher
Spence
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, October 02,
The white paper about the gateway to SQL server can be found
at: http://technet.oracle.com/products/gateways/content.html
http://technet.oracle.com/products/gateways/content.html
-Original Message-
Sent: Tuesday, October 02, 2001 2:41 PM
To: Multiple recipients of list ORACLE-L
I
Hi Christopher,
It can be done, Usually from third party software
companies. For example, Check out:
http://www.datamirror.com/products/tserver/
Back in the day (1996), Oracle had a Mainframe
Integration Technologies group that handled such
problems. You might want to contact Oracle and see if
It is for something which won't have a huge budget as the data is moving
over to Oracle eventually, but for now we want access to it. I was thinking
about just building a java/perl replication engine for now. It isn't a lot
of data. But if there was something pre-packaged it would be nicer.
I
I was thinking that same thing as the easiest way as I know transparent
isn't cheap and there probably isn't an easy way.
I was going to use Perl/Java to make something if there isn't any other way
like the OPENQUERY option in SQL Server to look at oracle tables.
Do not criticize someone until
Oh geez, here I go again.
This is trivial with Perl, DBD::Oracle and DBD::ODBC.
Whether it is useful to you depends on a number of things.
* can you use an Oracl copy of the SQL server data?
* does the data always need to be fresh?
* how fresh?
* how big is it?
Since it's temporary, this may
Try to contact the Mainframe Integration
Technologies group at Oracle and see what path that
takes you. Also, have you tried to see if you can
accomplish your goal by shooting the info from SQL
server to a table in Oracle, then running a query
against that table within Oracle? Did that make
Christopher,
What OS is your Oracle DB on?
If on NT and your version = 816 then you can use the heterogeneous services
- for some more information see Metalink / doco:
I found note 114820.1 helpful - QUICK START GUIDE: WIN NT - Generic
Connectivity using ODBC
Also note 109730.1 - How to setup
Generic connectivity works fine, I have tried this.
You can query MS SQL server tables, but if you want to execute
packages/procedures of SQL server then you have to use
Transparent Gateway for MS SQL server. This is a separate product by
oracle. (you can get more details about this at
21 matches
Mail list logo