July 26, 2010 at 10:12 pm
hi,
can u give me some help guide lines ( links), for what we need to take care of schema design when we need to use replication technology.
Merge replication:
means publisher and subscriber each will update from other is it right?
🙂
July 28, 2010 at 9:23 am
One big thing on schema design is that you need explicit defined primary keys. Other than that general good design is your best bet.
July 29, 2010 at 12:10 pm
I recommend looking at The SQL Server Books Online: http://msdn.microsoft.com/en-us/library/ms151198.aspx (this is for 2008R2, but all versions are available).
The answer to your question depends on the type of replication you are performing. For example, merge replication has a maximum number of columns limit of 256 and requires a row guid. Transactional has column limits of 1024. All replication methods have a hard row size limit of 8060 bytes. Mixed topologies get tricky.
The docs to a good job of outlining the requirements. If you have any other questions, or want help validating your schema, let me know.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply