var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Proxy table in Sybase that points to MS SQL Server
Can anyone point me to a book or give me a cookbook recipe for creating a proxy table in Sybase 12.5 that points to a MS SQL Server 2005 table?
I have searched the forum, Sybooks, and BOL and it appears that it can be done.
I think you want to look at linked servers (in MSSQL)
Enterprise Connect Data Access Sold as an ASE option provides ASE access either directly or via ODBC connections to IBM DB2, Oracle, SQL Server and any ODBC-compliant DB
Yes, thats what it is called on Sybase ASE.
Originally Posted by georgev
A local table that has been mapped to a table on a remote server. The proxy table contains metadata and is used to access the remote table as if it were a local table.
SQL code needs to run on Sybase to get data from MSSQL
Thanks pdreyer. That is what I was looking for.
I should have highlighted the specific need to run some SQL code on Sybase to get data from MS SQL.
I am assuming that linked servers created on MS SQL allows MS SQL code to get data from or push data to Sybase, but does not allow Sybase to get data from or push data to MS SQL.