Question about recent updates
eklein@ahd.com
Posts: 17 Bronze 2
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 ?
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 ?
Comments
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
Product Manager
Redgate Software