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 think the transparent gateway was dropped, either way it is so expensive and out of the range for such a small project. "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 Street North, Chelmsford 01863 -----Original Message----- Sent: Tuesday, October 02, 2001 4:55 PM To: Multiple recipients of list ORACLE-L 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 such a group still exists and if they can provide you with a solution. Regards, Satar --- 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 SQL server database. > > Anyone have any ideas on this, I searched technet > (ms/oracle) and metalink, > as well as some search engines without luck. > > > "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 Street > North, Chelmsford 01863 > > > > > __________________________________________________ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
