Activity overview
Latest activity by raoulteeuwen
Bug when selecting all columns
Hi everybody.
I don't know where this might be posted elsewhere, so i thought i would share this with you here.
I ran into this bug, confirmed by Red Gate (reference F0026180). It happens when you ...
The user i was using to connect to 1 of the machines, had (only) Public as rol on the database. I've just added Data Reader, and it now seems to do the compare (slow, but that will probably be our infra ;-)).
Leaves me one question for now: is there no simpler way to have Data Compare understand what keys it can use :-)? (apparantly it is not specified on SQL-table-level, so the RedGate tool can't use that info) No way it can autodetect/propose the key from sampling the table :-)? / comments
The user i was using to connect to 1 of the machines, had (only) Public as rol on the database. I've just added Data Reader, and it now seems to do the compare (slow, but that will probably be our ...
Thank you VERY much for this SUPER fast reply Chris!
I've created a new topic: http://www.red-gate.com/MessageBoard/vi ... 2602#32602 . I'm (afaik) not using any where-clause.
Posting it on the forum makes the info more available for others? But if i get a faster/better reply by emailing support, please let me know, then i will use that email box! / comments
Thank you VERY much for this SUPER fast reply Chris!
I've created a new topic: http://www.red-gate.com/MessageBoard/vi ... 2602#32602 . I'm (afaik) not using any where-clause.
Posting it on the for...
Exception throw by db reader
Hi. Just installed the RedGate tool set and trying to get it to work. I'm trying to compare 2 databases (1 on a 2000 server, 1 on a 2005-server). I'v connected to the 2 servers where the databases ...
Hi. Just installed the RedGate tool set and trying to get it to work. I'm trying to compare 2 databases (1 on a 2000 server, 1 on a 2005-server). I'v connected to the 2 servers where the databases reside, picked a few tables (to test the tools), configured the key fields in each table (wish there was an easier option for that: do i really need to tell Data Compare for each table what the key field(s) is (are)?).
When i press compare, i get a green tag next to Registering databases and Mapping, but when at 'Comparing databases', i get "Exception throw by db reader 2".
In my case msdb is not involved (or am i missing something :-)?), so is my error message similar/related to this thread and do i have to wait for Data Compare 8, and if so, what causes this error?
Or is there another reason i'm getting this error-message? I've searched for the error, but could not find any other related message on the forum.
(Update: just found http://www.red-gate.com/supportcenter/C ... wledgebase\SQL_Data_Compare\KB200903000364.htm . I'm using version 7. But i am simply selecting tables to compare. I'm not adding where-clauses.)
Thanks! / comments
Hi. Just installed the RedGate tool set and trying to get it to work. I'm trying to compare 2 databases (1 on a 2000 server, 1 on a 2005-server). I'v connected to the 2 servers where the databases ...