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