Recently i got requirement as, to create backup or restore data from/to SQL database based on user criteria using ASP.Net MVC (.Net 4.5)application. Details are as below,
EmpID | Name | JoiningDate | DeptID
1001 | A | 11-JAN-2013 | 20
1002 | B | 12-JAN-2013 | 21
1003 | B | 17-JAN-2013 | 22
DeptID | Name
20 | Dept1
21 | Dept2
22 | Dept3
i) I have to take data backup based on user criteria like "All employee details joined between certain date range" into external storage device?
ii) Need to restore the same data into sql.
It would be great, if anyone suggests me how to proceed for the solution?