Solved

Is there any Tool to push existing data into AD

Posted on 2004-08-25
5
189 Views
Last Modified: 2010-04-19
Is there any Tool to push existing data into AD?

We got a ms sql server db for a intranet phonebook. Many infos need to be push from there into AD.

Would like to know if I need to create my own synchronisation program or if there is already somehting availalble on the net to accomplish the task.

thank.
0
Comment
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 12

Expert Comment

by:ColinRoyds
ID: 11897191
I think this would probably be best answered under a vb area, as you might need a custom app to do it.
0
 
LVL 26

Accepted Solution

by:
Pber earned 500 total points
ID: 11902100
You may be able to do it with a tools called "ldifde.exe" that comes with either the reskit or the support tools.  You'll probably be better using VB or VBS as ColinRoyds mentioned as you probably need to manipulate the data somewhat.

Check these links out for ADSI ideas
http://www.15seconds.com/issue/011127.htm
http://dev.coadmin.dk/Resources/ADSI%20SDK%205%20HTML/winnt.htm

or try WMI
http://www.microsoft.com/technet/community/scriptcenter/user/default.mspx
0
 

Author Comment

by:Yann de Champlain, PMP
ID: 11902161
I am a programmer but I thaught the Serve rguys could had pass through this before.
Thank.
0
 
LVL 26

Expert Comment

by:Pber
ID: 11902240
There are tools out there, but they are expensive and from my experience, you are probably better off writing your own code.  

If you want a commercial product, just search for "SQL LDAP sync"

We've purchased some products from SUN to sync our UNIX LDAP directory with AD's LDAP directory.  We've had nothing but grief setting it up.  With commercial products you usually end up having to write some custom code anyhow to make things work.
0
 

Author Comment

by:Yann de Champlain, PMP
ID: 11902266
Thank you Pber. This is also my conclusion after I read from the urls you provided.
The code snippet they provide to use the tools are not really better then rewriting somehting in .dotnet

Thanks again.
0

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Backup DHCP Server 8 137
Exchange 2003 converted to VM but now email does not work 5 81
Migration of AD user accounts from Server 2003 to 2012R2 5 127
MS Endpoint Protection 2 104
I guess it is not common knowledge to most Wintel engineers/administrators: If you have an SNMP-based monitoring system in your environment (and it's common to have SNMP or Syslog) it's reasonably easy to enable monitoring of the Windows Event logs,…
Scenerio: You have a server running Server 2003 and have applied a retail pack of Terminal Server Licenses.  You want to change servers or your server has crashed and you need to reapply the Terminal Server Licenses. When you enter the 16-digit lic…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question