Compair table structure of two databases

• Shahzadi

  Default port

  Points: 1479

  More actions

  February 7, 2008 at 10:40 am

  #378423

  Hi,

  i have two different databases, i want to compaire the tables of these databases if any thing has on database 1 with respet to database 2 changed or any colume is added into one database. is there any way, or procedure or script to do this thing

  thanks and looking forward.

  -MALIK

• Loner

  SSC-Insane

  Points: 21279

  More actions

  February 7, 2008 at 12:48 pm

  #776148

  There are many tools to do that. One from RedGate called SQL compare. It is pretty good.

  Do I get commission for selling/promoting Redgate software, Steve?:D

• Adam Bean

  One Orange Chip

  Points: 26631

  More actions

  February 7, 2008 at 1:42 pm

  #776172

  Another vote for RedGate's SQL Compare. By far the best production out there for comparison and synchronization.