How can we help you today? How can we help you today?

Tables or views that could not br compared

Hi everyone,

I am using SQL DATA COMPARE to confirm that my import/export migration of data between two databases are ok.

After executing the comparison, I receive this message for a lot of table:

200 Tables or views that could not br compared

Open one of this table, the problem é that the table don't have a PK or a clustered index. Then i need to manualy choose one index to the Redgate tool compare this table.

It's not possible that the tool compare the table register without a PK or clustered index?
fabriciolima
0

Comments

5 comments

Sort by
  • Mark J
    When tables don't have a primary key or unique constraint, Data Compare won't choose a comparison key by default (since the likelihood of getting it wrong is pretty high) -- however, you can choose the comparison key yourself: http://documentation.red-gate.com/displ ... e+compared
    Mark J
    0
  • fabriciolima
    Thanks.

    The problem is to do that to two hundred table.
    fabriciolima
    0
  • Mark J
    Ah, I see. I don't think we have an easy way of doing that at the moment
    Mark J
    0
  • gatif
    After an update to 3.8.4.662 a number of old Migration scripts are showing as uncommitted. I have tried undo changes but the scripts remain as uncommitted. Can anyone help solve this. I am contenting to TFS 2013

    Thanks

    Steven Evans
    gatif
    0
  • ed-rod
    The only way I can confirm import into my data-flow is by using a Datareader connection manager using the ODBC Data Provider. My DSN is using the Oracle ODBC driver.
    ed-rod
    0

Add comment

Please sign in to leave a comment.