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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-06 : 15:43:22
|
Sumit writes "i want to replicate data through internet on two SQL Servers (sql server 7.0). please suggest me the type of replication i should implement considering the following situation -
1. at local server i've tables which are updated locally only but
the data should be reflected on website after some period.
right now i'm successfully handling this through Snapshot replication, by easily replicating data to website's sql server.
2. i also have some tables at local server(on same database as above) which have their counterparts on website's sql server, and on both ends tables gets updated. i want to have identical data at both end once in a day i.e. i want to merge data of both sql servers once in a day to reflect latest updations and insertions.
the above tables uses identity columns and data filtering is also to be done.
should i go for merge or transactional replication for above case?
what type of permissions and roles are needed on website's sql server?
also please suggest which of push or pull subscription is needed.
do i need to have seperate distribution agents for snapshot and other publication?
can the above two replication publications be run through VB 6.0. (i've run them succesfully through VB, by simulating replication locally on LAN)?
please suggest me to have a suitable replication strategy and permissions & roles i should have on website.
thanks
Sumit
" |
|
|
|
|
|
Which type of Replicaiton i should use?