I'm sure there are a dozen different ways that this can be accomplished and many things that will make some better that others.
I have a VM win2012R2 SQL2016dev 'dev' and a box win2016 sql2016ent 'prod'
Developers cannot have any access to prod, and have full access on dev.
I would like to provide them with the same data that is written to the LOG table in one DB on prod.
I have thought of a few options;
SSIS - mainly the ability to move data between 2 different systems, but I don't think that this is a good idea.
trigger to Linked server - not even sure if this is possible.
replication - have not worked with this yet.
What suggestions do you have ?