I have a production DB and a dev DB. I'd like SOME of the Dev DB changes to be propagated to the Production DB. The production DB also has some new columns and changes due to bug fixing. I need a Scema Compare Tool that allows for acccepting/deniyng changes at the column level.
Red Gate SQL Compare 9, can't seem edit changes at the column level either.
I suspect I'll have to manually modify the update script generated?
What is a recommended way to deal with this? Thanks.