Windows Server

Ben · Guest

Hi

We have hundreds of thousands of files which have been stored using a
Document Managment System which relate to our clients.

The files are stored in folders based on the first two letters of the
client's surname and their code: e.g.
\\servername\ClientFiles\M\I\MICROSOFT123\

Each file has a corresponding database record, and we want to replicate a
few files per client to our remote webserver (over VPN) for them to be able
to read.

Obviously replicating all files is unnecessary, the database record states
which we would like to replicate, is it possible to replicate only files
that are returned by a SQL Statement and remove files from the webserver
that are no longer returned by the statement?

Thanks
B

Paul Williams [MVP] · Guest

Errr...yes, probably. But not natively. You're going to have to write some
code - script or app - that will run the SQL command and move/ copy the
files in question. What you do at this step is up to you. You could simply
copy/ move the files to a temporary directory and then ROBOCOPY them down to
the other server. Or you could drop them into a DFS/ FRS link that is
configured to replicate, e.g. \\server\dfs\repl is the folder configured to
replicate. You drop the sub folders and files in there, e.g.
...\repl\m\i\*.*

Depending on what you wish to do with the other files, you could also
configure DFS and simply delete what isn't returned by SQL. You could then
enable replication.

--
Paul Williams
Microsoft MVP - Windows Server - Directory Services
http://www.msresource.net | http://forums.msresource.net

	Windows Server Forum Index -> DFS and FRS	All times are GMT
Page 1 of 1