SQL Azure Migration Wizard Connection Error RRS feed

  • Question

  • I am trying to run the SQL Azure Migration Wizard but I get a connection error.

    Has anyone else got / solved this?

    ========= Begin Error =========


    See the end of this message for details on invoking
    just-in-time (JIT) debugging instead of this dialog box.

    ************** Exception Text **************
    System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
    File name: 'Microsoft.SqlServer.ConnectionInfo, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
       at SQLAzureMW.ScriptWizard.btnConnectToServer_Click(Object sender, EventArgs e)
       at SQLAzureMW.ScriptWizard.DisplayNext()
       at SQLAzureMW.ScriptWizard.btnNext_Click(Object sender, EventArgs e)
       at System.Windows.Forms.Control.OnClick(EventArgs e)
       at System.Windows.Forms.Button.OnClick(EventArgs e)
       at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
       at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
       at System.Windows.Forms.Control.WndProc(Message& m)
       at System.Windows.Forms.ButtonBase.WndProc(Message& m)
       at System.Windows.Forms.Button.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)

    WRN: Assembly binding logging is turned OFF.
    To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
    Note: There is some performance penalty associated with assembly bind failure logging.
    To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].


    ************** Loaded Assemblies **************
        Assembly Version:
        Win32 Version: 2.0.50727.3625 (GDR.050727-3600)
        CodeBase: //WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
        Assembly Version:
        Win32 Version:
        CodeBase: //Documents%20and%20Settings/Administrator/My%20Documents/Downloads/SQL%20Azure%20Migration%20Wizard%2010-17-2012/SQLAzureMW.exe
        Assembly Version:
        Win32 Version: 2.0.50727.3623 (GDR.050727-3600)
        CodeBase: //WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/
        Assembly Version:
        Win32 Version: 2.0.50727.3624 (GDR.050727-3600)
        CodeBase: //WINDOWS/assembly/GAC_MSIL/System/
        Assembly Version:
        Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
        CodeBase: //WINDOWS/assembly/GAC_MSIL/System.Drawing/
        Assembly Version:
        Win32 Version:
        CodeBase: /Documents%20and%20Settings/Administrator/My%20Documents/Downloads/SQL%20Azure%20Migration%20Wizard%2010-17-2012/SQLAzureMWUtils.DLL
        Assembly Version:
        Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
        CodeBase: /WINDOWS/assembly/GAC_MSIL/System.Configuration/
        Assembly Version:
        Win32 Version: 2.0.50727.3082 (QFE.050727-3000)
        CodeBase: /WINDOWS/assembly/GAC_MSIL/System.Xml/

    ************** 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

    For example:

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

    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.

    ========== End Error =========


    Wednesday, October 17, 2012 4:37 PM


  • Hi JSON,

    This error seems related to the tool. When you start the Migration Wizard, the MW get something wrong inside.

    Please first try to remove the SQL Azure Migration Wizard and reinstall it. Follow this link: http://sqlazuremw.codeplex.com/

    One thing need to be noticed:

    SQLAzureMW v3x and tools requires SQL Server 2008 R2 SP1 bits to run.
    SQLAzureMW v4x and tools requires SQL Server 2012 bits to run.

    Please check the SQL Server version you used. SQL Database Migration Wizard does not catch all of the compatibility issues between different levels of SQL Server databases (i.e. level 80, 90, and 100). SQL Database is based on SQL Server 2012 (level 110).

    For further detection please visit this forum: http://sqlazuremw.codeplex.com/discussions, MW guys are almost in this discusstion site.

    Best Regards,
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    • Marked as answer by Iric Wen Thursday, October 25, 2012 9:00 AM
    Monday, October 22, 2012 6:54 AM