What is the best way to design my database for replication?
There is no “best way” to design your database for replication. The most important thing is to consider the implications of replication from the very beginning of your database design. We have found that the most successful users of replication test their designs early by using simplified prototypes. The issues raised by replication can be complex because the application no longer has full control of when and where the data is created and updated. The following is a list of areas to think about when designing for replication.
