We've been using Red Gate for quite some time now (maybe forever now that I think about it) and it is a product that I use almost daily. We are a software vendor and have to create custom upgrades for our customers to upgrade their versions. When I say custom, I mean that each client that needs to upgrade their system must have a script created that is tailored to their database as our customers can be at any version and patch level in our development tree and have to get to the destination version.
We have been using Red Gate to create the synchronization script, but it always (and I mean always) requires manual tweaking for data conversions and the like prior to sending to a customer site. Red Gate works great for as a Diff tool, but we are very excited about what DBGhost can do. I downloaded a trial license many months ago to do some ‘proof of concept’ testing on automating our upgrades and I was extremely pleased with the results. We will be getting a second trial here very soon to document the ‘proof’ for the $$ spenders here to approve the product.
I think it is in everyone’s best interest to at least review the DBGhost web-site and take a look at the capabilities that their product has. I originally found the DBGhost product from an article here at SSC that if I remember correctly was a product trial testimonial for Red Gate or one of the other big dogs. The author briefly mentioned DBGhost and I searched the web and found their site. I plan on using their entire product suite and I think it all will add much value to our operation as well as free up more DBA resources to concentrate on other tasks.
BTW… We are using MKS for our source control.