Client to server data upload

I'm trying to design a system similar to the traditional server monitoring systems like MOM, Tivoli, Open View, where an agent will record data and then upload it to a central database once a day, but them also be able to send immediate alerts back to the server. I'm not sure what the best methodology might be for this. I've started looking at Microsoft sync services but I'm not sure if it will fit my needs. I'm using VS2008 and C#. Does anyone have 开发者_StackOverflow中文版any experience or ideas about how I should go about this task?

This entirely depends on the scale and type of data. A simple solution would be to monitor your data and then store it to a flat file to use SQLBulkLoader to your database. If you had immediate alerts and wanted them to still be handled by the DB you could simply do an insert statement when those alerts happen rather then adding them to flat file.

You can look at: http://dev.mysql.com/doc/refman/5.1/en/load-data.html for info on loading large amounts of data via an infile (SQLBulkLoader library for C#).