Where I work there is about 400 employees split between several campuses at the two main campuses we have servers set up and shared folders on the servers. I want to setup a system so we have one shared folder that users see but then have copies of all the files on both servers and access the files based on which campus the user is at to stop people having wait while files transfer, and then only if a file is changed force them to have to access the latest copy of the file, and then transfer all files changed overnight so it is not slowing down the network during the day.
Can anyone tell me is there a system that already does this? Or what keywords I should be using when trying to search for a system that does this?
I have been looking at creating a system to do this using MS SQL Server 2012 FileTables and putting triggers on the tables to check which table had the latest copy of the file and creating a store procedure to compress and transfer changed files overnight.