Using BCP to export imprt data. Scripts Set NoCount ON select 'bcp [' +schema_name(SCHEMA_ID) + '].[' + name + '] out d:\scripts\bcp\' + name + '.txt -n -d stackoverflow2013 -S .\SQLEC -T' from sys.tables where is_ms_shipped=0 ------------------- osql -S .\SQLEC -E -d stackoverflow2013 -i"D:\scripts\bcp\bcpcreate.sql" -o "D:\scripts\bcp\bcpRun.bat" -n -h-1 -w120
Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.
