sujainarayanan (7/14/2014)
So the only wise option from would be to avoid implementing CDC on the source for the above two reasons. Instead we are looking at somehow replicating the source at another database and then implementing CDC on the destination database
The only wise idea would be to add the required Primary Keys ;-). You shouldn't repeat the same mistake that the previous DBAs did over there.
Just make the changes slowly i.e. start with few tables (order by importance) & see how it goes.
sujainarayanan (7/14/2014)
Is there a way we can do replication whilst still being able to alter the table definition on the secondary database? Any suggestions on this would be greatly appreciated. Thanks
Once you have added Primary Key, you can easily use the Transactional Replication & implement CDC on subscriber.
Note: Transactional Replication also requires the tables to have the Primary Key.