SQL Azure support broke today?

• 
  I use redgate's sqlazurebackup tool, and I'm facing the same error since today .I've also tried with the new version of the tool, same pb, don't now how to fix it

  tahir August 07, 2011 16:36

  - 0 +
• 
  I'm finding the same issue. It's all been working fine with SQLCompare 9 for months, and last week stopped.
  
  I wonder if a change has happened at the SQL Azure end. Very frustrating.
  
  I'm following the same pattern as Ian below, with a local db comparison with SQLAzure.
  
  Again, any help much appreciated.

  padda August 08, 2011 04:52

  - 0 +
• 
  Are you guys by any chance on the Western Europe SQL servers? We having the same issue, but it seems the Azure Database Manager is down. In fact its been down all weekend...
  
  Not sure if this is what is causing the issue?
  
  http://www.microsoft.com/windowsazure/s ... board.aspx

  BrettC August 08, 2011 07:29

  - 0 +
• 
  yes western europe for me, may be related to the issue

  tahir August 08, 2011 07:33

  - 0 +
• 
  Yup,
  
  on Western Europe SQL Servers. Although I don't see why that would affect SQL compare. I would expect an error that tells me can't find db, or can't connect or something else. Not a can't find stored proc.

  padda August 08, 2011 07:33

  - 0 +
• 
  Red Gate is currently working on a fix for this - Microsoft have sprung a big surprise on us this weekend and we have to update all of the SQL programs that support Azure because the way we detect Azure doesn't work any more.
  
  Given what I currently know about Azure, if the European installations have all been updated, the changes will probably get pushed to North America in the very near future.
  
  We should have new builds later today and will post the link on this forum.
  
  Thanks for your patience!

  Brian Donahue August 08, 2011 08:13

  - 0 +
• 

  tahir wrote:

  I use redgate's sqlazurebackup tool, and I'm facing the same error since today .I've also tried with the new version of the tool, same pb, don't now how to fix it

  
  I've just released a patch for SQL Azure Backup. You can either use the UI to download the 1.0.5 update or simply download the tool again from the website.
  
  Hope this helps.
  
  (Please direct future support for SQL Azure Backup to http://sqlazurebackup.uservoice.com)

  richardjm August 08, 2011 10:18

  - 0 +
• 
  Hi,
  
  Is the hotfix for SQL Compare 9 in the pipeline for this afternoon too? I'm not using SQLAzureBackup. Just SQLCompare and SQLDataCompare.
  
  Thanks

  padda August 08, 2011 10:20

  - 0 +
• 

  padda wrote:

  Hi,
  
  Is the hotfix for SQL Compare 9 in the pipeline for this afternoon too? I'm not using SQLAzureBackup. Just SQLCompare and SQLDataCompare.
  
  Thanks

  
  Hi there - I'm afraid the SQL Compare 9 fix won't be out today. Apologies for this, but we're working as quickly as we can to get this out for tomorrow.
  
  We'll keep you updated and get this out to you as soon as we can.
  
  Regards
  
  Ben Rees

  benrees August 08, 2011 12:05

  - 0 +
• 
  Hi any news on the fix for SQL compare?
  
  Will you have a fix for today?

  IanBlackburn August 09, 2011 11:14

  - 0 +
• 
  There is something available to fix the Azure issue for SQL Compare:
  ftp://support.red-gate.com/patches/SQL_ ... .0.475.zip
  
  Of course, the usual, untested software disclaimers apply. It's been minimally tested but if you run into any issues please let me know.

  Brian Donahue August 09, 2011 12:38

  - 0 +
• 
  Thanks. This version is working great.

  BrettC August 10, 2011 04:10

  - 0 +
• 
  Hi,
  
  I'm finding that the SQLCompare patch is working nicely. The SQLDataCompare v9, however, is having the same problem, i.e.

  Could notfind stored procedure 'sp_dbcmptlevel'
  

  padda August 11, 2011 10:56

  - 0 +
• 
  There are some technical issues in patching the SQL Data Compare binaries at the moment so it could be some time before Data Compare will be compatible to whatever changes were done to Azure.

  Brian Donahue August 11, 2011 12:43

  - 0 +
• 
  Any word on when this fix will be ready?

  Marcos September 02, 2011 00:43

  - 0 +
• 
  There is already a patch available as referenced earlier in this thread. Is this not working for you?

  David Atkinson September 02, 2011 04:13

  - 0 +
• 
  Sorry - I was reffering to SQL Data Compare - that's not patched is it?

  Marcos September 02, 2011 04:33

  - 0 +
• 
  Yes, there's a fix, although it appears that the forum is devoid of any link to the patch, which isn't great. I'll see if I can find the link. Bear with me!
  
  David Atkinson
  Red Gate Software

  David Atkinson September 02, 2011 04:48

  - 0 +
• 
  SQL Data Compare for Azure patch: ftp://support.red-gate.com/patches/SQL_ ... 173469.exe
  
  This should sort the problem.

  Brian Donahue September 02, 2011 05:29

  - 0 +
• 
  Hi,
  
  I have SQL Toolbelt installed on Windows 7 desktop. I have the everything installed except the components naturally belonging on a server (e.g. backup etc.)
  
  I've updated SQL Compare using the patches suggested (9.1)
  
  I get an error when I attempt to do a comparison between a local SQL database and an Azure database about BackupReader.dll (I have sent through an error report).
  
  The 9.5 patch makes things go horribly wrong for me!
  
  Help and suggestions are most welcome
  
  Thanks

  craig.cant September 06, 2011 09:16

  - 0 +
• 
  I see the error report but I have no idea. It doesn't include the binding information so I don't know why it failed. I can compare live to backup using the patch version, so I think this problem is specific to you. I'll log a support call and someone will get in touch with you via email.

  Brian Donahue September 06, 2011 09:42

  - 0 +
• 
  Craig,
  I just tried mailing you directly to check over a couple of things regarding this problem but the mail bounced. Can you email support@red-gate.com with F0051889 in the subject line and we'll follow up?

  James B September 06, 2011 10:10

  - 0 +
• 
  Hi guys,
  
  Unfortunately SQL Compare patch did not work for us. We still are getting the same error as before (procedure not found). SQL Data compare worked fine (thanks). When trying to redo the patch, it says that upgrade already done and the checkbox is disabled to continue.
  
  Any ideas please?

  mpulis September 13, 2011 04:52

  - 0 +
• 
  Hi all,
  I have a copy of SQL Compare 8.5 and was evaluating version 9 to see if I could make it work with our SQL Azure dabases and have run into a new problem!
  
  I have applied the hotfix mentioned in this thread which resaolved the problem with the missing stored procedure. I now get a new error when registering the data sources. At the Reading users stage I get the error 'There is already and open DataReader associated with this Command which must be closed first.'
  
  This may be a configuration issue but I cannot find anywhere that I might be able to add MultipleActiveResultSets=True to a connection string in SQL Compare itself.
  
  Any help would be very much appreciated as I would very much like to evaluate this produce sucessfully.
  
  Thanks.
  
  Tim

  timZZ September 13, 2011 06:32

  - 0 +
• 
  Hi Tim, you can if you want, although I don't know whether or not it will help. You can fudge parameters into the connection string by putting them in the server box, for instance servername;MultipleActiveResultSets=True.

  Brian Donahue September 13, 2011 06:43

  - 0 +
• 
  Hi Brian,
  That worked, so thanks very much!

  timZZ September 13, 2011 06:46

  - 0 +

Add comment

Please sign in to leave a comment.