They upgraded SQL, or the OS, or both? There are no pre-upgrade db backups?
I must be missing something. (Not at all unusual...) On Fri, Dec 13, 2013 at 3:25 PM, Kevin Lundy <[email protected]> wrote: > 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 >
