Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

BCP OUT all table data in your Database Expand / Collapse
Author
Message
Posted Monday, September 24, 2007 2:31 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 14, 2014 2:24 PM
Points: 362, Visits: 447
Comments posted to this topic are about the item BCP OUT all table data in your Database
Post #401907
Posted Thursday, July 19, 2012 9:15 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 9:19 AM
Points: 16, Visits: 95
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 »

Add to briefcase

Permissions Expand / Collapse