web site data transfer question

[dinger2121]

We are trying to collect information from a form on our web site that we would like to load into an SQL Server DB. We have a SQL Cluster that is on our internal network. Our Web server sits in the DMZ. We would like to avoid opening up the cluster to DMZ using NAT since that opens a potential vulnerability with access to our total cluster.

Does anyone have any recommendation about the best method to go about accomplishing this?

Thanks for any thoughts.

 

[BabyJeffy]

Some ideas:

You could add a mySQL server to the DMZ. Just a single node mySQL (if you are collecting form data, it's not going to need a clustered database - performance test this to be sure).

You could email the data instead (server-side). Would probably mean setting up a mail server as well (?).

You could write the data to disk as seperate txt files (and then have an automated script from within the Internal network that collects that data and handles cleanup etc).

Cheers,
Jeff

[tt]Jeff's Blog [!]@[/!] CodeRambler

http://www.coderambler.com/

http://www.coedit.co.uk/

[/tt]

Make sure your web page and css validates properly against the doctype you have chosen - before you attempt to debug a problem!

FAQ216-6094

 

[dinger2121]

I think I am going to go the route of creating text/xml files on the server and then grabbing them in using an application from within the network.

Thanks