One issue that I seem to have missed in this stairway.. If you are looking at Transactional Replication... you MUST have PK set on the tables you are replicating.. this is an issue for our inventory data, since our software has this data vectorized and what is tuple 129 today holds no relation to what is 129 tomorrow. The only way I can see to handle this.. is by snapshot.