I was asked at my work to look into creating a process to FTP/SOA/HTTP/Other numerous files, catalog them in a database and the index and verify that they are not corrupted. And later I’m asked to create a web service to retrieve these files by a consumer.

The question I’d like to ask is what type of platform you guys would recommend to run these service transactions of indexing, catalog, listening, etc? The company is a M$ based shop so they prefer using M$ products such as SQL Server, Windows whatever, and probably a blade server dual/quad core setup with over a terabyte or more of disk space. Do I use windows services vs scheduled task vs batch runs?

I’m not a hardware guy so I don’t know the best road to take and only utilize other people’s experience on hardware architecture. Some of the other companies I worked for used anything from Linux/Unix boxes to Apache Servers to other. However I am not 100% certain on those either because I only worked on the front end applications and didn’t need to know the specifics of where they resided.

I'll probably have more questions later. Thanks for the help

5/14/2008 8:30:31 AM

ms search server then sql server to look up file stats in tables. that's if you wanted to stay ms and do this quickly and cheaply.

5/14/2008 6:54:45 PM

^^It's MS, not M$. You may want to examine either your keyboard or brain

5/14/2008 7:33:18 PM

i'm guessing the latter...esp given the mention of linux/unix/apache

5/14/2008 9:26:29 PM