Activity overview
Latest activity by Newfave
Invalid comparison options found - error
Does anyone know the remedy for this error:
Invalid comparison options found in C:Users<user>AppDataLocalRed GateSQL Source Control 3Transientshc5ukplo.1ubComparisonOptions.xml. To resolve please ...
Per redgate, a bug has been identified and noted with number SC-6208.
The bug appears to affect the use of the Project file in the command line interface.
I find the Project file to be the easiest way to handle all the options of a comparison - rather than trying to handle it through command line switches.
One can first prepare a Project file using the GUI and get the use of the GUI to make settings changes - and then use it.
So, I hope this bug receives attention - because I think the Project file approach is the best approach. / comments
Per redgate, a bug has been identified and noted with number SC-6208.
The bug appears to affect the use of the Project file in the command line interface.
I find the Project file to be the easiest ...
Does anyone know how to get around the project options issues - other than switching to straight command line? / comments
Does anyone know how to get around the project options issues - other than switching to straight command line?
Above I suggested that the problem is probably a change in the API. That's probably not true.
It looks to be in the new "Checking for identical databases" operation.
I say that judging from what the comparison output looks like now versus what it looked like before the new version of SQL Compare got deployed to our servers. / comments
Above I suggested that the problem is probably a change in the API. That's probably not true.
It looks to be in the new "Checking for identical databases" operation.
I say that judging from what th...
I'd expect there to be an announcement for the new version 10.3.1.140.
My team deployed the new version on Thursday 1/28/2013 - and now my automation for detecting changes between source control and production databases does not work.
I suspect that there were significant changes made to the API - that is affecting my set-up.
In order to make working with the command line easier, I create a template version of the SQL Compare .scp file - so I can handle all the settings there. Then I adjust it to point to a specific database - and run the comparison.
I actually run comparison on several hundred databases daily.
Anyhow - the problem I now get sounds like the complaints in this thread - where I no longer get comparison output that I expect.
I get an error message: "Error: The selected objects are identical or no objects have been selected in the comparison"
The comparison output is now:
"Registering data sources
Creating mappings
Comparing
Summarizing Project Selections
Retrieving migration scripts
Checking for identical databases"
So, it looks like the issue is in that step of "checking for identical databases"
Previously, the comparison output would include difference summary information:
"
Registering data sources
Creating mappings
Comparing
Summarizing Project Selections
Retrieving migration scripts
Summary Information
==============================================================================="
Also, shouldn't there be an announcement of the new version deployment?!!! / comments
I'd expect there to be an announcement for the new version 10.3.1.140.
My team deployed the new version on Thursday 1/28/2013 - and now my automation for detecting changes between source control an...
Using Sql Compare SDK within an SSIS Package
Is it feasible to use the Sql Compare SDK within an SSIS Package c# Script Task?
There are assemblies that need to be referenced for the SDK. How would one make those available so the Package can u...