• I'm with Jeff. I work for Red Gate and heard great things about SQL Compare (haven't used it).

    However my process is here: http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/vcspart4/526/

    That's part 4, go backwards to part 1