Hi all,

hopefully this is the right place to ask!

I need a robust method to copy image files (mainly pdf's, jpg's and
tif's) from a document management system inside a corporate lan onto a
dmz to enable public access over the net.

The current methodology for this is for a scheduled task on the lan
side to uuencode new files and, having a sql*net rule (or MSSQL
equivalent, depending on the client's preferred db) on the firewall,
insert the resultant text into a field on a staging-db in the DMZ.

Another scheduled task running in the DMZ then reads the rows in the
staging-db, recreates the files by unencoded them and writing them
out.

However, this is prone to all sorts of errors - scheduled tasks can
fail, encoding process might not work for some files, database inserts
might fail, unencoding doesn't work, etc, etc.

What I really want is a single scheduled task (I don't mind where it
sits - lan or DMZ) that can copy the files over without compromising
the security of the lan.

Is there a secure method to open up a firewall in this way?

Thanks in advance

Neil