SQLCMD to export sql data

export to a csv

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

Advertisements

A SQL server search plugin, from Redgate

It is free.

image

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”

image

 

image

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.