Comments
Sort by recent activity
Thanks for your post - this is indeed something that SQL Compare should be able to handle. I did a quick test with a schemabound view that queries a table with an extra column, and when I got SQL Compare to generate a deployment script it first altered the view to not have schemabinding before changing the table and then reenabled schemabinding on the view.
It would be good to check if you have 'Deploy all dependencies' enabled in the deployment wizard - this behaviour won't work if that checkbox isn't checked.
If you're still having trouble it might be a bug in SQL Compare, in which case a more specific reproduction would be helpful - you can get in touch with support if you need to keep database details private. / comments
Thanks for your post - this is indeed something that SQL Compare should be able to handle. I did a quick test with a schemabound view that queries a table with an extra column, and when I got SQL C...
Hi Matthew
We've just released SQL Compare 12.4.4.4771 - should be much more well-behaved when it comes to dealing with newlines, so it shouldn't get tripped up like this again on non-standard newline characters. / comments
Hi Matthew
We've just released SQL Compare 12.4.4.4771 - should be much more well-behaved when it comes to dealing with newlines, so it shouldn't get tripped up like this again on non-standard newl...
Thanks for the details, that's really helpful. It's good to know that we're not actually blocking what you want to do, but we can definitely look into improving the option descriptions to be clearer about how they relate to each other.
I'll also have a look into pulling the options apart some more - this might be trickier since it is important to us that we preserve behavior for people using existing project files, but I'll see what we can do. / comments
Thanks for the details, that's really helpful. It's good to know that we're not actually blocking what you want to do, but we can definitely look into improving the option descriptions to be cleare...
Hi there
We've just released SQL Data Compare version 12.4.4.4771 which contains a fix for a similar bug with the selected row count, and I think it might fix this issue as well - could you take a look and see if it helps? 12.4.4.4771 is currently available on Frequent Updates, so you might need to enable that (details here: https://documentation.red-gate.com/display/SDC12/Turning+on+Frequent+Updates )
Thanks,
Mark / comments
Hi there
We've just released SQL Data Compare version 12.4.4.4771 which contains a fix for a similar bug with the selected row count, and I think it might fix this issue as well - could you take a ...
Sorry you're having trouble here - we've had some similar feedback recently, so we're working on performance improvements for the table mappings UI, especially around selecting/deselecting large numbers of tables at a time. Hopefully we'll have something to release soon, although it's probably going to be after the New Year at this point. / comments
Sorry you're having trouble here - we've had some similar feedback recently, so we're working on performance improvements for the table mappings UI, especially around selecting/deselecting large nu...
Ok, thanks for the extra information. Hopefully we can figure out what's going wrong with the object reference error as well. / comments
Ok, thanks for the extra information. Hopefully we can figure out what's going wrong with the object reference error as well.
Thanks for the feedback. Sorry you're having trouble with sorting - I've reproduced that and logged a bug (SDC-2238) so we'll investigate that soon
I can't seem to reproduce the Type header application error, though. I tried creating a comparison with a table and view and clicking on the Type header appears to sort them correctly. Do you have any more information here that might be helpful?
Thanks, / comments
Thanks for the feedback. Sorry you're having trouble with sorting - I've reproduced that and logged a bug (SDC-2238) so we'll investigate that soon
I can't seem to reproduce the Type header applica...
We should do, but it's possible that Azure has been updated in a way that we haven't anticipated. We did update the list of known trigger event types in 12.0.39.3632, but this sounds like a different issue. Is there some way we can figure out what the specific reproduction is here? You can get in touch with support@red-gate.com if you don't want to publish any database details publicly / comments
We should do, but it's possible that Azure has been updated in a way that we haven't anticipated. We did update the list of known trigger event types in 12.0.39.3632, but this sounds like a differe...
Sorry you're having trouble here- you should be able to type in a database name if you know it already, so you don't actually need to list databases. Hopefully that works around the problem
For reference, the sql we run is
SELECT name, cmptlevel, sid, status FROM dbo.sysdatabases ORDER BY name
We run this query against the master database - maybe that's why you're seeing login errors? / comments
Sorry you're having trouble here- you should be able to type in a database name if you know it already, so you don't actually need to list databases. Hopefully that works around the problem
For ref...
Hi
Sorry to hear you've been having trouble. I think we should have logging around the check for updates functionality, so if you start a verbose log as described in https://documentation.red-gate.com/disp ... +log+files, reproduce the problem and then have a look for log lines marked 'UpdateClient', there might be something useful there. Otherwise you'll probably need to get in touch with support at support@red-gate.com to try and debug the problem further
Hope that's helpful / comments
Hi
Sorry to hear you've been having trouble. I think we should have logging around the check for updates functionality, so if you start a verbose log as described in https://documentation.red-gate....