Extracting data from sql server

Question

Viewing 5 posts - 1 through 4 (of 4 total)

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

moderis Old Hand Points: 320 More actions · Answer 1

I ques You should provide more details on what exactly You want to do.

And what tools/software You're ready/wish to use.

there are lots of solutions, each is different in time and dificulty

Wilfred van Dijk SSCrazy Eights Points: 9003 More actions · Answer 2

I don't have a clear answer to your question ("It depends" :D:D ), but you can use tools like

- BCP (Bulk copy program)

- SSIS package

- T-SQL statements

- Buy a third-party tool

Wilfred
The best things in life are the simple things

CrazyMan SSChampion Points: 12560 More actions · Answer 3

Use SQL ( ha ha ha), can you be a bit more specific of ur requirements 🙂

bhakti.khode Grasshopper Points: 12 More actions · Answer 4

there is an option in sql to extract the data scripta from specified table (Generate script) .

similarly I want to extract table data to an file say "c:\abc.sql" programmatically

for that i am trying to use SQLDMO.dll i don't know how to use this.if any body know please help.