locked
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=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
    File name: 'Microsoft.SqlServer.ConnectionInfo, Version=10.0.0.0, 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 **************
    mscorlib
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.3625 (GDR.050727-3600)
        CodeBase: //WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
    ----------------------------------------
    SQLAzureMW
        Assembly Version: 3.9.6.0
        Win32 Version: 3.9.6.0
        CodeBase: //Documents%20and%20Settings/Administrator/My%20Documents/Downloads/SQL%20Azure%20Migration%20Wizard%2010-17-2012/SQLAzureMW.exe
    ----------------------------------------
    System.Windows.Forms
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.3623 (GDR.050727-3600)
        CodeBase: //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.3624 (GDR.050727-3600)
        CodeBase: //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.3053 (netfxsp.050727-3000)
        CodeBase: //WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
    ----------------------------------------
    SQLAzureMWUtils
        Assembly Version: 3.9.6.0
        Win32 Version: 3.9.6.0
        CodeBase: /Documents%20and%20Settings/Administrator/My%20Documents/Downloads/SQL%20Azure%20Migration%20Wizard%2010-17-2012/SQLAzureMWUtils.DLL
    ----------------------------------------
    System.Configuration
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
        CodeBase: /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.3082 (QFE.050727-3000)
        CodeBase: /WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.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.

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

     

    Wednesday, October 17, 2012 4:37 PM

Answers

  • 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,
    Iric
    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