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

• Next in forum: install SS 2005 on win2k3 ENT or STD, which is better??
• Prev in forum: Accessing external data from SQL Server
• Thread view: Re: Accessing external data from SQL Server

[Reply to this message]