Wednesday, March 30, 2016

Synchronize SQL with information from Active Directory

I would like to pass information from Active Directory to a Microsoft SQL Server database any time a change is made in Active Directory. In this way the SQL will always have a reliable copy of the AD.
Well, i have been reading some post that deal with similar questions, but I can't find the solution.



In this post, for example: https://stackoverflow.com/questions/4782292/synchronization-between-c-app-and-active-directory
, a user said:





'...Then let AD synchronize with SQL.'




That sounds good for me, but how can I do that?



@Pablo: So we have an existing c# application that manages users and groups in SQL. We would like this app to manage also the Active Directory. The idea is to query Active Directory (AD) directly with the application but also continue saving the information in the SQL as it does now. But I see a problem: when changes are made only in the Active Directory => SQL will not have an updated information, because we will have different data between AD and SQL.



I see you propose to query AD for changes and it can be done per access or using polling on a scheduled interval. I'm not familiar with it, could you explain me how to do that?

No comments:

Post a Comment

linux - How to SSH to ec2 instance in VPC private subnet via NAT server

I have created a VPC in aws with a public subnet and a private subnet. The private subnet does not have direct access to external network. S...