BCP Error

Jan 23, 2011 at 3:15 AM

Hi, I'm using SQLAzureMW to migrate a database but when it gets to the moving data section I get the errors:

Process started at 23/01/2011 11:24:38 AM -- UTC -> 23/01/2011 1:24:38 AM ...

Using BCP to get data from table dbo.umbracoNode


SQLAzureMW could not find the number of rows copied in the BCP output. Here is the BCP output:

bcp.exe: unknown option d

usage: bcp.exe {dbtable | query} {in | out | queryout | format} datafile

[-m maxerrors] [-f formatfile] [-e errfile]

[-F firstrow] [-L lastrow] [-b batchsize]

[-n native type] [-c character type] [-w wide character type]

[-N keep non-text native] [-V file format version] [-q quoted identifier]

[-C code page specifier] [-t field terminator] [-r row terminator]

[-i inputfile] [-o outfile] [-a packetsize]

[-S server name] [-U username] [-P password]

[-T trusted connection] [-v version] [-R regional enable]

[-k keep null values] [-E keep identity values]

[-h "load hints"] [-x generate xml format file]

Here is the Regex string being looked for: [0-9]+\srows copied

Thisis the same for all tables...any ideas as to what I am doing wrong??


Jan 23, 2011 at 11:46 PM

Fixed this problem...after doing some research I found that the Version 9 BCP.EXE was being referenced...changed the PATH variable to point everything to version 100 and it works OK


Now, have another problem..see the connection error problem.