I need a windows console application (or similar) that will pull records from an SQL 2005 database and create Appointments in exchange user calendars.
I would like? it to operate as a windows service (ie no user needs to be logged on) and automated without the need for Outlook to be installed (ie direct access to the Exchange data store) and to be written in Visual Basic .net.
It will be adding appointments to an Exchange 2007 server but we will be upgrading to 2010 in the next 12 months so should use modern communication protocols (ie not webdav as I believe this is upto to 2007 and not for 2010).
## Deliverables
* The application should not have any hard coded variables (such as SQL server name and username/password, Exchange server name etc), they should be in aform that can be edited by the user and rad at runtime by the application (ie ini file or similar).
* Once connected to the SQL server further settingsccould be stored there - will take advice from coder.
* The applications would idealy run when a record is added to the source table but if this is not feasable a schedule (editable for frequency, time of day) could be used.
* The application will need to add new calendar entries (when new records are created in the table), update existing calendar entries (when existing records in the table are updated) either by deliting the original appointment and creating a new one or identifying the change and updating the existing calendar entry and also it should be able to delete/remove the calendar entry when a filed in the record in the table is marked (ie yes/no check).
* I am open to advice from professional coders as to changes that would benfit or improve my specification.
* The application will be run in our network and will not need access outside of our system.