Fantastic. Thanks Sue.

Thanks for your suggestions, I'll be sure to check out Data Masker. Has anyone here had any experience with DataVeil as a possible solution ?

Thanks.

Thank you for your suggestions so far.

I would have thought transactional replication would be out of the question as well ?  It seems out of the box sql replication will...