If the Compatibility Mode for the DB was not changed, then generate scripts should work fine.
From: [email protected] [mailto:[email protected]] On Behalf Of Kevin Lundy Sent: Friday, December 13, 2013 3:26 PM To: [email protected] Subject: [NTSysADM] SQL Gurus - migrate to a lower version 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
