CODEWITHSUNDEEP
sql-serverazure-sql-databasedatabase-migrationbcp
Colin
Colin

Reputation: 22595

How to prevent local connection timeout when using SQL Azure Migration Wizard

I am trying to export data from my sql server database using the Sql Azure Migration Wizard. I am intermittently hitting a problem with timeouts:

Unable to complete login process due to delay in opening server connection

Is it possible to increase the timeout used by the migration wizard? Or can I change the default timeout in sql server?

NB I am getting this problem on my own server, not when I try to connect to Azure.

Edit At the bottom of the Result Summary tab the wizard prints a summary of the bcp output commands used to export data. I copied these into a command window and they ran. Still getting timeouts reported. So it appears to be a limitation to do with bcp. I am using Sql Server 2008 R2 and bcp version 10.50.1600.1

Upvotes: 0

Views: 1489

Answers (1)

Ola Ekdahl
Ola Ekdahl

Reputation: 1514

A few things that I would try.

Use the IP and port number instead of the hostname to connect. 10.10.0.1,1433 for example.

Use the -l switch to increase the login timeout. More info about bcp switches here, http://technet.microsoft.com/en-us/library/hh568446%28v=sql.110%29.aspx

Upvotes: 2

Related Questions