Hi,
I need to develop windows service, functionality is it should fetch the data from SQLServer database on specific intervals (ex: Every 4.5 mins) and pushing into the Access2003 database.
But that access db is not always available, this is service needs to check the availability of access DB if it is there need to push the data.
In this case how better I can handle, using staging of DB tables or MSMQ.
Please guide me in this regard, if any samples plz provide me.
I'm using VS2008 version.
Thanks in advance.
Regards,
Sridhar