Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Revuca
Starting Member
19 Posts |
 Posted - 2002-11-30 : 04:50:55
|
| Hi all,I have a few questions regarding a replication system the company I work for wants to set up.Basically we want to have mobile users (subscribers) that are able to receive data to a core set of data tables as, and when that changes. We also want to have the mobile users update data changes to the publisher, albeit different tables. The publisher will reside inside our firewall and we don't really want to give anybody access to the servers within the firewall.Would it be possible to put the distributor outside the firewall and give the subscribers access to that and then let the distributor handle replication changes to the secure server ? Or is the best way of approaching it by using a republisher outside the firewall ?We envisage a relatively high usage of the replication processes. Also the subscriber applications are to have embedded MSDE 2000 databases in and proabaly use a dial-up account to replicate changes.Is this feasible and is merge replication the best way to approach it ?What are the best security options to implement ?Any help/suggestions will do.RegardsMike |
|
|
Tim
Starting Member
392 Posts |
Posted - 2002-12-02 : 18:01:10
|
| You definetly want merge replication for this, but I am not qualified to tell you about security.Coul dyour people use dial up to access a web application and avoid the replication altogether?----Nancy Davolio: Best looking chick at Northwind 1992-2000 |
 |
|
|
Revuca
Starting Member
19 Posts |
Posted - 2002-12-04 : 05:09:20
|
| Tim,Thanks for reply. Yes, merge replication is probably the way to go. I envisage we'll set up a republisher outsiede the firewall. Web app is not going tp do the trick I'm afraid. |
|
|
|
|
|
|
Replication questions