1.Install sqlline and jtds (using apt-get )
apt-get install libjtds-java sqlline
2.ms sql jdbc connection string syntax
jdbc:jtds:sqlserver://ip/
3.drive class syntax
net.sourceforge.jtds.jdbc.Driver
4.command line example :
sqlline -u 'jdbc:jtds:sqlserver://ip/' -n user -p pwd -d net.sourceforge.jtds.jdbc.Driver
5.using pipe redirect
sqlline -u 'jdbc:jtds:sqlserver://ip/' -n user -p pwd -d net.sourceforge.jtds.jdbc.Driver < script.sql
沒有留言:
張貼留言