Comments
Sort by recent activity
version 0.2.4 / comments
version 0.2.4
Actually I take that back. If you can synonym system views to look at a different db, that would my immediate task easier but wouldn't solve the general problem / comments
Actually I take that back. If you can synonym system views to look at a different db, that would my immediate task easier but wouldn't solve the general problem
@kalo have you used this to synonym system views? does that work? Even so, it doesn't solve my problem, which is to exclude search results where the only difference is some text that I don't care about. / comments
@kalo have you used this to synonym system views? does that work? Even so, it doesn't solve my problem, which is to exclude search results where the only difference is some text that I don't care ...
I'd like too, but I'm out of votes / comments
I'd like too, but I'm out of votes
I still get OOM errors in 17.3, even with no Redgate tools installed / comments
I still get OOM errors in 17.3, even with no Redgate tools installed
mark.jordan wrote:
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
So if serverainstance1 has a link to serverb:
Compare: serverainstance1 to: serverainstance1.serverb
Where serverb is the name of the linked server? / comments
mark.jordan wrote:
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...
Thanks! That worked.
Next issue: two servers that I want to compare are in different domains and the domains don't trust each other. I use different IDs for each domain to login to the servers. How can I set up the project so that I can compare these two servers? Assuming one of the servers is in the same domain I run the project from, I would need a place to put in the Windows credentials for the other domain and SQL Data Compare would need to use those credentials for that connection?
Can that be done?
Also, can I specify a linked server as the Compare To server? / comments
Thanks! That worked.
Next issue: two servers that I want to compare are in different domains and the domains don't trust each other. I use different IDs for each domain to login to the servers. H...
Yeah the option is there but doesn't work.
I enabled option, ran compare and got:
[RenewRatio] [numeric] (13, 5) NULL CONSTRAINT [DF__CACommits__Renew__6287E118] DEFAULT ((0)), => [RenewRatio] [numeric] (13, 5) NULL CONSTRAINT [DF__CACommits__Renew__2EE779F7] DEFAULT ((0)),
The only difference is the constraint name, for which I set the option to ignore the differences / comments
Yeah the option is there but doesn't work.
I enabled option, ran compare and got:
[RenewRatio] [numeric] (13, 5) NULL CONSTRAINT [DF__CACommits__Renew__6287E118] DEFAULT ((0)), => [RenewRatio] [num...