Transferring files across servers

[Andrew Banks]

I'm building an e-commerce app and am keeping the client facing front end on
a live web server and the admin section of the app on a local intranet
server. All data is stored in an SQL DB on the live web server.

I will be having in the region of 500 product images in the app and am
looking for suggestions o how to store these.

I could store them in the DB but am concerned about the overhead involved in
serving all images from the DB

or

I could upload images to the live web server from the admin section on the
intranet server (is it possible to FTP files to another server in ASP.NET?)

Does anyone have any thoughts on this?

I want to avoid using an actually FTP client for transferring product images
manually as I can ensure a product doesn't go live without an image if it's
all controlled through the .NET application.

 

[Steve C. Orr [MVP, MCSD]]

This article discusses your dilemma:
http://www.aspnetpro.com/features/2003/07/asp200307so_f/asp200307so_f.asp

In summary, yes there is a bit of overhead involved with SQL Server but it
handles so much of the file management chores for you that it's usually
worth it.