Sounds like you may be in for some more surprises when you get onsite! Good luck I hope some one was keeping track of what they tried and what they did but it does not sound promising so you may get to bill a lot of hours on this. Jon Date: Fri, 13 Dec 2013 18:21:44 -0500 Subject: Re: [NTSysADM] SQL Gurus - migrate to a lower version From: [email protected] To: [email protected]
You know, that is another good idea. Restore the old 2008, truncate and export/import. Another option. Thanks for the idea. On Fri, Dec 13, 2013 at 6:15 PM, Jeff Steward <[email protected]> wrote: I figured as much, but since it was an easy step, it was worth a shot. I've done massive schema compares and merges for ERP databases, but not data at the scope you are dealing with. The RedGate tools are good, but may choke for any large database unless you run them table by table, and even then.... One suggestion would be to restore a copy of the old 2008 version database, truncate all the tables and then use the SQL Import or Export data wizard to migrate the data from the 2008 R2 version ...or have fun with BCP :) Good luck and happy billing! -Jeff On Fri, Dec 13, 2013 at 5:49 PM, Kevin Lundy <[email protected]> wrote: Yes. That doesn't really help - the COTS vendor won't provide support for R2. It's a somewhat old version and they are trying to get the customer to upgrade. In fact the application is already on extended support - but only on SQL 2005 or 2008. They have already done some things to try to move it back - I arrive on site Monday to see what those "some" things are and see if we can complete it. On Fri, Dec 13, 2013 at 5:29 PM, Jeff Steward <[email protected]> wrote: Have you tried setting the compatibility level of the database to 2008? http://technet.microsoft.com/en-us/library/bb933794.aspx -Jeff 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. ThanksKevin
