Hmm, hadn't seen that one.
On Fri, Dec 13, 2013 at 4:16 PM, Christopher Bodnar < [email protected]> wrote: > How about this? > > > http://yrushka.com/index.php/database-recovery/restore-sql-2008-r2-database-on-sql-2008-sp1-instance/ > > > *Christopher Bodnar* > Enterprise Architect I, Corporate Office of Technology:Enterprise > Architecture and Engineering Services Tel 610-807-6459 > 3900 Burgess Place, Bethlehem, PA 18017 > [email protected] > > > > * The Guardian Life Insurance Company of America* > > *www.guardianlife.com* <http://www.guardianlife.com/> > > > > > > > From: Kevin Lundy <[email protected]> > To: "[email protected]" <[email protected]> > Date: 12/13/2013 03:27 PM > Subject: [NTSysADM] SQL Gurus - migrate to a lower version > Sent by: [email protected] > ------------------------------ > > > > 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 > ----------------------------------------- This message, and any > attachments to it, may contain information that is privileged, > confidential, and exempt from disclosure under applicable law. If the > reader of this message is not the intended recipient, you are notified that > any use, dissemination, distribution, copying, or communication of this > message is strictly prohibited. If you have received this message in error, > please notify the sender immediately by return e-mail and delete the > message and any attachments. Thank you.
<<image/jpeg>>
