Windows Service with Queing [英] Windows Service with Queing

问题描述

我需要开发Windows服务，其功能是它应该以特定的时间间隔(例如，每4.5分钟)从SQLServer数据库中获取数据并推送到Access2003数据库中.
但是该访问数据库并不总是可用，这是服务需要检查访问数据库的可用性(如果需要推送数据的话).
在这种情况下，如何使用数据库表或MSMQ的暂存方式更好地处理.
如果有任何样品请提供给我，请在这方面指导我.
我正在使用VS2008版本.

提前谢谢.

问候，
Sridhar

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

推荐答案

最简单的方法是使用std::deque存储要执行的查询.您也可以将此数据转储到磁盘.

The simplest way is to use std::deque for storing quieries to be executed. You can also dump this data to disk.

这篇关于Windows Service with Queing的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！