Windows or web application for running long running store pr
When data collected we restore of database backup file to another server where I am executing some store procedures sequentially.As procedure executing time from 25 mins to 7 hours approx.But now we are now making this task should run from UI.I want to know which is proper way to execute this long running procedures from UI whether Windows application or Web Application?After procedure executed successfully we again restore database to live server.
Right now I am running this procedure on server directly by execute command on SQL Server.But this process(task) is more tedious and complex.This takes long time and causing issues when some times process wrongly executed (e.g.- due to wrong parameter ...etc). For this I have created one windows application but as database is on another server we need to install this application on server also .I would like to know which is best application Web or Windows to execute long running procedures in UI?