September 6, 2018 at 4:38 am
I am Getting following error while creating Subscription:
Msg 20615, Level 16, State 1, Procedure sp_MSrepl_addsubscription, Line 692 [Batch Start Line 70]
Unable to add a heterogeneous subscription to the publication. The publication is not enabled for heterogeneous subscriptions.
I have already Installed ODBC driver for Postgresql on the server
Kindly provide me solution.
September 6, 2018 at 8:01 am
MADDY30 - Thursday, September 6, 2018 4:38 AMI am Getting following error while creating Subscription:Msg 20615, Level 16, State 1, Procedure sp_MSrepl_addsubscription, Line 692 [Batch Start Line 70]
Unable to add a heterogeneous subscription to the publication. The publication is not enabled for heterogeneous subscriptions.I have already Installed ODBC driver for Postgresql on the server
Kindly provide me solution.
There is a subscription option property for publications to set for non-SQL Server subscribers but it's only supported for DB2 and Oracle. And both of those are deprecated.
For PostgreSQL, you would need to look at something like SSIS, third party replication products, etc.
Non-SQL Server Subscribers
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply