[NTSysADM] SQL Gurus - migrate to a lower version

2013-12-13 Thread Kevin Lundy
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

Re: [NTSysADM] SQL Gurus - migrate to a lower version

2013-12-13 Thread Kevin Lundy
Upgraded SQL. Yes, there are pre-upgrade backups. However it was weeks of use before they tried a function that was incompatible. So if we revert to the backups, they lose weeks of work. On Fri, Dec 13, 2013 at 3:31 PM, Richard Stovall rich...@gmail.com wrote: They upgraded SQL, or the OS,

RE: [NTSysADM] SQL Gurus - migrate to a lower version

2013-12-13 Thread Jeff Frantz
@lists.myITforum.com 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

RE: [NTSysADM] SQL Gurus - migrate to a lower version

2013-12-13 Thread Michael B. Smith
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

Re: [NTSysADM] SQL Gurus - migrate to a lower version

2013-12-13 Thread Christopher Bodnar
, PA 18017 christopher_bod...@glic.com The Guardian Life Insurance Company of America www.guardianlife.com From: Kevin Lundy klu...@gmail.com To: NTSysADM@lists.myITforum.com NTSysADM@lists.myitforum.com Date: 12/13/2013 03:27 PM Subject:[NTSysADM] SQL Gurus - migrate

Re: [NTSysADM] SQL Gurus - migrate to a lower version

2013-12-13 Thread Kevin Lundy
klu...@gmail.com To:NTSysADM@lists.myITforum.com NTSysADM@lists.myitforum.com Date:12/13/2013 03:27 PM Subject:[NTSysADM] SQL Gurus - migrate to a lower version Sent by:listsad...@lists.myitforum.com -- Hi All I have a client

Re: [NTSysADM] SQL Gurus - migrate to a lower version

2013-12-13 Thread Jeff Steward
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 klu...@gmail.com wrote: Hi All I have a client that upgraded a database from 2008 to 2008 R2. It took a

Re: [NTSysADM] SQL Gurus - migrate to a lower version

2013-12-13 Thread Kevin Lundy
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

Re: [NTSysADM] SQL Gurus - migrate to a lower version

2013-12-13 Thread Kevin Lundy
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 jstew...@gmail.com wrote: I figured as much, but since it was an easy step, it was worth a shot. I've done massive

RE: [NTSysADM] SQL Gurus - migrate to a lower version

2013-12-13 Thread Jon Harris
: [NTSysADM] SQL Gurus - migrate to a lower version From: klu...@gmail.com To: ntsysadm@lists.myitforum.com 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 jstew...@gmail.com