Comments
Sort by recent activity
Hi
You might need to set the 'Use migration scripts (V2)' option in the project setup, described here: documentation.red-gate.com - then the deployment script should respect the migration scripts you have set up.
Does that help? / comments
Hi
You might need to set the 'Use migration scripts (V2)' option in the project setup, described here: documentation.red-gate.com - then the deployment script should respect the migration scripts y...
Yep, this sounds like a case for Compare's filters: https://documentation.red-gate.com/disp ... ng+filters / comments
Yep, this sounds like a case for Compare's filters: https://documentation.red-gate.com/disp ... ng+filters
Hi there
Apologies for the inconvenience - this is currently a known issue with some machines running Windows 10. We don't know what the underlying cause is yet, but the workaround seems to be killing tabtip.exe or disabling the touch keyboard, as described here: http://superuser.com/questions/524453/d ... n-keyboard
Thanks for the video - I can reproduce something similar on my machine, but it only happens when I actually have the touch keyboard open, so it needs a bit more investigation on our part to see what particular setup actually causes this problem. / comments
Hi there
Apologies for the inconvenience - this is currently a known issue with some machines running Windows 10. We don't know what the underlying cause is yet, but the workaround seems to be kill...
Ah, apologies - this is due to a refactoring we've done recently to make version checks against different SQL Server versions more sensible.
Anyway, there should be a extension method in IDatabaseObjectExtensionMethods which preserves the old API - it's defined like this:
public static Regions ScriptObject(this ScriptableDatabaseObject objectToScript, SqlSetOptions sqlSetOptions, Options options)
{
var targetFeatures = objectToScript.Database.GetSupportedFeatures();
return objectToScript.ScriptObject(sqlSetOptions, options, targetFeatures);
}
Is there something else that's causing the old code to not work? / comments
Ah, apologies - this is due to a refactoring we've done recently to make version checks against different SQL Server versions more sensible.
Anyway, there should be a extension method in IDatabaseO...
It's hard to find any official information, but from a quick test it seems the DBCC PAGE results should only get written to the errorlog if trace flag 3605 is set (instead of 3604), and if both flags are set it gets written to both places - is this something you might have set currently? / comments
It's hard to find any official information, but from a quick test it seems the DBCC PAGE results should only get written to the errorlog if trace flag 3605 is set (instead of 3604), and if both fla...
Oh, I see. Yeah, Compare needs DBCC TRACEON 3604 (also DBCC DBINFO and DBCC PAGE) to decrypt objects that have WITH ENCRYPTION set on them so that we can deploy them properly. Background: We're doing something similar to http://sqlity.net/en/1617/decrypting-en ... e-objects/ but using DBCC PAGE instead of the DAC in order to access the system base tables. I haven't heard of it causing a problem to this degree before, though - is there something else that could be filling up the log?
I'm hoping we can take a look at the code for decrypting objects so that it spams 3604 less often - I think at the moment it's trying a bit too hard to be conservative (to make sure 3604 is never set when it shouldn't be) / comments
Oh, I see. Yeah, Compare needs DBCC TRACEON 3604 (also DBCC DBINFO and DBCC PAGE) to decrypt objects that have WITH ENCRYPTION set on them so that we can deploy them properly. Background: We're doi...
That's definitely not expected behaviour - if there isn't anything too sensitive then it would be useful to send some logs to support@red-gate.com so we could see what's going on.
In the meantime, you should be able to change the logging options here: https://documentation.red-gate.com/disp ... +log+files - hopefully this fixes the problem for now. / comments
That's definitely not expected behaviour - if there isn't anything too sensitive then it would be useful to send some logs to support@red-gate.com so we could see what's going on.
In the meantime, ...
Thanks for the feedback - one of the items we've got on our (admittedly long) backlog is a proper review of all the Compare warnings, so I'll make sure that your comments get into that process. / comments
Thanks for the feedback - one of the items we've got on our (admittedly long) backlog is a proper review of all the Compare warnings, so I'll make sure that your comments get into that process.
Sounds sensible to me - I've written this up as SC-8023. Hopefully it should be a quick change [image] / comments
Sounds sensible to me - I've written this up as SC-8023. Hopefully it should be a quick change
Unfortunately "Windows authentication" currently only supports the user that you're running the program as - we've had a pending feature request for windows auth impersonation for a while. It looks like it would be possible to run as a different user for the whole program (something like http://codebetter.com/jameskovacs/2009/ ... -computer/ ) but that doesn't really help if you want to compare across two different domains [image]
I think for a linked server you would just have to specify the server/instance name directly / comments
Unfortunately "Windows authentication" currently only supports the user that you're running the program as - we've had a pending feature request for windows auth impersonation for a while. It looks...