Create a list of commands to dump all tables to csv

DumpTablesToCsv.sql

select 'exec master..xp_cmdshell' 
            + ' '''
            + 'bcp'
            + ' "' + TABLE_CATALOG + '.' + TABLE_SCHEMA + '.[' + TABLE_NAME + ']"' 
            + ' out'
            + ' "C:\temp\'
            + TABLE_CATALOG + '.' + TABLE_SCHEMA + '.' + TABLE_NAME + '.csv"' 
            + ' -c -t,'
            + ' -T'
            + ' -S' + @@servername
            + ''''
from INFORMATION_SCHEMA.TABLES
where TABLE_TYPE = 'BASE TABLE'