Solved

Export from Server 2008 to import to Server 2008

Posted on 2012-03-22
9
445 Views
Last Modified: 2012-04-12
Hi all,


Server 2008 R2 with around 75user accounts.


I have a new Server 2008 R2 server and I wish to import the user names only. Not worried about keeping the passwords. Just first name, surname and username

Can some one advise of the best way to do this?
0
Comment
Question by:unrealone1
9 Comments
 
LVL 37

Expert Comment

by:Neil Russell
ID: 37753568
Are you talking about active directory?
Is this to a NEW Active Directory domain?
0
 
LVL 1

Author Comment

by:unrealone1
ID: 37753579
Yes from AD on a Server 2008 R2 server to AD on another 2008 R2 server.

domain MyCompany.Local is the same.
0
 
LVL 37

Expert Comment

by:Neil Russell
ID: 37753581
If your on about LOCAL accounts then see here, is simple :D

Local User and Group Migration Guide
http://technet.microsoft.com/en-us/library/dd379531(v=ws.10).aspx
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 37

Assisted Solution

by:Neil Russell
Neil Russell earned 167 total points
ID: 37753588
If it is the SAME domain then you dont have to do anything.

You create your new server, join it to the domain and then DCPROMO it to a DC. It will replicate all users between and you will have 2 AD servers,
0
 
LVL 1

Author Comment

by:unrealone1
ID: 37753605
This new server is being built offsite. It won't be touching the old server. All I want to do is export the user accounts to a csv, so I can then import them.
0
 
LVL 16

Assisted Solution

by:R. Andrew Koffron
R. Andrew Koffron earned 167 total points
ID: 37753748
to export a csv file just open the users and computers, choose the OU with your users in in and go to the view menu>add/remove columns create the veiw you want and export to a text file.  than you just need to import to excel and change the tab delimited to comma delimitated  .
0
 
LVL 40

Accepted Solution

by:
Adam Brown earned 166 total points
ID: 37753753
Powershell's the easy way. Using the 2008 R2 Active Directory Module for Powershell:

On the first server:
get-aduser -filter *| select samaccountname,givenname,surname | export-csv <filename>

On the second server:
$users = import-csv <filename>
foreach ($user in $users)
{new-aduser -samaccountname $user.samaccountname -givenname $user.givenname -surname $user.surname -accountpassword (ConvertTo-SecureString -AsPlainText "<password you want>" -Force)}
0
 
LVL 1

Author Comment

by:unrealone1
ID: 37757014
Ran the first command to export. This appeared to work ok.


On the new server using the Powershell Active Directory.

I run this command:

$users = import-csv thefileiexported
foreach ($user in $users)
{new-aduser -samaccountname $user.samaccountname -givenname $user.givenname -surname $user.surname -accountpassword (ConvertTo-SecureString -AsPlainText "mypa55word" -Force)}

and then I get

>> 

(I press enter)

Then I get

cmdlet New-AdUser at command pipelane position 1



Please advise?
0
 

Expert Comment

by:JerseyGiant
ID: 37838896
did you ever get an answer?
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

I was supporting a handful of Windows 2008 (non-R2) 2 node clusters with shared quorum disks. Some had SQL 2008 installed and some were just a vendor application that we supported. For the purposes of this article it doesn’t really matter which so w…
Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

730 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