In your setup, did you setup remote gateway connections between dev/test/prod at all, or are they each their own without knowledge of the other?
Each on their own. The active files on each server are the respective branch of the repo, and each project repo. So only working in Dev on my computer, the test server only pulls the test branch, the production environment only pulls Prod
When importing your tags for dev, do you change them all to memory or read-only so that if writes occur, they don’t affect the PLC?
yeah if connecting to a PLC I set them all read only and most of them disabled except for what I'm working on. I've made judicious use of UDTs which I think makes it easier. I can have a Dev UDT with everything disabled and then switch the type after.
Does your dev connect to same db as test?
yes, that might not be kosher to some but for us I don't see a problem with it and I would rather work with a copy of our real tables & data than some kind of pantomime.
To sync prod to dev pc, is it a gateway backup that you import?
Yep exactly - there's a nice option in the gateway settings to disable all connections on restore.