How can we help you today? How can we help you today?
lambenjamin
Activity overview Badges (0) Posts (1) Comments (5)

Activity overview

Latest activity by lambenjamin

I was able to get the error a second time, but I can not duplicate it on demand. Thanks, Ben / comments
  1. Community
  2. SQL Data Compare 6 Alpha
  3. My Review
I was able to get the error a second time, but I can not duplicate it on demand. Thanks, Ben
0 votes
I started the sychronization process. On step 2, I clicked "View SQL Script...". Then I selected some text and hit <ctrl><c> to copy. A little later, I hit <ctrl><v> to paste and got the following error. Please let me know if you need more info from me. See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.Runtime.InteropServices.ExternalException: Requested Clipboard operation did not succeed. at System.Windows.Forms.Clipboard.ThrowIfFailed(Int32 hr) at System.Windows.Forms.Clipboard.SetDataObject(Object data, Boolean copy, Int32 retryTimes, Int32 retryDelay) at System.Windows.Forms.Clipboard.SetDataObject(Object data, Boolean copy) at RedGate.SQL.Controls.TextBoxControls.ColoredTextBox.OnCopy(CopyEventArgs e) at RedGate.SQL.Controls.TextBoxControls.ColoredTextBox.Copy() at RedGate.SQL.Controls.TextBoxControls.ColoredTextBox.OnKeyDown(KeyEventArgs e) at System.Windows.Forms.Control.ProcessKeyEventArgs(Message& m) at System.Windows.Forms.Control.ProcessKeyMessage(Message& m) at System.Windows.Forms.Control.WmKeyChar(Message& m) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ScrollableControl.WndProc(Message& m) at System.Windows.Forms.ContainerControl.WndProc(Message& m) at System.Windows.Forms.UserControl.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.832 (QFE.050727-8300) CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll RedGate.SQLDataCompare.UI Assembly Version: 6.0.0.721 Win32 Version: 6.0.0.721 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%206%20Alpha/RedGate.SQLDataCompare.UI.exe DevExpress.Utils.v6.3 Assembly Version: 6.3.1.0 Win32 Version: 6.3.1.0 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%206%20Alpha/DevExpress.Utils.v6.3.DLL System.Windows.Forms Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.832 (QFE.050727-8300) 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.832 (QFE.050727-8300) 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.832 (QFE.050727-8300) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll RedGate.SQL.Shared Assembly Version: 6.1.0.18 Win32 Version: 6.1.0.18 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%206%20Alpha/RedGate.SQL.Shared.DLL System.Xml Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.832 (QFE.050727-8300) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll RedGate.Licensing.Client Assembly Version: 1.4.0.8 Win32 Version: 1.4.0.8 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%206%20Alpha/RedGate.Licensing.Client.DLL ActiproSoftware.UIStudio.Dock.Net20 Assembly Version: 2.0.77.0 Win32 Version: 2.0.77.0 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%206%20Alpha/ActiproSoftware.UIStudio.Dock.Net20.DLL DevExpress.XtraEditors.v6.3 Assembly Version: 6.3.1.0 Win32 Version: 6.3.1.0 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%206%20Alpha/DevExpress.XtraEditors.v6.3.DLL DevExpress.Data.v6.3 Assembly Version: 6.3.1.0 Win32 Version: 6.3.1.0 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%206%20Alpha/DevExpress.Data.v6.3.DLL DevExpress.XtraBars.v6.3 Assembly Version: 6.3.1.0 Win32 Version: 6.3.1.0 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%206%20Alpha/DevExpress.XtraBars.v6.3.DLL ActiproSoftware.Shared.Net20 Assembly Version: 1.0.85.0 Win32 Version: 1.0.85.0 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%206%20Alpha/ActiproSoftware.Shared.Net20.DLL ActiproSoftware.WinUICore.Net20 Assembly Version: 1.0.85.0 Win32 Version: 1.0.85.0 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%206%20Alpha/ActiproSoftware.WinUICore.Net20.DLL DevExpress.XtraGrid.v6.3 Assembly Version: 6.3.1.0 Win32 Version: 6.3.1.0 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%206%20Alpha/DevExpress.XtraGrid.v6.3.DLL DevExpress.XtraPrinting.v6.3 Assembly Version: 6.3.1.0 Win32 Version: 6.3.1.0 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%206%20Alpha/DevExpress.XtraPrinting.v6.3.DLL System.Data Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.832 (QFE.050727-8300) CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll RedGate.SQL.Controls Assembly Version: 6.1.0.18 Win32 Version: 6.1.0.18 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%206%20Alpha/RedGate.SQL.Controls.DLL RedGate.SQLDataCompare.Engine Assembly Version: 6.0.0.614 Win32 Version: 6.0.0.614 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%206%20Alpha/RedGate.SQLDataCompare.Engine.DLL Syncfusion.Grid.Windows Assembly Version: 4.202.0.37 Win32 Version: 4.202.0.37 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%206%20Alpha/Syncfusion.Grid.Windows.DLL Syncfusion.Shared.Base Assembly Version: 4.202.0.37 Win32 Version: 4.202.0.37 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%206%20Alpha/Syncfusion.Shared.Base.DLL Syncfusion.Core Assembly Version: 4.202.0.37 Win32 Version: 4.202.0.37 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%206%20Alpha/Syncfusion.Core.DLL System.Configuration Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.832 (QFE.050727-8300) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll System.Design Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.832 (QFE.050727-8300) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll RedGate.SQLCompare.Engine Assembly Version: 6.0.1.27 Win32 Version: 6.0.1.27 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%206%20Alpha/RedGate.SQLCompare.Engine.DLL XtraDataTempAssembly Assembly Version: 0.0.0.0 Win32 Version: 6.3.1.0 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%206%20Alpha/DevExpress.Data.v6.3.dll RedGate.SQLCompare.BackupReader Assembly Version: 6.0.0.614 Win32 Version: 1.0.0.0 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%206%20Alpha/RedGate.SQLCompare.BackupReader.DLL RedGate.BackupReader Assembly Version: 1.0.0.346 Win32 Version: 1.0.0.346 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%206%20Alpha/RedGate.BackupReader.DLL RedGate.BackupReader.SqbReader Assembly Version: 1.0.0.346 Win32 Version: 1.0.0.346 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%206%20Alpha/RedGate.BackupReader.SqbReader.DLL System.Transactions Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.832 (QFE.050727-8300) 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.832 (QFE.050727-8300) CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll RedGate.SQLCompare.ASTParser Assembly Version: 6.0.1.27 Win32 Version: 6.0.1.27 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%206%20Alpha/RedGate.SQLCompare.ASTParser.DLL RedGate.SQLCompare.Rewriter Assembly Version: 6.0.1.27 Win32 Version: 6.0.1.27 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%206%20Alpha/RedGate.SQLCompare.Rewriter.DLL System.Data.SQLite Assembly Version: 1.0.40.0 Win32 Version: 1.0.40.0 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%206%20Alpha/System.Data.SQLite.DLL ActiproSoftware.Wizard.Net20 Assembly Version: 3.0.125.0 Win32 Version: 3.0.125.0 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%206%20Alpha/ActiproSoftware.Wizard.Net20.DLL Accessibility Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll System.Security Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Security/2.0.0.0__b03f5f7f11d50a3a/System.Security.dll System.Data.SqlXml Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.832 (QFE.050727-8300) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Data.SqlXml/2.0.0.0__b77a5c561934e089/System.Data.SqlXml.dll System.Web.Services Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Web.Services/2.0.0.0__b03f5f7f11d50a3a/System.Web.Services.dll System.Web Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.832 (QFE.050727-8300) CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll Microsoft.VisualC Assembly Version: 8.0.0.0 Win32 Version: 8.00.50727.42 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualC/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualC.dll Syncfusion.Shared.Windows Assembly Version: 4.202.0.37 Win32 Version: 4.202.0.37 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%206%20Alpha/Syncfusion.Shared.Windows.DLL System.Drawing.Design Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing.Design/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.Design.dll RedGate.Update.Client Assembly Version: 1.2.1.1 Win32 Version: 1.2.1.1 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%206%20Alpha/RedGate.Update.Client.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. / comments
  1. Community
  2. SQL Data Compare 6 Alpha
  3. My Review
