How to store the data from Active Directory to SQL Server without writing code? [closed]

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. 开发者_运维技巧 Closed 11 years ago.

How to get data from Active Directory to SQL Server with out writing code below type of code

select  *  
 from  openquery(adsi, '  
select  givenName,  
sn,  
sAMAccountName,  
displayName,  
mail,  
telephoneNumber,  
mobile,  
physicalDeliveryOfficeName,  
department,  
division 

from    ''LDAP://dc=ica,dc=com''  
where   objectCategory = ''Person''  
        and  
        objectClass = ''user''  
')  

without writing above type code, we have to connect directly AD to SQL Server.

How to connect directly AD to SQL Server using any type of tools or any simple connection?

Please post the answer. Thanks.

---

There is no point in duplicating the entire Active Directory contents into your SQL Server - and thus, no such solution exists without writing lots of code.

I've been asking over and over again: what are you trying to do and what is your goal?? Why do you need to duplicate the data?

If the data is already in Active Directory and easily accessible - why do you want to duplicate everything into SQL Server?

There are ways to extract some data from Active Directory and import it into SQL Server - but not without writing code. And there are ways to synchronize certain bits of information between AD and SQL Server - but again: code needs to be written, and caution should be taken not to unnecessarily duplicate too much information.