Hi,

When I use SqlAzureMW to migrate a large data to SQL Azure, I got the following error message:

Sorry, but BCP upload process failed:

Starting copy...
SQLState = 08S01, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Communication link failure
SQLState = S1000, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Text column data incomplete
SQLState = 08S01, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Communication link failure
SQLState = 08S01, NativeError = 10054
Error = [Microsoft][SQL Server Native Client 10.0]TCP Provider: An existing connection was forcibly closed by the remote host.
SQLState = 08S01, NativeError = 10054
Error = [Microsoft][SQL Server Native Client 10.0]Communication link failure
SQLState = 08S01, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Communication link failure
SQLState = 08S01, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Communication link failure
SQLState = 08S01, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Communication link failure
SQLState = 08S01, NativeError = 0

The large data are files stored in a table. And its size is about 2.5GB.

Any helps?

Thanks a lot.

Hi,

A couple of questions for you.

1) In the SQLAzureMW.exe.config file, look for the BCP options and see if you have the -n switch. I.E.

<add key="BCPArgsIn" value="{0} in {1} -E -n -b 10000 -a 16384"/>  <!-- BCP in command parameters -->
<add key="BCPArgsOut" value="&quot;{0}&quot; out {1} -E -n"/>      <!-- BCP out command parameters -->

2) You might make the chunk size smaller. Check for ChunkSize which I have defaulted to 500,000:

<add key="ChunkSize" value="500000"/>                              <!-- Number of records to process per BCP iteration (Uploading to Azure) -->

3) Do you have a image or text column in your table? It looks like you had 0 records copied, if you want, contact me offline and share your table schema with me so I can try to recreate the issue.

Thanks for your time,
George

Really thanks ghuey.

You fixed my problem.