I started the sychronization process. On step 2, I clicked "View SQL Script...". Then I selected some text and hit <ctrl><c> to copy. A little later, I hit <ctrl><v> to paste and got the followi...
0 votes
19 -- For "Export Comparison Results", could you let the user specify a delimiting character? Otherwise, it can be difficult to import the .csv if the table has text fields with commas in them. / comments
  1. Community
  2. SQL Data Compare 6 Alpha
  3. My Review
19 -- For "Export Comparison Results", could you let the user specify a delimiting character? Otherwise, it can be difficult to import the .csv if the table has text fields with commas in them.
0 votes
Thanks, here's some more feedback. 5-7 -- Just a personal preference. I was thinking about SQL Server which lets me minimize basically any window at any step (even the Maintenance Plan Wizard). You're correct that those windows are not maintained within the parent application (I'd missed that before. 8 -- That's not sufficient. For example, I have 200 tables in this database and each table could have 0-10 varbinary(MAX) columns. Sometimes I don't care if any of the binary information is different. It would be very useful to be able to specify that I don't want to do any comparison for a specific data type instead of manually selecting up to 2000 columns. As I said before, your competitors can do this. 10 -- I do think it would be nice to compress the files on the filesystem (even optionally). It would also be useful to have a display before one clicks "Compare" to let us know an estimated minimum free space (i.e., at least the size of the backup). Or just make sure it's documented in the Help file. 11 -- In the object differences guid, if I expand my key column and then move the splitter bar to the left, my key column shrinks way down. Could you only shrink it enough to fit to the left of the splitter bar so that I don't have to re-expand it to fill the available space? 12 -- It's nice to see British spelling again (Synchonisation instead of Synchronization) in a program :-) However, it's not consistent. I see a button that has "Synchronization Wizard", but in the comparison window, I see "Synchroisation cannot change this backup". I know, being picky. 13 -- Switching between the 2 different object differences views is very quick. The previous and next buttons are quick. The filter to show all rows, rows that just exist in source or destination, and different rows is quick. And that's very impressive because I clicked on a table that has 1,983,153 differences (on purpose) and the grid showed up immediately. 14 -- The "Show Migration SQL" box generated the SQL script very quickly (except when I did it on 1,983,153 rows and I wouldn't expect it to be quick here). 15 -- I am unable to uncheck the checkboxes in "Columns as rows view". 16 -- It uses a relatively small memory footprint (122MB) when I have my comparison loaded. 17 -- Canceling the progress once I start a synchronization worked just fine. 18 -- Could you make it so that clicking on the synchronization direction arrow reverses the synchronization direction instead of having to right-click to change this? Just for timing purposes, comparison of a 12 GB database to a 12 GB backup took about 3.5 hours on my laptop. Thanks again, looks like a good upgrade. ~Ben / comments
  1. Community
  2. SQL Data Compare 6 Alpha
  3. My Review
Thanks, here's some more feedback. 5-7 -- Just a personal preference. I was thinking about SQL Server which lets me minimize basically any window at any step (even the Maintenance Plan Wizard). Y...
0 votes
If you don't have enough disk space there's an unhandled System.IO.IOException that gets thrown. / comments
  1. Community
  2. SQL Data Compare 6 Alpha
  3. My Review
If you don't have enough disk space there's an unhandled System.IO.IOException that gets thrown.
0 votes
My Review
  1. Community
  2. SQL Data Compare 6 Alpha
In my previous job (up until 6 weeks ago), I frequently used SQL Data Compare on databases up to 500GB in size. Actually, we were beta testers for one of the earliest versions of SQL Compare becaus...
2 followers 9 comments 0 votes
Total activity
7
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1