Hello, I have to create DB Server for Reporting purpose ( Update statement also included on Reporting server). So i thought the best way to do it by Transactional Replication with minimum latency.But the problem is here , in our DB Schema i have total 430 Tables and only 260 Tables have PK and remain 170 Tables don't have PK. I know it is bad design and i am not able to do replication without PK. So on above scenerio following is my Question. 1: What is best way to create Reporting DB Server in this case? Is Trans Replication is best option? 2: If i want to do Trans Replication then i know that i have to Identify or add PK on those tables which don't have PK. So is it possaibel for me to add Identity Column or GUID in those table? Can Trans Repliaction will accept? Please help me in this case as it is very urgent matter. Project is always in tight schedule Thanks in Advance.