Comments
Sort by recent activity
Hi
Sorry about the confusion here - this was an unintended behaviour change introduced in SQL Compare 12.4.3. We're working on a fix for this at the moment and hope to have a release with the comparison working as expected soon. As a side note, this is just a display issue - the deployment should still do the right thing if you check the deployment script that is produced.
Apologies,
Mark / comments
Hi
Sorry about the confusion here - this was an unintended behaviour change introduced in SQL Compare 12.4.3. We're working on a fix for this at the moment and hope to have a release with the compa...
Sorry for the delay here - I think we've tracked down the problem, so hoping to have a fix released some time this week if possible. / comments
Sorry for the delay here - I think we've tracked down the problem, so hoping to have a fix released some time this week if possible.
Hmm, that's a problem. I'm sorry to say I can't reproduce the behaviour here (for me the menu item always seems to be enabled when appropriate) but we'll have a look and see if we can figure out what's going on.
Out of interest, have you noticed any particular things which might cause the menu item to be disabled? (eg does it happen refreshing the comparison or doing a comparison from scratch?) / comments
Hmm, that's a problem. I'm sorry to say I can't reproduce the behaviour here (for me the menu item always seems to be enabled when appropriate) but we'll have a look and see if we can figure out wh...
I might have found something. It looks like if I close a project, then chose 'My projects', select a project and press 'Compare now', then the option is disabled. However, if I instead go to 'My projects', select a project, press Edit instead and then press 'Compare now' from the 'Edit project' window, then the menu item is enabled as expected. Does that match what you're seeing? / comments
I might have found something. It looks like if I close a project, then chose 'My projects', select a project and press 'Compare now', then the option is disabled. However, if I instead go to 'My pr...
Thanks for the update - I'm happy it's working again for you now. Let us know if you have any more problems in the future [image] / comments
Thanks for the update - I'm happy it's working again for you now. Let us know if you have any more problems in the future
Hi Vijay
Sorry to hear you're having trouble. The "Generate comparison results report..." menu option should only be disabled when you don't currently have any comparison results open - could you try performing a comparison and seeing if the menu item is still disabled?
Thanks
Mark / comments
Hi Vijay
Sorry to hear you're having trouble. The "Generate comparison results report..." menu option should only be disabled when you don't currently have any comparison results open - could you t...
Hi - sorry for the delay on this.
To clarify, the Database class only stores schema information and Database.SaveToFolder() will only write out schema to a folder. The RegisterForDataCompare method creates a Database instance with limited schema information specifically relevant to Data Compare (ie mostly focusing on tables and views rather than other object types) which can then be fed into ComparisonSession and other related classes to do the actual data operations. / comments
Hi - sorry for the delay on this.
To clarify, the Database class only stores schema information and Database.SaveToFolder() will only write out schema to a folder. The RegisterForDataCompare method...
There are some options you can set in EngineDataCompareOptions - the Options property of the ComparisonSession that gets passed into GetMigrationSQL which will affect the deployment script. However, there isn't currently an option similar to DropAndCreateInsteadOfAlter from SQL Compare. There is a very popular uservoice request for this feature, though - we don't have any definite plans to work on it at the moment but we hope we can implement it in the future. / comments
There are some options you can set in EngineDataCompareOptions - the Options property of the ComparisonSession that gets passed into GetMigrationSQL which will affect the deployment script. However...
Hi Thomas
Sorry for the delay on this - the newlines problem should now be fixed as of SQL Data Compare 12.4.4.4771. / comments
Hi Thomas
Sorry for the delay on this - the newlines problem should now be fixed as of SQL Data Compare 12.4.4.4771.
Hi there - sorry to hear you're having problems with SQL Compare
I think what might have happened here is you've done a deployment without 'Recompare after deployment' selected. Normally SQL Compare will re-read and re-compare the databases after a deployment completes, which should mean that you see updated comparison results. It might also be the case that you've done a deployment outside of SQL Compare, in which case it won't know to update the comparison results. The fix for both of these cases is to press the 'Refresh' button on the toolbar, which should cause Compare to throw away the older (cached) results.
If that doesn't work, it might be worth looking into the project options and filters you have set up in the project - if those are different between the two instances of Compare that might also be causing the different results that you're seeing.
If you still see differences between v11 and v12 with a fresh comparison and the same project options / filters in both cases, that would be a pretty serious bug, so we'd definitely investigate further. / comments
Hi there - sorry to hear you're having problems with SQL Compare
I think what might have happened here is you've done a deployment without 'Recompare after deployment' selected. Normally SQL Compar...