🚀 go-pugleaf

>> 3)There is a requirement for a module(running on the machine hosting the
>> database server)in the application which needs to ftp to and from the
>> machine hosting the dataabse server
>
>If the module is in an application that is running on the same machine as
>the database servicer, then why are you using FTP to move the files around?
>Why not just call CopyFile/MoveFile() instead?  Your design is very
>confusing to me.


Some files will be created on the Server machine depending on the transactions happening in the database. These files needed to be FTP'd to some "remote server".

The service will continuously poll at some specefic directories on our database server machine, to do this FTP to some remote server.

>> a)The background process should get started whwnever the first
>> client apllication connects with the database server.
>
>Why does the process require a user login at all?  Since it is a service, it
>is already running when the machine is booted up.

Yes, the Service will get started as soon as the OS satrts.
But users want some control over the service from within the client application. 

>> b)Each client application will have a button through which it can
>> stop the service if it is running.
>>
>> c)There will be another button in client application which can start
>> the service if it is stopped.
>
>If the clients are running on different machines than the service, then they
>will not be able to start/stop the service directly.
>
>> d)As soon as the last coonected client application gets disconnected
>> with the database server, Service should get automatically stopped.
>
>I think your understanding of "service" may be misplaced.  Please explain
>what you THINK a service really is.  Your explanation does not sound like a proper service model.

Sir, I do understand the purpose and working of services. Its only the requirements from end-users because of which we have to give the users the required control over the service.

regards,

Deepak