data export

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » data export

data export

Rate Topic

Display Mode

Topic Options

Author

Message

rightontarget

Posted Friday, November 09, 2012 1:04 PM

Valued Member

Group: General Forum Members
Last Login: 2 days ago @ 5:34 PM
Points: 69, Visits: 212

Hi all,
What is the best (fastest) way to export data into a flat file if one of the columns is varbinary(max)?
I am trying the following:

DECLARE @table VARCHAR(128),
@file VARCHAR(255),
@cmd VARCHAR(512)

SET @file = 'C:\temp\' + @db_in + '.' + @schema_in + '.' + @table_in + '.dat'
SET @cmd = 'bcp ' + @db_in + '.' + @schema_in + '.' + @table_in + ' out ' + @file + ' -n -T '
EXEC master..xp_cmdshell @cmd
END

but it is taking some time and I am suspecting BLOB column being the offender.
Is there another way?

Thanks,

Post #1383213

Stewart "Arturius" Campbell

Posted Tuesday, November 13, 2012 7:38 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 1:49 AM
Points: 3,123, Visits: 4,310

First of all, is it really neccessary to export the BLOB column to a flat file? this will be huge.
an alternative is to use SSIS...

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Post #1384098

« Prev Topic | Next Topic »

Permissions