Real-time connection between a SQL Database and Outlook contacts

regsamp
regsamp used Ask the Experts™
on
We have a SQL database for our rolodex that has thousands of contacts and we are looking for a way to setup those same contacts on an Exchange 2010 server or in Outlook 2010 where a change on one end changes on the other end automatically.

We are talking about 8000 contacts and if someone makes a change in the SQL Database, it shows that change in a Manager's Outlook which in turns shows on their iPhone. And if they make a change in their Outlook or phone, it changes the SQL Database.

Is there anything that can do this automatically and real time?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
AmitIT Architect
Distinguished Expert 2017

Commented:
Both application are designed for different purpose. It is not impossible, however it will mess up your Exchange environment. Any reason to use SQL for contacts?

Author

Commented:
What about something like this program?

http://www.exchangewise.com/products/mxsync/index.htm

Our Rolodex is in SQL 2008 with 8000 contacts and the two managers want those real-time in their phones.
IT Architect
Distinguished Expert 2017
Commented:
Tell them it is not possible. You cannot satisfy everyone need. As IT admin, you should be dominating the IT environment.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
Okay, thank you. I wish our IT Dept. had the ability to have some say. The culture is the opposite of what it should be.
AmitIT Architect
Distinguished Expert 2017

Commented:
You can share my answer. Tell them you checked everywhere and unable to find any solution.

Author

Commented:
Okay, thank you.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial