Improve company productivity with a Business Account.Sign Up

x
?
Solved

Is there any Tool to push existing data into AD

Posted on 2004-08-25
5
Medium Priority
?
214 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
Question by:Yann de Champlain
  • 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 27

Accepted Solution

by:
Pber earned 2000 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
ID: 11902161
I am a programmer but I thaught the Serve rguys could had pass through this before.
Thank.
0
 
LVL 27

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
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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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…
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
If you are looking for an automated tool which can generate reports for Outlook emails and other items from PST file, then you can go for Kernel PST Reporter tool. The reports which are created by this tool are helpful to analyze and understand PST …
Watch the software video of Kernel Import PST to Office 365 tools which can easily import PST and OST files to Office 365 for bulk mailboxes. The process of migration is simple and user can map source and destination mailboxes and easily import data…

595 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