Export all Data and Headers from CIP MSSQL Database to CSV

export_data.sql

USE developmentdataSQL
SELECT 'exec master..xp_cmdshell'
+ ' '''
+ 'bcp'
+ ' "' + TABLE_CATALOG + '.' + TABLE_SCHEMA + '.[' + TABLE_NAME
+ ']" out'
+ ' "C:\cip\'
+ TABLE_CATALOG + '.' + TABLE_SCHEMA + '.' + TABLE_NAME + '.csv"'
+ ' -c'
+ ' -t,'
+ ' -T'
+ ' -S' + @@SERVERNAME
+ ''''
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'

export_headers_cip.sql

USE developmentdataSQL
SELECT 'exec master..xp_cmdshell'
+ ' '''
+ 'bcp'
+ ' "DECLARE @colnames VARCHAR(max); '
+ 'SELECT @colnames = COALESCE(@colnames + '''','''', '''''''') + column_name from ' 
+ TABLE_CATALOG+'.INFORMATION_SCHEMA.COLUMNS where '
+ 'TABLE_NAME='''''+ TABLE_NAME + ''''''
+ '; select @colnames;"'
+ ' queryout'
+ ' "C:\cip\'
+ TABLE_CATALOG + '.' + TABLE_SCHEMA + '.' + TABLE_NAME + '_header.csv"'
+ ' -c'
+ ' -t,'
+ ' -T'
+ ' -S' + @@SERVERNAME
+ ''''
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'