Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    Montreal, Canada
    Posts
    151

    Unanswered: 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.

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245

    Re: Comparing Column names and indexes

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •