Any utility available in SQL 2008 like tablediff in SQL 2005?

• Sayali Prabhakar

  SSC Rookie

  Points: 35

  More actions

  September 3, 2009 at 6:08 pm

  #210407

  Hi,

  Our scenario is -

  Few tables from Server A are replicated on Server B. I used to use 'tablediff' in SQL 2005 to compare data and schema of these tables.

  Is there any tool / utility in SQL 2008 Enterprise to execte / automate the task ?

  Appreciate any guideline in this regards..

  Thanks and Regards,

  Sayali

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  September 4, 2009 at 8:00 am

  #1049387

  tablediff is still available in 2008 so you should be able to use the same process.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• Sayali Prabhakar

  SSC Rookie

  Points: 35

  More actions

  September 4, 2009 at 11:18 am

  #1049540

  Thanks Jack !!

  Can you please point me to standard path where it resides ?

• Sayali Prabhakar

  SSC Rookie

  Points: 35

  More actions

  September 4, 2009 at 11:30 am

  #1049548

  Got it 🙂

  at :\Program Files\Microsoft SQL Server\100\COM

• skeezwiz

  SSC Eights!

  Points: 896

  More actions

  November 30, 2009 at 8:41 pm

  #1085623

  tablediff is installed only if you have the replication components installed.