Database Change Manager Compare

• Olivera Fernando

  Newbie

  Points: 8

  More actions

  July 29, 2004 at 3:34 pm

  #86264

  I have the Following to compare Schema/permissions etc from One DB to Another Can anyone suggest which is the one which is Cost Effective ?/

   

  SQLDBCompare

  and SQLSourceSafe from BestSoftTool

  <http://www.bestsofttool.com/SQLDBCompare/SDC_Introduction.aspx&gt;

   

  SQLDiff

  from APEX

  <http://www.apexsql.com/sql_tools_diff.htm&gt;

   

  DBGhost

  from Innovartis

  <http://www.innovartis.co.uk/DBGhostProcess.asp&gt;

   

  SQLCompare

  from Red-Gate

  <http://www.red-gate.com/sql/summary.htm&gt;

   

  Change Manager

  from Embarcadero

  http://www.embarcadero.com/products/changemanager/index.html

   

  TIA

• Arvind-57714

  SSCrazy

  Points: 2529

  More actions

  July 30, 2004 at 12:45 am

  #516913

  Well I really dont know how expensive the other products are....But i used the evaluation copy of SQL Compare form RED GATE and really liked it. And subsequently bought it as well...Its really a good tool for any DBA.

  So i wud suggest you to go ahead and try it out...has a 14 day evaluation period.

  Cheers!

  
  Arvind

• Jason Hall

  Hall of Fame

  Points: 3906

  More actions

  July 30, 2004 at 11:16 am

  #517083

  One product that you do not have listed but deserves a try is Imceda Softwares Change Manager.  Change manager has an extremely intuitive and easy to use interface as well as the most flexibility in terms of rollback options as well as safety warnings. 

  Change manager will both compare database schema's, generate modifiable change scripts, and execute changes.  Everything in change manager is color coded and explicitly stated for ease of use. 

   

  Change manager sounds like exactly what you are looking for.  Check out http://www.imceda.com to try it out.

• Olivera Fernando

  Newbie

  Points: 8

  More actions

  August 2, 2004 at 9:12 am

  #517284

  Thanks all