Initial release mirroring most of the essential features of SQLCMD. There are some items missing, such as support for SQLCMD commands (e.g. :r to include another script, :setvar, etc) and support for variable substitution (i.e. $(var_name)).
There are also some features not found in SQLCMD:
- connecting through SQL Native Client (.NET) instead of ODBC
- support for setting "application name" of connection
- sending
PRINTandRAISERROR('...', 10, 1)messages to a separate file. - ability to store the total "row(s) affected" into a separate file or even a user-level environment variable
- ability to append output to a file (SQLCMD only over-writes)
- support for specifying
AttachDBFilename - support for
ReadWriteApplication Intent - logging all debug/diagnostic info to a file (useful for seeing where a problem happened, or how a script was parsed)
Please see the Wiki for additional details.