##change to SilentlyContinue to remove write-debug output
$DebugPreference = 'Continue' ## this is the filepath to a local directory. change to a directory on your box. Better to write the files locally and then copy to the network share. This process only writes once to the network share
$outfile_for_script = '' ##Clean up any old files before the process starts
Write-Debug 'checking if script needs to be deleted'
if ((get-childitem $outfile_for_script).count -gt 0)
{
Remove-Item $outfile_for_script*.sql
} ##For this process to work you must set the directory to the location of the SQLCompare.exe
Write-Debug 'set location of sql Compare'
Set-Location "C:Program Files (x86)Red GateSQL Compare 13" # filter ..tables
Write-Debug 'Compare tables...'
.SQLCompare.exe /Sourcecontrol1 /revision1:HEAD /sfx:"" /server2:"" /u2: /p2: /db2: /filter:"C:SQL CompareFiltersTables_filter.scpf" /include:Identical /Options:ie,ip,f,oec,iup,iu,nc,ndl, dacia /scriptFile:"$($outfile_for_script)script.sql" /Force /Quiet Write-Debug "create drop of dependent sps and then drop types" ##print a delineation between each script creation
'-------------------' | Out-File $outfile_for_scriptscript.sql -Append -Encoding utf8
'-------------------' | Out-File $outfile_for_scriptscript.sql -Append -Encoding utf8
'-------------------' | Out-File $outfile_for_scriptscript.sql -Append -Encoding utf8
'-------------------' | Out-File $outfile_for_scriptscript.sql -Append -Encoding utf8 ##QP_Upgrade_Drop_Types_And_Dependencies.sql script finds dependent SP and drop then drops types
get-content Upgrade_Drop_Types_And_Dependencies.sql | Out-File $outfile_for_scriptscript.sql -Append -Encoding utf8 [string]$date = (Get-Date -format MM_dd_yyyy) ##create a new filename with date time and version designation
$path = "$($outfile_for_script)"
$version = ''
$filename = "_Upgrade_$($version).SQL" $scriptpath = $path + $date + $filename Get-Content "C:$($outfile_for_script)script.sql" | Out-File $scriptpath -Encoding utf8 Write-Host "move new upgrade file from $($scriptpath) to " copy-item -Path $scriptpath -Destination \network_share | 
