Who is me

C:\> type cardexport.ps1
#----------------------------------------------------------
# Get Data from Oracle original
#----------------------------------------------------------
# backup old content for diff later
mv E:\db\cardexport.txt E:\db\cardexport.bak -force

# now we export the data
( get-content e:\db\extractcard.sql ) | sqlplus -s USERNAME/PASSWORD@ECARDDATABASE | Out-Null

# produce data delta
compare-object (get-content e:\db\cardexport.bak) (get-content e:\db\cardexport.txt) -passThru | where-object { $_.SideIndicator -eq '=>' } | Out-File e:\db\cardexport.ins
compare-object (get-content e:\db\cardexport.bak) (get-content e:\db\cardexport.txt) -passThru | where-object { $_.SideIndicator -eq '<=' } | Out-File e:\db\cardexport.del


#----------------------------------------------------------
# Put data into mssql server
#----------------------------------------------------------
# produce data to insert
Out-File -FilePath E:\db\cardimport.sql -force -encoding ascii
import-csv e:\db\cardexport.ins -Header "zjh","cardserial" | foreach-object -process { Write-Output $_ | fw @{Expression={"insert into uniexchangecard (zjh,cardserial) values ('"+$_.zjh+"','"+$_.cardserial+"');"}} | Out-File -width 5000 -encoding ascii -append e:\db\cardimport.sql }

# produce data to delete
import-csv e:\db\cardexport.del -Header "zjh","cardserial" | foreach-object -process { Write-Output $_ | fw @{Expression={"delete from uniexchangecard where zjh='"+$_.zjh+"' and cardserial='"+$_.cardserial+"';"}} | Out-File -width 5000 -encoding ascii -append e:\db\cardimport.sql }

# now connect to sql server to commit
sqlcmd -S localhost -d ccmtool -i e:\db\cardimport.sql

-- sqlplus -s USERNAME/PASSWORD@ECARDDATABASE < SCRIPT.sql >nul
set echo off;
 set feedback off;
 set verify off;
 set term off;
 set trimspool on;
 set linesize 3000;
 set newpage none;
 set heading off;
 spool e:\db\cardexport.txt;
 SELECT SMT_SALARYNO||','||SMT_CARDSERIAL FROM SMART.VIEW_SMART_CARDINTERFACE where SMT_ENDCODE='0' ORDER BY SMT_SALARYNO;
 spool off;
 /
 disconnect;
 quit;