How to find out missing Stored Procedures comparing of two databases

• ashish.rajguru

  SSC Enthusiast

  Points: 194

  More actions

  September 12, 2008 at 9:43 am

  #192748

  Hello All

  I want to know that how to write query which finds out missing stored procedures as well as tables, comparing two databases.

  thank you

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  September 12, 2008 at 10:03 am

  #871116

  Pardon me but this sounds like a homework problem. One option look at REDGATE Software's product at:

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

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  September 12, 2008 at 10:05 am

  #871119

  Also search this site for "compare databases" or "database comparison". I know I've seen numerous discussions about this.

  Greg