How to load 2 lakths data from sql server to CSV file

Question

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

DTS is old and deprecated. Use SSIS instead.

If this is a "one shot" operation, you can use the Import/export wizard or BCP.

Hope this helps

Gianluca

-- Gianluca Sartori

solomon.jernas Hall of Fame Points: 3680 More actions · Answer 2

need to export 2 lakths data ? which one is fast and best

spaghettidba SSC Guru Points: 105732 More actions · Answer 3

It's not a lot of data IMHO (I could be wrong, I guess lakths means 100.000).

SSIS would be the faster, BCP would work just as well.

-- Gianluca Sartori

ps. One Orange Chip Points: 29422 More actions · Answer 4

keep ur db in bulk logged recovery and then use bcp. this will be faster.

Pradeep Singh

spaghettidba SSC Guru Points: 105732 More actions · Answer 5

ps. (12/1/2011)
keep ur db in bulk logged recovery and then use bcp. this will be faster.

While exporting? Are you sure?

-- Gianluca Sartori

ps. One Orange Chip Points: 29422 More actions · Answer 6

:sick: didnt read the question fully. Thought OP was importing...

Pradeep Singh

Pradyothana Shastry SSCertifiable Points: 5211 More actions · Answer 7

Either SSIS or BCP will be the best depending on the frequency of exporting.

- Pradyothana http://www.msqlserver.com

SkyBVI SSCoach Points: 15128 More actions · Answer 8

If its a 1time thing I would use BCP,

Otherwise SSIS...

@gianluca Yes, 1 lakh means 100000

Regards,

Sushant

Regards
Sushant Kumar
MCTS,MCP