.net - Which approach should i opt for? -
in scenario have extract data sql server , migrate sharepoint , record entered database have run console application executes migration process , client gave me strict requirement wants data migrated right away entered in database .
there 2 possible ways , think task can done by
1 scheduling console application run after every 1 minute
2 database pooling (i have heard thing ,can guys me out references articles , other material on internet relevant approach )
so guys think , approach should opt ?
.net has has sql notification
more efficient polling
using sqlnotificationrequest subscribe query notifications
and sure console app correct approach?
consider s service.
also consider siss joe recommended.
Comments
Post a Comment