Comments
9 comments
-
If you don't have enough disk space there's an unhandled System.IO.IOException that gets thrown. -
3. We've fixed the GUID issue in our internal build already - should work better than v5 did which was to do textual comparison - v6 does the binary comparison that SQL Server uses to order your table.
5.+7. I think the sub-window thing is a consistent user interface from applications like visual studio where once you're in a setup wizard you have to complete it before continuing. Also if I hide the other windows while I show progress if there is a problem ( for example a schema change during comparison ) then I need to drop you back into the wizard so you can fix the issue before continuing.
8. You can include and exclude any columns you wish via the drop down configuration on the tables&views tab columns field (where is says e.g. 14 columns)
9. Sounds like a good idea - I'll suggest it as a future enhancement to the progress control.
10. We take the space of the data that is different and one copy of the data that is the same. So if you have 10 columns in a row, if you have 3 comparison columns we use the data from the first database only, for the subsequent fields we store the data from the first table only where they are the same and where different we store both, so if you have 2 columns that were different we will store 12 columns of information on that row.
We're working on a compression routine internally although we're still not sure if it'll make the release - however it would reduce disk usage by 60-80% with a very small performance impact. -
lambenjamin wrote:If you don't have enough disk space there's an unhandled System.IO.IOException that gets thrown.
We'll have a look into that - the exception should be able to be handled gracefully - you can set an environment variable called RGTEMP which is the directory that would be used for the temporary files if you want to put them on a different disk. By default we use TEMP. -
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 -
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.
-
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. -
Good call stack - I should be able to get to the bottom of that error with that information.
Could you reproduce the bug or did it just happen the once? -
I was able to get the error a second time, but I can not duplicate it on demand.
Thanks,
Ben -
OK we'll have a look into it and see if we can get it to break. Thanks for trying.
Add comment
Please sign in to leave a comment.
Actually, we were beta testers for one of the earliest versions of SQL Compare because we'd been working on
something similar for just in-house use when we ran across Red Gate. In my new position, I am using one of your
competitor's products, but am drawn back to Red Gate's SQL Data Compare.
This morning I had to restore a 12 GB production database to another server and take down the old server.
Unfortunately, I knew there was a period of time when transactions were hitting both servers, so I needed to get the
data back in synch.
I used both SQL Data Compare 6 Alpha as well as another company's data comparison product to compare speeds and
results (since this is an Alpha and I wanted to validate the results).
I'm running this on Windows XP SP2, 2GB RAM, Intel Core 2 Due T7300 @ 2GHz.
1. I love the ability to compare against a backup file. I am unable to do data comparisons on production due to
the impact that would have and the constantly shifting data, so having to copy a backup file to a different server
and then restore it is a pain.
2. Being able to compare 2 backup files is even better! Talk about a time savings!
3. We happen to use GUIDs for a lot of our PKs, so I look forward to reviewing this again once that bug is fixed.
4. I was impressed with how quickly SQL Data Compare was able to retrieve the schema during the database
registration process. The entire UI is very responsive.
5. When creating a new project, I get to the "Project Configuration" and I have 3 windows (SQL Data Compare,
Comparison Projects, Project Configuration) and just one window in my taskbar.
a. Could you make it so that if I move the "Project Configuration" window it stays within the bounds of the
"SQL Data Compare Window", etc.?
b. When I have these windows up, I do not have the ability to minimize the program (I can't get to the
minimize button on the "SQL Data Compare" window or from the taskbar). Please make it possible to minimize. There
are times when I might need to jump off to another project or go look up something in SQL and don't want to lose
what I'm in the middle of doing with SQL Data Compare.
6. The ability to Remap objects (especially owners) is a great feature and something we'll use a lot against our
SDE databases.
7. When I click "Compare Now", can you close the windows that are open so that I just have the "SQL Data Compare"
window and the "running" window? I appreciate not having too many windows open.
8. I may have missed it, but it would be nice to be able to include or exclude the comparison of binary fields in
the tables. I may need to just do a quick comparison or may not care about those fields for one reason or another.
(The other product has this capability.)
9. Could you add a "start time" and "completion time" or an "elapsed time" to the "running" window when doing a
comparison? That way, it's quick and easy to know how long I need to budget to do a similar compare the next time.
I know, I could just look at the computer clock, but...
10. How much space on disk does it take to do a compare? Does it need the size of one database or of 2 in order to be able to successfully do a compare?
I'll keep looking into it as soon as I free up more space.
Thanks for a great product (again). I look forward to continuing testing this.
Thanks,
Ben