4
Vote

Error connecting to a valid SQL Azure server

description

I am finding that the database collection contains no elements after logging into the "Target" SQL Azure step. The Migration Tool worked fine for me a few days ago and I verified my SQL Azure account is working fine as well at the master and other databases are working, online and I can connect to them.
 
It is failing on this second line with an index out of bound exception and no Database object is fetched.
 
                Server svr = CommonFunc.GetSmoServer(dbServer.ConnectionContext);
                Database db = (Database)svr.Databases[database];
 
ScriptWizard.cs - line 1171 - v3.7.7
 
It looks like an lightly documented release of SQL Azure that is the breaking change: http://bobthegoblin.wordpress.com/2011/09/11/sql-azure-migration-wizard-v3-7-7-red-gate-sql-compare-9-no-longer-work/

comments

LoryxSystems wrote Sep 13, 2011 at 5:07 PM

I just started getting this error as well starting yesterday. It is failing on connection to the SQL Azure database server. Version 3.7.7 and tried with 3.7.4

stevendelapena wrote Sep 14, 2011 at 3:27 PM

I believe this is related to recent changes to support bacpac import/export. It's a new CTP feature they pushed on the 9th. The Wizard worked for me after having installed the components to support bacpac listed at:

http://www.sqlazurelabs.com/ImportExport.aspx

stevendelapena wrote Sep 14, 2011 at 3:35 PM

Update: I think you may just need to apply the SP1 update and then the Cummulative Update Package 7:
http://social.msdn.microsoft.com/Forums/en-CA/ssdsgetstarted/thread/3dd65548-cf58-41e8-804d-3f6873132a7b

ghuey wrote Sep 20, 2011 at 1:29 PM

Yes, a whole bunch of us ran into this little problem. Basically, you need to download and install SP1 and you should be good to go.