need to create process for db compare after migration

• BaldingLoopMan

  SSCertifiable

  Points: 6378

  More actions

  August 10, 2010 at 11:47 am

  #224496

  Anyone have any advice here. i need to create a process to compare the differences between our different environments (dev, qa, stage, prod) after each migration. All using sql server 2005 and beyond. Currently using redgate. Can the redgate db compare be scripted? Know of any other useful tools to provide this? Should i just do it using sql and linked sever? Ideas?

• Grant Fritchey

  SSC Guru

  Points: 398898

  More actions

  August 10, 2010 at 12:38 pm

  #1204978

  Red Gate SQL Compare Pro comes with a command line utility. It can be completely automated.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning