Dump SQL File Big File On SQL Server

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…