I've seen the Red Gate SQL Tools used in the past, but not tried them myself until today, when I ventured into SQL Compare and SQL Data Compare. My word, these are good. Really, really good. Not only do they do their job well, but they are exceedingly simple to use; easy wizards and simple screens showing you what is to be compared and trasnferred. I can't believe I've never had these before. Shame on me. And shame on you if you haven't looked at them. Go on, do it now. You won't regret it.