Export data in txt file by using SQLCMD
Syntax#
- sqlcmd -S SHERAZM-E7450\SQL2008R2 -d Baseline_DB_Aug_2016 -o c:\employee.txt -Q “select * from employee”
By using SQLCMD on Command Prompt
Command Structure is
sqlcmd -S yourservername\instancename -d database_name -o outputfilename_withpath -Q “your select query”
Switches are as follows
-S for servername and instance name
-d for source database
-o for target outputfile (it will create output file)
-Q for query to fetch data