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. >>> >>> Thanks >>> Kevin >>> >> >> >
