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 |
|
matt_calhoon
Posting Yak Master
235 Posts |
 Posted - 2001-05-09 : 07:26:44
|
| Hi there,I have a project that requires some form of replication from an intranet SQL 7.0 server to a SQL 7.0 web server. the SQL database on the intranet will be the publisher and the web server db the subscriber. Data on the Intanet server gets updated around 30 times a day. now each time a change takes effect, Id like the subscriber to reflect those changes.What Id like to know is, what form of replication should I use for this scenario (the one with the less load on the web SQL server would be best), what problems should I expect (with firewalls etc) - I havent done replication before and am looking forware to sinking my teeth into it!So any help/recommendations would be appreciated.Matt |
|
|
nasirnaqvi
Starting Member
2 Posts |
Posted - 2002-05-20 : 03:18:31
|
| Hello Dear,I'm creating a scenario for SQL-Server replicationover the internet. I want to use one SQL-Server behindproxy than move to the InterNet than penitrate intoanother proxy than aknowledge into another SQL-Server(and vise versa)I've read "Configuring Proxy Server For SQL-Server 7replication over the InterNet from Microsoft web site,but it'll provides us with one proxy and for pullreplication scenario. My situation is push andbyDirectional having 2 proxies. Remember both SQL-Server and Ms-Proxy all foure PC(s)are PDC having same user/password authentication user,but not have any trust relationships between them. My problem is how to configure FTP for SQL-Server,since SQL-Server listen on FTP for internet?Can anybody explain me how to do it? I'll be waitingfor any positive reply soon.Caio,NN |
 |
|
|
|
|
|
Which Replication to use...