Tuesday, March 20, 2012

Comparing Column names and indexes

Is there a way to compare tables in 2 different databases to find out if they have the same indexes and column names and keys. Or maybe a tool i dont know about.Again, not sure if this violates the non-commercial nature of this forum, but I use a product called SQL Compare from Red gate Software, Ltd. (www.red-gate.com).

It's definitely worth the price. It will do exactly what you are looking for, plus much more.

Regards,

hmscott

No comments:

Post a Comment