1
Vote

Login timeout for BCP

description

Hi, I tried migrate a db, and it worked fine until the BCP (version 10.50.2500.0) was going to upload the data. Then it stopped after a while saying "login timeout". The structure (tables and views seem to have been created completely, no error msgs + looks good in the mgmnt portal). I did use an existing azure db (empty), will try again now and let the Migration Wizard create the db.
Thanks

comments

prgjonas wrote Feb 3, 2013 at 6:35 AM

Ok, when I manually ran the BCP-command, adding the port to the server address it worked fine:

bcp.exe "db.dbo.SomeTable" in "c:\SQLAzureMW\BCPData\dbo.SomeTable.dat" -E -n -b 10000 -a 16384 -q -S <myserver>.database.windows.net,1433 -U "<my user>" -P "<my pwd>"

prgjonas wrote Feb 3, 2013 at 8:07 AM

... and just by adding ,1433 in the server name dialog in the wizard, it does its job just as expected. Obviously ...