Speed of copy from SP2007 to SPO is too slow

​I did this for a project server migration from SharePoint 2010 to SharePoint online. Run this script first to get your users and append the claims ID. After which run the script about with this as the input file.

## create import.txt "copy screen contents to import.txt file with select all remove bottom line"

##before running Metalogix Script posted first get your users from AD and append claims, rename this file from .txt to .csv without opening it.

Get-Module ActiveDirectory

cls

$searchOU = 'OU=Project Server,OU=SharePoint,OU=All Groups,DC=dhs,DC=sdc,DC=pvt'

$user = @()

$baddata = @()

$data = @()

$users = get-adgroup -Filter 'GroupCategory -eq "Security"' -SearchBase $searchOU | Get-ADGroupMember -Recursive

Function Remove-File {

if(Test-Path -Path "C:\Users\or0213535\Desktop\ProjectServerWorkingfolder\import.txt")

{Remove-Item "C:\Users\or0213535\Desktop\ProjectServerWorkingfolder\import.txt"}

}

Remove-File

foreach($user in $users)

{

If($user.name -notlike "OR*" -and $user.name -notlike "P*" -and $user.name -notlike"xts*")

{[array]$baddata += $user.name}

$user.Name | Out-File -Append C:\Users\or0213535\Desktop\ProjectServerWorkingfolder\import.txt

[array]$data = Get-Content C:\Users\or0213535\Desktop\ProjectServerWorkingfolder\import.txt

}

$cleandata = $data | Where {$baddata -NotContains $_}

###########################Remove Test Users or any other errors in source file. The original import.txt should only have P# OR# and XTS# Numbers.

## now you have your source file create import file for MLS creation.

Remove-File

foreach($user in $cleandata)

{

## Concantenate values. for a properly formated Import.txt file. You will rename this to Import.csv on the server to create the MLS XML package using PS_GenerateUserMappingMlsFromCSV_Working_v2 in the

$U = get-aduser $user -Properties SamAccountName, UserPrincipalName

"dhs\" + $u.SamAccountName + "," +"i:0#.f|membership|" + $u.UserPrincipalName | Out-File -Append C:\Users\or0213535\Desktop\ProjectServerWorkingfolder\import.txt

}

​I did this for a project server migration from SharePoint 2010 to SharePoint online. Run this script first to get your users and append the claims ID. After which run the script about with this as the input file.

## create import.txt "copy screen contents to import.txt file with select all remove bottom line"

##before running Metalogix Script posted first get your users from AD and append claims, rename this file from .txt to .csv without opening it.

Get-Module ActiveDirectory

cls

$searchOU = 'OU=Project Server,OU=SharePoint,OU=All Groups,DC=dhs,DC=sdc,DC=pvt'

$user = @()

$baddata = @()

$data = @()

$users = get-adgroup -Filter 'GroupCategory -eq "Security"' -SearchBase $searchOU | Get-ADGroupMember -Recursive

Function Remove-File {

if(Test-Path -Path "C:\Users\or0213535\Desktop\ProjectServerWorkingfolder\import.txt")

{Remove-Item "C:\Users\or0213535\Desktop\ProjectServerWorkingfolder\import.txt"}

}

Remove-File

foreach($user in $users)

{

If($user.name -notlike "OR*" -and $user.name -notlike "P*" -and $user.name -notlike"xts*")

{[array]$baddata += $user.name}

$user.Name | Out-File -Append C:\Users\or0213535\Desktop\ProjectServerWorkingfolder\import.txt

[array]$data = Get-Content C:\Users\or0213535\Desktop\ProjectServerWorkingfolder\import.txt

}

$cleandata = $data | Where {$baddata -NotContains $_}

###########################Remove Test Users or any other errors in source file. The original import.txt should only have P# OR# and XTS# Numbers.

## now you have your source file create import file for MLS creation.

Remove-File

foreach($user in $cleandata)

{

## Concantenate values. for a properly formated Import.txt file. You will rename this to Import.csv on the server to create the MLS XML package using PS_GenerateUserMappingMlsFromCSV_Working_v2 in the

$U = get-aduser $user -Properties SamAccountName, UserPrincipalName

"dhs\" + $u.SamAccountName + "," +"i:0#.f|membership|" + $u.UserPrincipalName | Out-File -Append C:\Users\or0213535\Desktop\ProjectServerWorkingfolder\import.txt

}