##############################
# Convert Publish States     #
##############################

# Settings assumed to be available from previous script, uncomment, and optionally correct, if this is not the case
# $StagingLiveTopologyType="StagingLive"
# $purposeLive="Live"
# $purposeStaging="Staging"

# Additional Settings, to be updated
$dbUser = "dbUser"
$dbPassword="dbPassword"
$dbServer="dbServer"
$dbInstance="dbInstance"

#################################
# Do not change below this area #
# Unless you know what and why  #
#################################
$client = Get-TridionCoreServiceClient

# Determine source target and destination targettypes
$sourceStagingTargetId = @(Get-TridionPublicationTargets|Where {$_.Title -eq $purposeStaging})[0].Id.Split("-")[1]
$targetStagingTargetTypeId = @((Get-TridionItem($client.GetBusinessProcessTypes($StagingLiveTopologyType)[0].IdRef)).TargetTypes| Where-Object{$_.Purpose -eq $purposeStaging})[0].Id.Split("-")[1]

$sourceLiveTargetId = @(Get-TridionPublicationTargets|Where {$_.Title -eq $purposeLive})[0].Id.Split("-")[1]
$targetLiveTargetTypeId = @((Get-TridionItem($client.GetBusinessProcessTypes($StagingLiveTopologyType)[0].IdRef)).TargetTypes| Where-Object{$_.Purpose -eq $purposeLive})[0].Id.Split("-")[1]

# Run Convert statements
Convert-TcmPublishStates -DatabaseType MsSql -SourceId $sourceLiveTargetId -SourceType PublicationTarget -DestinationTargetTypeId $targetLiveTargetTypeId -Server $dbServer -DatabaseName $dbInstance -User $dbUser -Password $dbPassword
Convert-TcmPublishStates -DatabaseType MsSql -SourceId $sourceStagingTargetId -SourceType PublicationTarget -DestinationTargetTypeId $targetStagingTargetTypeId -Server $dbServer -DatabaseName $dbInstance -User $dbUser -Password