An issue when migrate large data

Feb 27, 2013 at 12:05 AM
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.
Coordinator
Feb 27, 2013 at 3:39 AM
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
Feb 27, 2013 at 12:47 PM
Really thanks ghuey.

You fixed my problem.