I have a more complicated solution (VB progamming) - but am wondering if
this CF solution will work.

The scenario - I have a SQL table that needs to be replicated (changed data
only) to
a remote client's db every 5 minutes. (The data is credit applications.) At
the same time, I need to check to see if they have new data for me
(approvals, etc) and GET that.

The simple thing would be SQL replication using a VPN, but they're insisting
on using SSL for the transmission security.

I don't know how to make SQL use SSL, so here's my thought:

We load a CF page into our browser on our server. They open a session
connection with this page on theirs, also using a browser.

We refresh the page every 5 minutes - many ways to program that (CF, JS,
etc).

Functions of the page:

1) run a query for new data
2) use CFHTTP to POST any new data to a form or CGI script on their end
3) use CFHTTP to GET any new data on their end and return to our DB

If we run the browsers continuously, we can maintain an open session.....and
we only have to re-establish the connection when one of the servers is
re-started.

Does this make sense, is it feasible, and am I overlooking something
critical?

TIA!!
~D

************************
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to