Posted by Greg D. Moore \(Strider\) on 03/21/07 15:26

<arshad.tanveer@gmail.com> wrote in message
news:1174488978.618140.16840@e65g2000hsc.googlegroups.com...
> Hi,
> I have a Sybase dataserver containing lots of (huge) tables that I
> would like to access from SQL Server (two different applications,
> using two different datasources, now want to talk to each other). MS
> Access has a feature for 'linking' external data. Can I do similar
> stuff in SQL Server?
> Basically, I am trying to avoid having to duplicate the data in both
> the dataservers and worry about keeping them in sync.
>
> Regards,
> Tanveer
>

Yes, look up linked servers in Books-Online. I haven't done this with
Sybase but would be surprised if you can't.





--
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com http://www.greenms.com

[Back to original message]