Comments
Sort by recent activity
Just to update the forum - this has been reproduced internally and logged as a bug.
If anyone else experiences errors like this, we'd still appreciate it if details are posted just in case they aren't down to the same root cause.
Regards
Chris / comments
Just to update the forum - this has been reproduced internally and logged as a bug.
If anyone else experiences errors like this, we'd still appreciate it if details are posted just in case they are...
janhansen wrote:
Differential backups
I did this scenario to see how differential backup comparison is carried out:
1) Made a full database backup of a simple 1 table database
2) Added a couple of rows in the database
3) Made a comparison of the backup with the online database. All works well - the added rows are identified as being in the online database and not in the backup
4) Then I did a new backup of the database. This time only a differential backup. The differential backup is done to the same backupfile used in step 1.
5) Suddenly the comparison project can't/wont run any more. Even if I uncheck the "Always use latest backup" and select the backup set made in step 1 I get an error running the comparison. The error comes when Data Compare tries to register databases - and goes "index out of bounds".
I haven't bothered to check the documentation - this might very well not be a supported feature - in that case no problems - but if it is an intended feature I can make it work :?
regards
Jan
Hi Jan
This is interesting as it's something that I've done countless times whilst testing. I've just quickly ran through the steps above using SQL2K and SQL2K5 databases, full and simple recovery modes and have so far been unable to replicate the issue.
Is there any chance that you could post the SQL script that you used here or alternatively email it to chris.spencer@red-gate.com. This would be much appreciated as it seems to me that you've hit something that we really need to fix.
Regards
Chris / comments
janhansen wrote:
Differential backups
I did this scenario to see how differential backup comparison is carried out:
1) Made a full database backup of a simple 1 table database
2) Added a couple...
Unfortunately I am still unable to reproduce the error despite having following your instructions to the word - it seems to be a lot more subtle than I first thought.
However, there is something further that you could do to help us diagnose this problem. Could you create a directory called "logs" in the SDC6 installation directory, then restart the application and try again? You should then have one or more text files in there - if you could email these to me at chris.spencer@red-gate.com that'd be great. Hopefully that should give us some more information as to what's going on.
Regards
Chris / comments
Unfortunately I am still unable to reproduce the error despite having following your instructions to the word - it seems to be a lot more subtle than I first thought.
However, there is something fu...
Hi Gerd
Thanks again for all your feedback. We have received quite a few suggestions for enhancements to the Object Differences grid and it is very possible that we'll be trying to implement some of them.
If your specific suggestions don't make it into the final release then be assured that we have noted them and will consider them for any future release.
Regards
Chris / comments
Hi Gerd
Thanks again for all your feedback. We have received quite a few suggestions for enhancements to the Object Differences grid and it is very possible that we'll be trying to implement some o...
Hi
Thanks for your feedback. We're glad that you like the improvements to the object differences view - it does make locating differences so much easier.
Regarding the column headers scrolling out of sight in the pivot view, I suspect that you are right and it is inconsistent with the standard view. I will have to speak to the developer about this as there may be a valid technical reason for this. I'll get back to you.
Regards
Chris / comments
Hi
Thanks for your feedback. We're glad that you like the improvements to the object differences view - it does make locating differences so much easier.
Regarding the column headers scrolling out ...
Hi
I've raised the pivot view issue internally but cannot promise that it'll make it into the final release. It may well be difficult to implement.
Regarding other items on your wishlist. - to hide/show columns without differences
This is something we've looked into but won't be doing for technical reasons - to hide/show columns not included in the comparison
Columns not included in the comparison shouldn't appear in the Object Differences view. If you wish to show them them again you will have to modify the Columns In Comparisons settings in the Tables & Views tab of the Project Configuration form and then re-compare - to change column order and size and store these settings in the project file + to sort columns with differences first, so you can easily see all differences and spot identical ones
Definitely worth our consideration but I can imagine that this is down to technical feasibility - to print the object differences view or export it to Excel
One for the future perhaps but definitely not for version 6 - little overview window
An interesting idea but it sounds like it would take quite some time to implement successfully. Again not for version 6.
Regards
Chris / comments
Hi
I've raised the pivot view issue internally but cannot promise that it'll make it into the final release. It may well be difficult to implement.
Regarding other items on your wishlist.- to hide/...
Hi Gareth
I've managed to replicate the issue. There appears to be an issue when changing the Disable DML trigger option between the compare and sync. I found that refreshing the comparison after changing the option solved the issue and can hopefully be used as a workaround.
I have raised the issue in our internal bug-tracking system - hopefully it will be fixed in the next version of data compare.
Many Thanks
Chris / comments
Hi Gareth
I've managed to replicate the issue. There appears to be an issue when changing the Disable DML trigger option between the compare and sync. I found that refreshing the comparison after c...
Hi Srikmr
It is possible to change the comparison key used when comparing tables in the Data Compare UI.
Click Edit Project to get the Project Configuration dialog - in the Tables & Views tab notice that the Comparison Key column on the left has a drop-down that allows you to select a custom comparison key. The column you select here should then be used by data compare to match the rows between two tables without the need for a WHERE clause. I hope that this helps.
I'll have to get back to you regarding the best method for doing this with the API. I presume that you are familiar with the SQLToolkit.chm file that we ship with the product?
Best Regards
Chris / comments
Hi Srikmr
It is possible to change the comparison key used when comparing tables in the Data Compare UI.
Click Edit Project to get the Project Configuration dialog - in the Tables & Views tab notic...
Hi Srikmr
In addition to the SQLToolkit.chm help file we ship some very useful code samples. If you've installed to the default location then they should be at: C:\Program Files\Red Gate\SQL Bundle 5\Toolkit Sample Files\Automating SQL Data Compare
The samples are provided in C# and VB.NET. I suspect that the code in TableMappingExample.cs will be of most help to you.
Best Regards
Chris / comments
Hi Srikmr
In addition to the SQLToolkit.chm help file we ship some very useful code samples. If you've installed to the default location then they should be at:C:\Program Files\Red Gate\SQL Bundle ...
Hi Srikmr
I think we need to find out the base types of the two cells that are being reported as different by SQL Data Compare. The quickest way to do this is to hover the mouse over the relevant cells in the Object Differences panel of the data compare UI. It should show a tooltip with the text 'sql_variant: datetime' or potentially 'sql_variant: nvarchar'.
Alternatively you can find the base type using the following t-sql (edited as necessary):
SELECT SQL_VARIANT_PROPERTY(DESCRIPTION,'BaseType') AS 'Base Type'
FROM TABLE1
WHERE DESCRIPTION = '2006-03-07 11:44:02.000'
-- WHERE ID = 1
If the base_type is datetime for both DB1 and DB2 then we will need to investigate some other ideas.
Regards
Chris / comments
Hi Srikmr
I think we need to find out the base types of the two cells that are being reported as different by SQL Data Compare. The quickest way to do this is to hover the mouse over the relevant c...