publish and subscribe

publish and subscribe

Post by Larry Risse » Fri, 04 Jul 1997 04:00:00

Can someone tell me how publish and subscribe work? We have a vendor who
is trying to set up multiple servers with multiple databases that will
update a data warehouse. He says that, by using publish and subscribe,
he  can update the tables without duplicates, even though one person may
be entered on one system with a different address, etc. than on another
system. This seems a little backward to me, and that one central server
database with all clients accessing that information more efficient and
safer. Any advice?


1. Funky -- publish and subscribe to self all on server

... and yet it pulls data from the remote workstation, even
unidirectionly if I hack the job on the server to use -ExchangeType 1.
Or was it 2?

No publications or subscriptions show in the Enterprise Manager for
the workstation, yet it does have local MSMerge tables, ... sigh.  I'm
still trying to determine if this is workable for our app.

Joshua Stern

2. Why does my DTS from FTP server create local file reference?

3. Replication scenario for publishing and subscribing to the same table

4. Maximum record count

5. publish and subscribe

6. Help: Phone no. of Fox Software

7. Publish and Subscribe

8. Microsoft OLE DB Provider for ODBC Drivers error '80004005'

9. Can't publish and subscribe from FM Pro

10. Loopback Detection (Publish and Subscribe to Each Other) Alternatives ?

11. Auto-Publish and Manual-Subscribing

12. Help:Publishing/subscribing dual role on one sql server

13. Questions about of Subscribe and Publish?