As an Oracle DBA, I feel no good command line tools when facing SQL Server or Sybase database, not comfirtable with osql or sqlcmd because too much differences with SQL*Plus. AnySQL is Java & JDBC based, it can support SQL Server easily with little changes. I am starting to build a SQL Server/Sybase tools for Oracle users now.
Starting AnySQL for Micrsoft SQL Server and Sybase version.
C:\AnySQL>asql --mssql
AnySQL for SQL Server/Sybase, version 2.0.0
(@) Copyright Lou Fangxin, all rights reserved.
ASQL>
Let's run the SQL terminated by semicolon, most Oracle users like this.
ASQL> select * from t_test;
col1
----
10
1 rows returned.
Let's run the SQL with slash at new line.
ASQL> select * from t_test
2 /
col1
----
10
1 rows returned.
Let's run the SQL with "go" at new line, this is the default behavior of osql or sqlcmd utilities.
ASQL> select * from t_test
2 go
col1
----
10
1 rows returned.
Now you can use it to chat with SQL Server or Sybase database, I choose jTDS as the JDBC driver.