BCP Out All Tables with One Line of Script

BCP is a command line tool that allows you to obtain data quickly, whether that data is in or out of a database or tables. The script below uses an undocumented stored procedure to go through each table in the NorthWind database, BCP-ing the contents of each table out to a file (in the format tablename.txt) on the C drive. You can change the database name as appropriate.

 sp_msForEachTable    @Command1="master..xp_cmdshell  'BCP NorthWind.? out C:?.txt -SNorthwind -U sa -P -n' "
Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: