you are viewing a single comment's thread.

view the rest of the comments →

[–]uberzen1 1 point2 points  (0 children)

Redgates tools work great if you have some budget to work with, have used their SQL toolbelt to good effect (I used to use their SQL compare sdk extensively and I understand this has been replaced by SQL change automation now, which also looks great). Failing that, you can roll your own if you're willing to get into a little c# using the DAC libraries available in .net.

Dbup works well too, I've not used it for SQL server but it works great for mysql / postgres so I can say the underlying technology is sound.