what's the secure way to post the jobs on the etranet?

[asdf]

Hi,

I have the scenario where I have one database and need to post jobs on the
intranet and then the same jobs on the extranet.
I wonder what is the most feasible and secure way of doing it without buying
second license of MS SQL to duplicate the data.
So far I am leaning towards Web Services but we have ideas for MySQL, XML
and using FTP to transfer the data in
files. Which way is the most secure and feasible or is there something else.


Any help is greatly appreciated,
Tom

 

[Giorgio]

I would do it the following way:

MS SQL 2000 and 2005 allows you to output data in XML format and if you
go to Books Online you can find more about this.

Output the XML file to the web server on the DMZ if you own the server
and you can add a rule in the firewall to allow server X (on internal
network) to output to server Z on DMZ. But if you don't own the servers
then you can create very quickly a small .NET program that will watch
the output directory and then FTP the file to the destination server.

Then on the extranet web site you can use asp.net 2.0 and the new
XmlDataSource control that greatly simplifies binding XML sources to
controls, letting you display hierarchical XML data easily.

Hope this helps