clear-host
$errorCode = 0
$object = "InstanceName", "DatabaseName", "PrinicipalName", "PrinicipalType", "Permission", "ObjectTypeLevel", "ObjectName"
$logfile = "C:tempcepgogo.csv"
$oldFile = "C:tempcepBook1.csv"
$newFile = "C:tempcepBook2.csv"
if ((Test-Path $oldFile) -And (Test-Path $newFile)) {
    $impFileOld = Import-Csv $oldFile -Header $object | Sort-object -Property $object -unique
    $impFileNew = Import-Csv $newFile -Header $object | Sort-object -Property $object -unique
    $result = Compare-Object $impFileOld $impFileNew -Property $object -PassThru
    $result | %{if ($_.SideIndicator -eq '=>') {write-host "book2"} #show result
        elseif($_.SideIndicator -eq '<=') {write-host "book1"}
            else {Add-Content $logfile "no changes found."
                    #$errorCode = 0
                }
            }
    } else {
            Add-Content $logfile "files does not exist!"
            #$errorCode = 1
            exit 1
};

clear-host
$errorCode = 0
$object = "InstanceName", "DatabaseName", "PrinicipalName", "PrinicipalType", "Permission", "ObjectTypeLevel", "ObjectName"
$logfile = "C:tempcepgogo.csv"
$oldFile = "C:tempcepBook1.csv"
$newFile = "C:tempcepBook2.csv"
if ((Test-Path $oldFile) -And (Test-Path $newFile)) {
    $impFileOld = Import-Csv $oldFile -Header $object | Sort-object -Property $object -unique
    $impFileNew = Import-Csv $newFile -Header $object | Sort-object -Property $object -unique
    $result = Compare-Object $impFileOld $impFileNew -Property $object -PassThru
    $result | %{if ($_.SideIndicator -eq '=>') {Select-Object $object | export-csv $logfile -NoTypeInfo} #cannot print result to .csv file  ????
        elseif($_.SideIndicator -eq '<=') {Select-Object $object | export-csv $logfile -NoTypeInfo}
            else {Add-Content $logfile "no changes found."
                    #$errorCode = 0
                }
            }
    } else {
            Add-Content $logfile "files does not exist!"
            #$errorCode = 1
            exit 1
};