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

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist