Applying incremental updates

• martincross

  SSC Eights!

  Points: 893

  More actions

  March 30, 2004 at 2:48 am

  #163318

  Is there a way of taking Database Version 1, comparing it against Database Version 2 and automatically applying the differences to make Version 1 become the same schema as Version 2?

  I'm assuming there's nothing supplied with SQL to do this, but is there a third party tool that can do this?

   

  Thanks

  Martin.

• hot2use

  SSCrazy

  Points: 2915

  More actions

  March 30, 2004 at 4:18 am

  #501033

  Try this one for starters.

  Has some other great SQL Tools.

  http://www.red-gate.com/SQL_Compare.htm

  🙂

  
  __________________________________
  Searching the KB articles is like
  picking your nose. You never know
  what you'll find.
  

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736494

  More actions

  March 30, 2004 at 10:55 am

  #501115

  There are a few tools, AdeptSQL has one, RedGate another.

  http://www.sqlservercentral.com/columnists/awarren/sqlcomparereview.asp

  http://www.sqlservercentral.com/columnists/chedgate/reviewofsqldiffbylockwood.asp

  http://www.sqlservercentral.com/columnists/rmarda/reviewofsqlcomparev3.asp