Posted by Saiko Consulting on 06/08/06 15:59

I know it's a similiar concept but how about via linked servers?

Mark Graveline
mgraveline@sqlchallenge.com
http://www.sqlchallenge.com
*** Where Only The Best Technical Professionals Compete

Chris wrote:
> I need to link some data from SQL Server 2005 with Oracle 10 data.
>
> One way is to link Oracle server to SQL Server and use ROWSOURCE for
> retrieving data.
>
> What other ways for joing data from both databases exist ?
>
> Can I do it from SQLCRL VB - Stored Procedure ? If yes, what objects
> shall I use for opening database and running an sql ?
>
> Thanks a lot.

• Next in forum: Re: Challenge: Can you optimize this? (summary)
• Prev in forum: Re: Cannot Alter Table being Published for Replication
• Thread view: Re: SQL Server + Oracle Data linked in one query

[Reply to this message]