1

Closed

MissingMethodException after database selection

description

After having connected to the local SQL Server 2008 and selected a database, the following error shows up upon pressing the "next" button:
 
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 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)
 
Configurations tested:
SQL Server 2008 Enterprise
Windows Vista Professional SP1
SQL Azure Migration Wizard v.3.1.1
 
SQL Server 2008 Enterprise
Windows 7 Ultimate
SQL Azure Migration Wizard v.3.1.1
Closed Jan 16, 2010 at 10:45 PM by ghuey

comments

sebschmitt wrote Jan 10, 2010 at 9:05 AM

Building the current source fails with 6 build errors:
Error 1 The name 'DatabaseEngineType' does not exist in the current context C:\Temp\SQLAzureMW\ScriptDatabase.cs 442 51 SQLAzureMW
Error 2 The name 'DatabaseEngineType' does not exist in the current context C:\Temp\SQLAzureMW\ScriptWizard.cs 557 45 SQLAzureMW
Error 3 The name 'DatabaseEngineType' does not exist in the current context C:\Temp\SQLAzureMW\ScriptDatabase.cs 587 51 SQLAzureMW
Error 4 The name 'DatabaseEngineType' does not exist in the current context C:\Temp\SQLAzureMW\ScriptWizard.cs 612 45 SQLAzureMW
Error 5 The name 'DatabaseEngineType' does not exist in the current context C:\Temp\SQLAzureMW\CreateDatabase.cs 25 45 SQLAzureMW
Error 6 The name 'DatabaseEngineType' does not exist in the current context C:\Temp\SQLAzureMW\CreateDatabase.cs 59 49 SQLAzureMW

ghuey wrote Jan 15, 2010 at 8:22 PM

Hi,

SQL Server 2008 R2 (CTP currently) is required for SQLAzureMW v3.x. If you want, pull SQLAzureMW v2.1 which is build on SQL Server 2008.

Regards,
George

sebschmitt wrote Jan 16, 2010 at 6:43 AM

After upgrading to SQL Server 2008 R2 it works. Thank you.