Export Calendar items from Exchange 2010 Public folder to MS SQL 2008

  • Overall situation: We are now migrating from a Windows 2003 Server domain to a Windows 2008 Server R2 domain. At the same time, we are migrating mailboxes from a Exchange 2007 to an Exchange 2010.

    Current situation: we use an Access 2003 API (a front-end MS Access application) to get the calendar items of a public folder and place them in an MS SQL 2008 database. This public folder resides on an Exchange 2007. The MS Access "application" is on the D drive of the pc's of persons who have the permissions to put items into this public calendar and it uses the Outlook 2003 client to get the calendar data.

    Problem: we don't find an apropriate Access 2010 API to use with MS SQL 2008 database

    Desired situation: a solution (via Powershell or other scripting) that reads the calendar items directly from the public folder on Exchange 2010 (without the need to use an Outlook client) and copy/sync it with the MS SQL 2008 database (on another server) on several timepoints (e.g. every 6 hours or every day at 18:00 PM).

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply