Error in SQL Azure Migration Wizard

Question

SQL Azure Migration Wizard crashed and shows below message

System.MissingMethodException: Method not found: 'Microsoft.SqlServer.Management.Common.DatabaseEngineType Microsoft.SqlServer.Management.Smo.Server.get_ServerType()'.
   at SQLAzureMW.ScriptWizard.FigureOutObjectTypesAvailable()
   at SQLAzureMW.ScriptWizard.DisplayNext()
   at SQLAzureMW.ScriptWizard.btnNext_Click(Object sender, EventArgs e)
   at SQLAzureMW.ScriptWizard.lbDatabases_DoubleClick(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnDoubleClick(EventArgs e)
   at System.Windows.Forms.ListBox.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
SQLAzureMW
    Assembly Version: 3.1.1.0
    Win32 Version: 3.1.1.0
    CodeBase: file:///D:/Softwares/Software%20Development/Components%20And%20Addins/SQl%20to%20Azure%20Migration/SQLAzureMW.exe
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Accessibility
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
System.Core
    Assembly Version: 3.5.0.0
    Win32 Version: 3.5.30729.4926 built by: NetFXw7
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
Microsoft.SqlServer.Smo
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.Smo/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Smo.dll
----------------------------------------
Microsoft.SqlServer.Management.Sdk.Sfc
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.Management.Sdk.Sfc/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Management.Sdk.Sfc.dll
----------------------------------------
Microsoft.SqlServer.ConnectionInfo
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.dll
----------------------------------------
87jfrtjh
    Assembly Version: 3.1.1.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Data
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
Microsoft.SqlServer.SqlClrProvider
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.SqlClrProvider/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.SqlClrProvider.dll
----------------------------------------
Microsoft.ExceptionMessageBox
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.ExceptionMessageBox/10.0.0.0__89845dcd8080cc91/Microsoft.ExceptionMessageBox.dll
----------------------------------------
Microsoft.SqlServer.SqlEnum
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.SqlEnum/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.SqlEnum.dll
----------------------------------------
System.Transactions
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
Microsoft.SqlServer.Dmf
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.Dmf/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Dmf.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

Answer 1

I'm having the very same problem and would also like to know how to solve this...

Answer 2

I'm having the exact same problem.  The first thing I did was go out to the migration wizard web site and rate it a one star.   No response...

Answer 3

Likewise, I am also getting the same problem.

I filed the issue:

http://sqlazuremw.codeplex.com/WorkItem/View.aspx?WorkItemId=4339

---

Thanks
Jeff in Seattle

Answer 4

http://sqlazuremw.codeplex.com/

Requirements
SQLAzureMW requires SQL Server 2008 R2 bits to run.

---

Thanks
Jeff in Seattle

Answer 5

Installing SQL Server 2008 R2 Management Objects did not help.

Still getting same:

System.MissingMethodException: Method not found: 'Microsoft.SqlServer.Management.Common.DatabaseEngineType Microsoft.SqlServer.Management.Smo.Server.get_ServerType()'.

---

Thanks
Jeff in Seattle

Answer 6

I suggest you disable all startup items and third party services when booting. This method will help us determine if this issue is caused by a loading program or service. Please perform the following steps:
 
1. Click the Start Button type "msconfig" (without quotation marks) in the Start Search box, and then press Enter.
 
Note: If prompted, please click Continue on the User Account Control (UAC) window.
 
2. Click the "Services" tab, check the "Hide All Microsoft Services" box and click "Disable All" (if it is not gray). 
3. Click the "Startup" tab, click "Disable All" and click "OK".
 
Then, restart the computer. When the "System Configuration Utility" window appears, please check the "Don't show this message or launch the System Configuration Utility when Windows starts" box and click OK.
 
Please test this issue in the Clean Boot environment, if the issue disappears in the Clean Boot environment, we can use a 50/50 approach to quickly narrow down which entry is causing the issue.

---

k.chandrasekhar gowda software engineer Export Solution Technology Pvt Ltd velachery,Chennai.