devxlogo

BCP Out All Tables with One Line of Script

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' "

devx-admin

Share the Post: