Hi All I have a client that upgraded a database from 2008 to 2008 R2. It took a while, but eventually their primary application proved to be incompatible. They get a fail because they didn't read the compatibility guide and didn't adequately test. But that is why they are now a client.
I know you can't restore to an older version. I've found a few references to using Enterprise Manager "Generate Scripts" with some advanced options. I've tested on some simple databases. Has anyone done this on a fairly large complex database? Aware of any constraints, issues, etc? How about alternative methods or tools? I've seen a couple of references to using Redgate tools - I have a call into them. Thanks Kevin
