Tables or views that could not br compared

fabriciolima

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?

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

fabriciolima

Thanks.

The problem is to do that to two hundred table.

Mark J

Ah, I see. I don't think we have an easy way of doing that at the moment

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

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.