August 10, 2017 at 11:22 am
The shop that I'm working in utilizes SSIS 2008R2 Transactional Replication(created before I came on board). They wanted to replicate to take some of the pressure off their main database/server. Problem is, not all of their tables have a primary keys. I told them why not just create a primary key of column ID bigint not null identity(1,1) for every table that doesn't have a primary key. Then they have satisfied the requirement of having a primary key on all of their tables
and all reporting can be done at the subscriber database rather than a mix which is what they have now. Can you see any issues with this?
thanks,
August 11, 2017 at 2:04 pm
Not sure what SSIS transaction replication is - maybe a typo?
But in general, you would want to create keys based on the data model instead of replication needs.
You would want to make sure you aren't accidentally creating an inappropriate clustered index in the process of creating the primary keys.
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply