• Can't say as I am terribly impressed, looks like they might have forgotten to surround SQL column names with []'s. For theirs and others information, here is the error I got when trying to compare two databases in SQL2000; I had all the features checked to compare and it looks like it died on constraints:

    ************** Exception Text **************

    System.Runtime.InteropServices.COMException (0x80045510): [SQL-DMO]The name '0 master ( Standard Countries )' was not found in the Tables collection. If the name is a qualified name, use [] to separate various parts of the name, and try again.

    at SQLDMO.Tables.Item(Object Index, Object Owner)

    at DBCompare.Module1.CompareConst()

    at DBCompare.Form1.Command1_Click(Object eventSender, EventArgs eventArgs)

    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)