Which Replication Model should I use?

Last Post 01 Jun 2005 06:47 AM by LOsql. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
LOsql
New Member
New Member

--
01 Jun 2005 06:47 AM
hi, forum:

I need some help with deciding on implementation of a project that may require replication, possibly two-way. Which model should I use, and on one side, could I use DTS instead??
I'm not sure if latency is an issue, so I don't think transactional is the right one. Here's what I'm being asked to do:
I've been given a list of tables to be replicated into and out of DMZ (I got the part about opening ports) One set of tables, the majority, are to be one direction from Internal Network to DMZ. Here I can use I guess, either snapshot or transactional.
Another smaller set of tables, only two, require two-way replication, Internal to DMZ, and DMZ to internal. They have to be in synch. Should I use merge repl here, immediate updating subscribers, or plain ole DTS???
Any help or ideas on what one would do with the above task would be most helpful. Our timeline is getting shorter. PLEASE ADVISE ASAP! TIA
You are not authorized to post a reply.

Acceptable Use Policy