Advertisement
ghx8

mmx2sql.sh

Mar 21st, 2018
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.55 KB | None | 0 0
  1. /usr/bin/python /home/henry/milan/mmx_copy.py
  2. find /home/henry/milan/mmx -name "*.mmb" > /home/henry/milan/srclist.txt
  3. /opt/mssql-tools/bin/sqlcmd -S139.162.62.157,3306 -Uibs011 -PeczvFa -Q "truncate table ibs011..srclist"
  4. /opt/mssql-tools/bin/bcp ibs011..srclist in /home/henry/milan/srclist.txt -S139.162.62.157,3306 -Uibs011 -PeczvFa -c
  5.  
  6. /opt/mssql-tools/bin/bcp "exec ibs011..mmx2csv" queryout /home/henry/milan/mmx2csv.sh -S139.162.62.157,3306 -Uibs011 -PeczvFa -c -a65353 -b20000
  7. rm /home/henry/milan/mx0.txt
  8. /bin/bash /home/henry/milan/mmx2csv.sh
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement