Exchange Server Sync with SQL

IN PROGRESS
Bids
10
Avg Bid (USD)
$164
Project Budget (USD)
$100 - $250

Project Description:
I have a table in SQL server 2005 that i need to have code to keep it sync'ed with multiple address books in Microsoft Exchange Server.

the 'syncing' is a one way from the table to exchange server.

Once a day the service (or the scheduled app) will run and delete the address books(s) we have contacts for (not all address books on the exchange server) then recreate those books as per the contacts in the table.



There are more than one address book.


The table has the following fields:
SELECT [BookName]
,[ContactID]
,[FacilityNumber]
,[HomePhone]
,[CellPhone]
,[Comments]
,[Department]
,[Country]
,[Organization]
,[Address]
,[City]
,[State]
,[Zip]
,[OfficePhone]
,[FaxNumber]
,[Greeting]
,[FirstName]
,[LastName]
,[DisplayName]
,[Title]
,[EmailAddress]
,[Salutation]

FROM MyContacts


[BookName] : there could be more than one address books. This field will have the address book name that the contact belongs to.

[ContactID] and [FacilityNumber]: these are informations that i want stored in the contact (if Exchange server allows custom fields.

Other fields are obvious..


- All variables must be in a XML, ini, or any other easily changed file format.
- variables will include:
? ? ? ? .. Connection String
? ? ? .. SQL statment (use the same statement as mentioned on top, but alow the statement to be changes.. however field names will be the same and safe to hard code the field names). This gives me the ability down the road to use "as FirstName" for example to change the source of the SQL statement.
? ? ? .. All Exchange server properties.

- Languages allowed: C# or vb.net (pref C#)
- Source code must be included.


## Deliverables


* * *This broadcast message was sent to all bidders on Tuesday Sep 22, 2009 7:12:40 PM:



(message broadcast about Exchange<->SQL server project) Hi; I forgot to mention that the 'syncing' is a one way from the table to exchange server. Once a day the service (or the scheduled app) will run and delete the address books(s) we have contacts for (not all address books on the exchange server) then recreate those books as per the contacts in the table. I hope this clarify the project

Skills required:
.NET, C# Programming, Engineering, Microsoft, MySQL, PHP, Project Management, Software Architecture, Software Testing, SQL, Visual Basic, Visual Basic for Apps, Windows Desktop
Hire talalmoughnie
Project posted by:
talalmoughnie Canada
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.