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