Closed

Exchange Server Sync with SQL

This project was awarded to Robotapps for $182.75 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$100 - $250 USD
Total Bids
10
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 [url removed, login to view] (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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online