gistfile1.txt

bcp "SELECT * FROM BargainBee_Production.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'AdminUser'                   " queryout "c:\temp\DB\Header-AdminUser.txt"                   -t@**@ -c -T;
bcp "SELECT * FROM BargainBee_Production.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'BillingInfo'                 " queryout "c:\temp\DB\Header-BillingInfo.txt"                 -t@**@ -c -T;
bcp "SELECT * FROM BargainBee_Production.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'City'                        " queryout "c:\temp\DB\Header-City.txt"                        -t@**@ -c -T;
bcp "SELECT * FROM BargainBee_Production.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Deal'                        " queryout "c:\temp\DB\Header-Deal.txt"                        -t@**@ -c -T;
bcp "SELECT * FROM BargainBee_Production.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DealLocations'               " queryout "c:\temp\DB\Header-DealLocations.txt"               -t@**@ -c -T;
bcp "SELECT * FROM BargainBee_Production.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DealOptions'                 " queryout "c:\temp\DB\Header-DealOptions.txt"                 -t@**@ -c -T;
bcp "SELECT * FROM BargainBee_Production.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'GiftVoucher'                 " queryout "c:\temp\DB\Header-GiftVoucher.txt"                 -t@**@ -c -T;
bcp "SELECT * FROM BargainBee_Production.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Merchant'                    " queryout "c:\temp\DB\Header-Merchant.txt"                    -t@**@ -c -T;
bcp "SELECT * FROM BargainBee_Production.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'MerchantLocations'           " queryout "c:\temp\DB\Header-MerchantLocations.txt"           -t@**@ -c -T;
bcp "SELECT * FROM BargainBee_Production.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'MessageBoard'                " queryout "c:\temp\DB\Header-MessageBoard.txt"                -t@**@ -c -T;
bcp "SELECT * FROM BargainBee_Production.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Order'                       " queryout "c:\temp\DB\Header-Order.txt"                       -t@**@ -c -T;
bcp "SELECT * FROM BargainBee_Production.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ProductClassification'       " queryout "c:\temp\DB\Header-ProductClassification.txt"       -t@**@ -c -T;
bcp "SELECT * FROM BargainBee_Production.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Region'                      " queryout "c:\temp\DB\Header-Region.txt"                      -t@**@ -c -T;
bcp "SELECT * FROM BargainBee_Production.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ShippingInfo'                " queryout "c:\temp\DB\Header-ShippingInfo.txt"                -t@**@ -c -T;
bcp "SELECT * FROM BargainBee_Production.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Used_vouchers'               " queryout "c:\temp\DB\Header-Used_vouchers.txt"               -t@**@ -c -T;
bcp "SELECT * FROM BargainBee_Production.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'User'                        " queryout "c:\temp\DB\Header-User.txt"                        -t@**@ -c -T;
bcp "SELECT * FROM BargainBee_Production.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'UserRegions'                 " queryout "c:\temp\DB\Header-UserRegions.txt"                 -t@**@ -c -T;
bcp "SELECT * FROM BargainBee_Production.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Voucher'                     " queryout "c:\temp\DB\Header-Voucher.txt"                     -t@**@ -c -T;

bcp BargainBee_Production.[dbo].[AdminUser]                   out "c:\temp\DB\AdminUser.txt"                   -t@**@ -r*@@* -c -T
bcp BargainBee_Production.[dbo].[BillingInfo]                 out "c:\temp\DB\BillingInfo.txt"                 -t@**@ -r*@@* -c -T
bcp BargainBee_Production.[dbo].[City]                        out "c:\temp\DB\City.txt"                        -t@**@ -r*@@* -c -T
bcp BargainBee_Production.[dbo].[Deal]                        out "c:\temp\DB\Deal.txt"                        -t@**@ -r*@@* -c -T
bcp BargainBee_Production.[dbo].[DealLocations]               out "c:\temp\DB\DealLocations.txt"               -t@**@ -r*@@* -c -T
bcp BargainBee_Production.[dbo].[DealOptions]                 out "c:\temp\DB\DealOptions.txt"                 -t@**@ -r*@@* -c -T
bcp BargainBee_Production.[dbo].[GiftVoucher]                 out "c:\temp\DB\GiftVoucher.txt"                 -t@**@ -r*@@* -c -T
bcp BargainBee_Production.[dbo].[Merchant]                    out "c:\temp\DB\Merchant.txt"                    -t@**@ -r*@@* -c -T
bcp BargainBee_Production.[dbo].[MerchantLocations]           out "c:\temp\DB\MerchantLocations.txt"           -t@**@ -r*@@* -c -T
bcp BargainBee_Production.[dbo].[MessageBoard]                out "c:\temp\DB\MessageBoard.txt"                -t@**@ -r*@@* -c -T
bcp BargainBee_Production.[dbo].[Order]                       out "c:\temp\DB\Order.txt"                       -t@**@ -r*@@* -c -T
bcp BargainBee_Production.[dbo].[ProductClassification]       out "c:\temp\DB\ProductClassification.txt"       -t@**@ -r*@@* -c -T
bcp BargainBee_Production.[dbo].[Region]                      out "c:\temp\DB\Region.txt"                      -t@**@ -r*@@* -c -T
bcp BargainBee_Production.[dbo].[ShippingInfo]                out "c:\temp\DB\ShippingInfo.txt"                -t@**@ -r*@@* -c -T
bcp BargainBee_Production.[dbo].[Used_vouchers]               out "c:\temp\DB\Used_vouchers.txt"               -t@**@ -r*@@* -c -T
bcp BargainBee_Production.[dbo].[User]                        out "c:\temp\DB\User.txt"                        -t@**@ -r*@@* -c -T
bcp BargainBee_Production.[dbo].[UserRegions]                 out "c:\temp\DB\UserRegions.txt"                 -t@**@ -r*@@* -c -T
bcp BargainBee_Production.[dbo].[Voucher]                     out "c:\temp\DB\Voucher.txt"                     -t@**@ -r*@@* -c -T