Groups | Blog | Home
all groups > sql server replication > october 2005 >

sql server replication : Replication on multiple clients



Robert Craill
10/13/2005 3:01:51 PM
One Server and many clients .
How do I set it up that my clients can replicate with my server.
ie Create the replication.
I am using foxpro as my front end and sql server as my back end.
With SQL Server I can use Enterprise Manager to create the pull subscribtion
..
Work well.
But
the clients don't have SQL Server but get the free MSDE.
I can create the databases and such using foxpro and sql exec commands but
how do I setup the replication.
Is anonymous pull connections safe or must I use named connections.
How do I setup the named pull subscriptions automatically.( via sql
commands)

Thanks in advance
--------------------------------------------------------------------------------
Robert Craill
Web Development
USP Designs (Pty) Ltd

E: robert@cyberprop.com
T: +27 11 955 9100
F: +27 11 955 9110
W: www.cyberprop.com
W: www.cyberagent.co.za
W: www.cyberbonds.co.za

USP Designs (Pty) Ltd is Proudly South African!

This message and any attachments are confidential and intended solely for
the addressee. Any unauthorized use, alteration or dissemination is
prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
loss, whether it be direct, indirect or consequential, arising from
information made available and actions resulting there from.

Robert Craill
10/18/2005 11:26:24 AM
No reply's
Is my request so idiotic

[quoted text, click to view]

Raymond Mak [MSFT]
10/21/2005 3:40:05 PM
Hi Robert, you can use replication system stored procedures to set up
replication in your case. The documentation for
sp_add[merge]pullsubscription[_agent] should be able to get you started.

HTH

-Raymond

[quoted text, click to view]
AddThis Social Bookmark Button