Wednesday 12 May 2010

BCP Command for copying entire data from SQL SERVER Table

BCP OUT/IN -S -c -T


OUT/IN --- EXPORT/ IMPORT
-S -----SERVERNAME
-c-----Mode (Connector mode)
-T ----Trusted Connection


EXAMPLE :
bcp AdeventureWorks.dbo.SalesOrderDetails OUT SalesOrderDetails.txt -S LOCAL -c -T