BCP OUT all table data in your Database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Marti Ryan » BCP OUT all table data in your Database

BCP OUT all table data in your Database

Rate Topic

Display Mode

Topic Options

Author

Message

Marti Ryan

Posted Monday, September 24, 2007 2:31 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:45 PM
Points: 362, Visits: 429

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

Post #401907

mmusi4

Posted Thursday, July 19, 2012 9:15 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:56 AM
Points: 13, Visits: 72

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
.......

Post #1332278

« Prev Topic | Next Topic »

Permissions