If you are pondering the replication route remember every single table HAS to have a primary key in order for it to be replicated.