SQLCMD to export sql data

export to a csv

sqlcmd -S . -d DatabaseName -E -s',' -W -Q "SELECT * FROM TableName" > C:\Test.csv

A SQL server search plugin, from Redgate

It is free.


You can download it from this link http://www.red-gate.com/products/sql-development/sql-search/

After the installation, you can see the button in your Sql server management studio. “SQL Search”




Type the keywords and change the filters to find whatever objects contain your keywords. A great tool for a complex database which has more than 200 tables and stored procedures.