compare and update databases

• shakti-236987

  SSC-Addicted

  Points: 498

  More actions

  June 10, 2005 at 5:44 am

  #87911

  How can i compare the databases of SQL server 7.  Comparison pertaining to table names and table structures and views is required. 

  Also is there any way by which i can update the database based on comparison.

• BillMinton

  SSC-Addicted

  Points: 452

  More actions

  June 10, 2005 at 7:32 am

  #564581

  SQLCompare

  It's a utility by Red-Gate software, and works very well.