× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Okay, here is an interesting one and I am hoping someone has a better idea
of where to take this.

We will be writing an eCommerce application on the internet in ASP.NET. We
have are a local government org that sells licenses, permits, and of course
has utility bills. We currently take utility bills; but because of the
timeframe of getting it live, we duplicated an old method of completely
rebuilding the internet database nightly and collecting the transactions
nightly from a dump from the SQL server. I would like to get rid of many of
the layers of potential problems (FTP, multiple servers, multiple dump jobs)
and go as directly from the i to MS SQL as possible. MS SQL cannot see the
i, but the i can see the MS SQL server.

We will be collecting data from many tables and getting that customer data
on the SQL server. My idea is to put a trigger on each table we want to
track and log all transactions into one table. From there, have a .NET
application poll this table and process all new transactions. This table
would have a system key (to determine the set of tables), the system's
primary key, and what action was performed (add, change, delete).

On the other side, we'll have the transaction table that holds all of the
payments made. I am unsure about any other data that needs to be processed.

I realize this would probably be a prefect use of web services on the i. But
we would prefer to not punch a hole through the firewall from the internet
side (DMZ) to the intranet side if possible. Or can this be done securely
and avoid the possible problems with holes into our internal network?

Any thoughts?

--
Mike Wills
http://mikewills.me

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.