Back To Main Page

Free Downloads

Learn VB - Free Guide

Knowledgebase Articles

SQL Hints and Tips

BCP Out All Tables

BCP is a very good command line tool for quickly getting data in or out of a database or tables. The one line of script below uses an undocumented stored procedure to go through each table in the NorthWind database, BCPing the contents of each table out to a file (in the format tablename.out) on the G drive. You can of course change the database name as appropriate.

sp_msForEachTable 
@Command1="master..xp_cmdshell 'BCP NorthWind.? out G:\?.out -S MyServer -U sa -P -n'"