BCP OUT all table data in your Database

  • Comments posted to this topic are about the item BCP OUT all table data in your Database

  • Hi

    Thank you for this useful script.

    I am a Novice / intermediate.

    as per your instructions,

    I created the directories, renamed filespec and [dbname], the script executes successfully with no errors but when I look in the directories there is nothing there?

    what am I doing wrong?

    here's the sample output:

    Query executed successfully.

    bcp [xxxxx_SQL]..xxxxx out C:\BCP\day5\xxxxx -T -c

    bcp [xxxxx_SQL]..xxxxx out C:\BCP\day5\xxxxx -T -c

    bcp [xxxxx_SQL]..xxxxx out C:\BCP\day5\xxxxx -T -c

    bcp [xxxxx_SQL]..xxxxx out C:\BCP\day5\xxxxx -T -c

    bcp [xxxxx_SQL]..xxxxx out C:\BCP\day5\xxxxx -T -c

    bcp [xxxxx_SQL]..xxxxx out C:\BCP\day5\xxxxx -T -c

    bcp [xxxxx_SQL]..xxxxx out C:\BCP\day5\xxxxx -T -c

    bcp [xxxxx_SQL]..xxxxxout C:\BCP\day5\xxxxx -T -c

    .......

Viewing 2 posts - 1 through 1 (of 1 total)

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