Comments
Sort by recent activity
You're right @DanW564, that's exactly what the problem is and the workaround is just to add the missing comma as you've explained. We've got a fix ready for this and it should go out in the next frequent update release. / comments
You're right @DanW564, that's exactly what the problem is and the workaround is just to add the missing comma as you've explained.We've got a fix ready for this and it should go out in the next fre...
Hi @Gooders Sorry, SQL Search doesn't index partition schemes. For more info on its limitations, see the "Search limitations" section on the How to search page in the online documentation. / comments
Hi @Gooders Sorry, SQL Search doesn't index partition schemes. For more info on its limitations, see the "Search limitations" section on the How to search page in the online documentation.
Hi @swallman, There are certainly ways of achieving this. If you're performing a scheduled restore then there will be a SQL Server Agent job for the restore - if you add some extra steps to it with your custom scripts then they will be executed immediately afterwards. If you're performing on-demand restores, then it needs slightly more thought. One option could be to use SQL Backup's extended stored procedure and create a SQL script that both performs the backup and tweaks the data afterwards. This could be a stored procedure somewhere on the server, or stored locally and run via sqlcmd for instance. We have a page on scripting SQL Backup that may be of interest - https://documentation.red-gate.com/sbu9/scripting-sql-backup-pro I hope this helps. / comments
Hi @swallman,There are certainly ways of achieving this. If you're performing a scheduled restore then there will be a SQL Server Agent job for the restore - if you add some extra steps to it with ...
Hi @bhmsch 1. There isn't a way to do this. Sorry. 2. If you want to provide feedback on SQL Compare then please leave any suggestions on our Uservoice site. All the best. / comments
Hi @bhmsch 1. There isn't a way to do this. Sorry.2. If you want to provide feedback on SQL Compare then please leave any suggestions on our Uservoice site.All the best.
Hi @kalo It seems that SQL Source Control has its own diff viewer so any changes to the one in SQL Compare shouldn't affect SQL Source Control. / comments
Hi @kalo It seems that SQL Source Control has its own diff viewer so any changes to the one in SQL Compare shouldn't affect SQL Source Control.
That's really interesting, thanks very much for sharing that. When you say "recalculation", are you referring to the recalculation that is done after the deployment? If so, you can turn that off in the deployment wizard - see below.[image] The ideal scenario sounds like it would be to make it easier for you to deploy. We're aware that there are some issues around the current implementation of selecting dependencies - at the moment it's a binary all or nothing choice. If you could choose whether or not to deploy individual dependencies, it sounds like that would improve things for you. To be honest, I'm not certain about SQL Source Control's diff viewer. I don't think it's shared with SQL Compare, but I'll look into it. / comments
That's really interesting, thanks very much for sharing that.When you say "recalculation", are you referring to the recalculation that is done after the deployment? If so, you can turn that off in ...
The fix went out this morning with the 13.4.4.6883 release. / comments
The fix went out this morning with the 13.4.4.6883 release.
Hi @kalo Sorry that you're still not happy with the diff viewer. I would be careful if you want the original object code because the diff viewer shows a creation script for the object that SQL Compare has created, based on the information it has registered. So for instance you may find that an inline index definition has been rewritten as an ALTER TABLE myTable ADD INDEX... statement. I would say it's more of a representation. I think if I had selected text that includes blank lines, then copied that text to the clipboard, I would expect those blank lines to be present when I paste it. Is copying the object definition from the diff viewer something that you do regularly? I'd like to understand your use case more. / comments
Hi @kalo Sorry that you're still not happy with the diff viewer. I would be careful if you want the original object code because the diff viewer shows a creation script for the object that SQL Comp...
Hi @kalo Thanks for the heads up! It seems to be an edge case that only occurred when the "Ignore whitespace" option was set. If you turn off that option then it seems to work normally. I've fixed the problem and the fix will go out in the next frequent update release. / comments
Hi @kalo Thanks for the heads up! It seems to be an edge case that only occurred when the "Ignore whitespace" option was set. If you turn off that option then it seems to work normally.I've fixed t...
The SQL Comparison SDK was retired last year. Version SQL Compare 13 has never had an SDK release - the last version was 12.3. See this forum post for more information - https://forum.red-gate.com/discussion/81556/retirement-of-sql-comparison-sdk If you've just copied the DLLs from SQL Compare then we don't support this. There is no longer a public API and there will be breaking changes such as the one you have experienced. / comments
The SQL Comparison SDK was retired last year. Version SQL Compare 13 has never had an SDK release - the last version was 12.3. See this forum post for more information - https://forum.red-gate.com/...