Syntax
sqlcmd -S SERVERNAME -d MYDATABASE -U USERNAME -P PASSWORD -i C:\path\mysqlfile.sql -o C:\path\results.txt
mysqlfile.sql
dumpresults.txt
Example
sqlcmd -S localhost -d ICTDB -U sa -P P@ssw0rd -i F:\MA\MA_EDIT.sql -o F:\MA\results.txt
Result
Changed database context to ‘ICTDB’.
(1 rows affected)Processed 100 total records
(1 rows affected)Processed 200 total records
(1 rows affected)
(1 rows affected)Processed 100 total records…