Copying Data from LDAP to SQL 2008

Hi,

I have a SQL 2008 Server and I would like to copy some data from LDAP to the SQL Database and overwrite this information on regular basis.
I am not familiar with both systems and I need help how to start.
I have full access to SQL and also have an account to retrieve data from LDAP.
I may be able to access all the LDAP formation with Softerra LDAP Browser.
Thank you
Nmap2011Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
you can use a linked server querying the LDAP:
http://codebetter.com/blogs/brendan.tompkins/archive/2003/12/19/4746.aspx

HOWEVER, there is a big Heads UP:
the max rows you can retrieve in 1 query is 1000.
so, if you plan to query all AD users/computers/whatever, and the number of rows might, in some future, be more than that, you have to plan your queries in a way that it does this in bunches in an intelligent way to get all of the records ...

hope this helps
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
gothamiteCommented:
Unfortunately there are many issues with using linked servers to query LDAP sources. The big one is that you cannot use the linked server to retrieve a multi-valued attribute. You just get an ugly error message if you try to do this. The best way I have found is by coding a CLR stored procedure/function to make use of the .net DirectorySearcher class. This is a bit involved but gives good results, lets you override the 1000 limit and lets you use multi-valued attributes.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.