Can SQL Compare and Data Compare be used to efficiently downgrade a SQL database from 2008 R2 to 2008?
I'm searching to help a client who upgraded and didn't fully test. A few of the downgrade articles mentioned using Redgate tools. I've browsed the documentation and it seems like it might, but I would like confirmation.
Thank you for any comments or advice.