- LDAP to populate SQL 2000/Active Directory
- Posted by Angel on January 30th, 2004
Hello all - I have a LDAP service running on a NT4 box (not a mbr of
my AD domain), I'd like to extract the users/attributes from that LDAP
service and populate my AD domain with those users and attributes (the
user accounts in LDAP will go into AD and the attributes for those
users will go into SQL Server 2000 database). Does anyone know of a
tool or how I can go about doing this? (the SQL server is a mbr of the
AD domain)
MS didn't have an LDAP group but if someone knows of a way for me to
extract the data from LDAP into a whatever format and do this sort of
mapping in AD - I'd appreciate the sharing of knowledge - Thanks in
advance.
- Posted by Warren Dale on February 2nd, 2004
On 30 Jan 2004 08:53:00 -0800, angelohl@hotmail.com (Angel) wrote:
It's been a while since I did LDAP, but (under UNIX at least) there is
a batch command which will dump selected fields from selected records
in a defined but unfriendly format. You could then filter them using
Perl/AWK etc and use as input into SQL.
Warren.
- Posted by WebMonster on February 25th, 2004
If you don't know Perl, you can check out some sample scripts created by "4 Guys from Rolla" on their web site at:
http://www.4guysfromrolla.com/webtech/030100-1.shtml
You'll have to edit the LDAP calls for your domain, but it works fast once you start. I migrated 250,000+ users in 5:42 minutes. My SQL box has always been pokey, yours may go even faster.
Peace,
WebMonster
