Question about recent updates

Several years ago I looked at Sql Data Compare (V5 i think). I was impressed with the product, but several limitations prevented me from purchasing. It appears that several of my concerns have been addressed, but I'm not sure about the one. Thanks for your time

Issue I'm still not sure about

Can it compare tables that have similar, but not identical schema's for example identical index structures, but non-index fields have been added, deleted or changed.

From what I've read it looks like you can now compare two tables with different names and they can be in the same database. Is that correct ?

eklein March 05, 2009 11:21

Comments

1 comment

The following chart displays the data types that SQL Data Compare can match up:
http://www.red-gate.com/support/SQL_Dat ... atypes.gif

If the table names are different, you can manually map them:
http://www.red-gate.com/supportcenter/C ... c43727.htm

Yes, they can be in the same database. You simply compare the database to itself, unmap the tables you wish to compare, re-map appropriately.

Please give this a go and let us know if you come across any issues.

Kind regards,

David Atkinson
Red Gate Software

David Atkinson March 05, 2009 12:56

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Question about recent updates

Comments

Add comment