Hi,
I have added an oracle linked server as a subscriber, when I create a push publication, I can not see the oracle linked server as an enabled subscriber under the enabled subscriber list in the 'Push Publication' wizard. Is this something I need to worry o
r this is just how linked Oracle server works?
Thanks.
Once you have created your linked server to Oracle you have to Tools | Replicaiton | Configure Distributors, Publishers, Susbcribers, select the Subscribers tab, click on new, select ole db data source, locate your Oracle Linked Server, enter the account
info, click on it.
When you create your publication make sure you enable it for hetergeneous susbcribers.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Monday, March 26, 2012
push publication for heterogeneous subscriber
Labels:
create,
database,
enabled,
heterogeneous,
linked,
microsoft,
mysql,
oracle,
publication,
push,
server,
sql,
subscriber
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment