June 4, 2008 at 3:54 pm
I need to configure snapshot replication (Pull) on Enterprise Edition of SQL Server 2005 (acting as Distributor, Subscriber) for Sybase server (acting as Publisher). I have the Sybase ASE client and ODBC driver installed on the Distributor. Can anyone help me add Sybase server as the publisher? Oracle publisher is allowed in Enterprise edition, but sales representative had said that we could have ODBC compliant server as the publisher. There is no option to select a different publisher other than SQL Server publisher, Oracle Publisher. If anyone knows how to do, please let me know.
June 5, 2008 at 11:39 am
aparna_v19 (6/4/2008)
I need to configure snapshot replication (Pull) on Enterprise Edition of SQL Server 2005 (acting as Distributor, Subscriber) for Sybase server (acting as Publisher). I have the Sybase ASE client and ODBC driver installed on the Distributor. Can anyone help me add Sybase server as the publisher? Oracle publisher is allowed in Enterprise edition, but sales representative had said that we could have ODBC compliant server as the publisher. There is no option to select a different publisher other than SQL Server publisher, Oracle Publisher. If anyone knows how to do, please let me know.
You are better off using Sybase Replication Server for this. SQL 2000 allowed to create custom replication using DMO which is now deprecated. 2005 has built-in support (as you have already discovered) for Oracle Publishers only. It may be possible to Write Jobs using al Linked Server to Sybase but then again you will be following a custom route.
* Noel
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply