Active Directory export to SQL 2000

[Daan]

Please support me with this one....

We have several domain controllers running Active Directory Services.
We're also running a SQL 2000 server. Our goal is to export complete
or partial active directory objects to SQL 2000.

The only problem is, I don't know how.....

Can anyone please help me

Is it possible to do a direct import from AD to SQL???

 

[Brian Desmond [MVP]]

What are you looking to export? You could use ADSI in a VBScript or
System.DirectoryServices in .Net, and iterate the objects you want data on,
and insert the applicable attributes into SQL.

--
--
Brian Desmond
Windows Server MVP
(e-mail address removed)12.il.us

Http://www.briandesmond.com

 

[Daan]

We want to export objects from active directory such as user accounts,
computer accounts, groups, printers, etc. If possible we want to do
this daily. And still our mail goal is to export directly to SQL 2000.

Thanks in advance.

 

[Brian Desmond [MVP]]

ADSI and ADO will do it. You'll have to loop through the objects returned
from ADSI queries and then insert them into MSSQL. I'd start reading up on
both of these technologies on msdn (http://msdn.microsoft.com).

--
--
Brian Desmond
Windows Server MVP
(e-mail address removed)12.il.us

Http://www.briandesmond.com