SQLAzureMWBatchBackup - Operation not supported on version 11.0.9228 SqlAzureDatabase

Jan 14, 2015 at 11:08 PM
George
Many thanks for this tool. I used it with great success for over a year to copy my production database down from Azure to a local database for Q/A purposes.
I have a new PC and had to reinstall everything and now I cannot, for the life of me, get it to run on the new pc.

Any help would be greatly appreciated.

Thanks
Cliff McManus

Here is the error message
SQLAzureMWBatchBackup, Version 5.14.0.0
Process started at 1/14/2015 6:21:36 PM -- UTC -> 1/14/2015 11:21:36 PM ...
Operation not supported on version 11.0.9228 SqlAzureDatabase.

Here is my environment
Azure database current version is 11, I have tried version 12 also.
Target database will be SQLServer 2014 on my local server
Windows 7 Home Premium with latest windows updates
Adobe Flash Player 16 ActiveX
Adobe Reader X1 (11.010)
Attunity Oracle CDC Designer
Attunity Oracle CDC Service
Canon lJ Network Scan Utility
Canon M65200 series MP Drivers
Canon M65200 series User Registration
Canon U Network Tool
Dell Digital Delivery
Dell System Detect
Dell Touchpad
Elwcr RIA Sewices v1.0 SP2
Entity Framework 6.1.1 Tools for Visual Studio 2013
GIMP 23.14
IIS 8.0 Express
Intel® Graphics Driver
Intel® Management Engine Components
lntel® Control Center
lntel® PROSet/Vlfireless Software
MagicDisc 2.7.106
Microsoft .NET Framework 4.5 Multi-Targeting Pack
Microsoft .NET Framework 4.5 Multi-Targeting Pack
Microsoft .NET Framework 4.5 SDK
Microsoft .NET Framework 4.5 SDK
Microsoft .NET Framework 4.5.1 Mufti-Targeting Pack (ENU)
Microsoft .NET Framework 4.5.1 Multi-Targeting Pack
Microsoft .NET Framework 4.5.1 Multi-Targeting Pack
Microsoft .NET Framework 4.5.1 SDK
Microsoft .NET Framework 454
Microsoft ASP.NET MVC 4 Runtime
Microsoft Azure Authoring Tools - v2.5
Microsoft Azure Compute Emulator - v2.5
Microsoft Azure HDlnsight Tools for Visual Studio
Microsoft Azure Libraries for .NET - v2.5
Microsoft Azure Quickstarts
Microsoft Azure Storage Tools - v3.0.0
Microsoft Azure Tools for Microsoft Visual Studio 2013 - v2.5
Microsoft Help Viewer 2.1
Microsoft Help Viewer 1.1
Microsoft Hive ODBC Driver
Microsoft Hive ODBC Driver
Microsoft Mouse and Keyboard Center

Microsoft OData Source for Microsoft SQL Sewer 2014 (:64)
Microsoft Office Professional Plus 2010
Microsoft OLE DB Provider for 082 Version 5.0
Microsoft OneDrive
Microsoft QL Sewer 2012 Management Ob'iects
Microsoft Report Viewer 2014 Runtime
Microsoft Security Essentials
Microsoft Silverlight
Microsoft Silverlight 5 SDK
Microsoft SQL Server 2012 Command Line Utilities
Microsoft SQL Server 2014 (64-bit)
Microsoft SQL Server 2014 Express LocalDB
Microsoft SQL Server 2014 Management Objects
Microsoft SQL Server 2014 Management Objects (x64)
Microsoft SQL Server 2014 Policies
Microsoft SQL Server 2014 Transact-SQL Compiler Service
Microsoft SQL Server 2014 T-SQL Language Service
Microsoft SQL Server 2014 T-SQL Language Service
Microsoft SQL Server Compact 4.0 SP1 x64 ENU
Microsoft SQL Server Data Tools - enu (120410250)
Microsoft SQL Server Data Tools 2013
Microsoft SQL Server System CLR Types ()64)
Microsoft SQL Sewer 2008 SetuE SuEEort Files
Microsoft SQL Sewer 2012 Command Line Utilities
Microsoft SQL Sewer 2012 Data-Tier App Framework
Microsoft SQL Sewer 2012 Data-Tier App Framework (:64)
Microsoft SQL Sewer 2012 Management Objects
Microsoft SQL Sewer 2012 Management Objects (:64)
Microsoft SQL Sewer 2012 Management Objects 064)
Microsoft SQL Sewer 2012 T-SQL Language Sewice
Microsoft SQL Sewer 2014 Setup (English)
Microsoft SQL Sewer 2014 Transact-SQL ScriptDom
Microsoft SQL Sewer 2014 Upgrade Advisor
Microsoft SQL Sewer Data Tools Build Utilities - enu (12.0.3091...
Microsoft SQL Sewer Data Tools Build Utilities - enu (12.03091...
Microsoft SQL Sewer System CLR Types (x64)
Microsoft System CLR Types for SQL Server 2012
Microsoft System CLR Types for SQL Server 2014
Microsoft System CLR Types for SQL Server 2014
Microsoft Visual C¢+ 2010 166 Runtime - 10.0.40219
Microsoft Visual C+ + 2013 Redistributable 0:64) - 12.030501
Microsoft Visual C++ 2010 :66 Redistributable - 10.0.40219
Microsoft Visual C++ 2010 x54 Redistributable - 10.0.40219
Microsoft Visual Studio 2010 Tools for Office Runtime 0:64)
Microsoft Web Deploy 3.5
Microsoft Web Deploy 3.5
Microsoft Web Platform Installer 5.0
pdfFactory Pro
prerequisites for 5501
Prerequisites for SSDT
prerequisites for SSDT
SQLServer 2014 Management Objects
Telerik Control Panel
Telerik Reporting Q2 2014 SP1
Telerik UI for Silverlight Q2 2014 SP1
wcr RIA Sewices v1.0 592
Windows Azure Storage Emulator - v3.4
Coordinator
Jan 15, 2015 at 2:29 AM
Hi Cliff,

Do me a favor and pull down v5.14.1 and run. It probably won't make a difference but just to double check. Really, all you need is SQL Server 2014 client (i.e SSMS and any client side components, which it looks like you have. Just run SQL Server 2014 setup and verify that you have everything). You should be good to go.

If that still does not work, contact me offline and I can make a couple of special builds for you that might help us figure out where it is crashing on you.

Thanks,
George
Jan 20, 2015 at 9:03 PM
Many thanks for the quick response.
I tried V5.14.1 using the same config file as 5.14 and same message.
Next I tried to do a full install of SQLServer 2014 on my machine.
Still same problem.

You know this is going to turn out to be an easy fix once we figure out what is wrong. :-)
Cliff
Coordinator
Jan 27, 2015 at 4:41 PM
Out of curiosity, have you tried SQLAzureMW v5.15 and see if the GUI version worked? Maybe we will get an better error that will help us figure out what is going on.

Sorry this is taking so long.

Regards,
George