+1 for this solution which got demo'd at SQL in the City last week. Your best bet would be to speak to the guys and girls at Redgate (they're fantastic and very helpful), they'll be able to guide you through recommendations regarding your needs and what the solution(s) can do for you. I've been very impressed with their products to date so recommend them 100%.

Give them a call and have a chat.