December 24, 2014 at 1:37 pm
In a nutshell, I'm trying to copy a DB from a 2005 version of SQL to the 2014 version (on different servers) using the Copy DB wizard. I'm hitting what seems to be compatibility issues i.e. can't backdate the compatibility of the 2014 DB to any earlier than 2008.
Does anyone know if there is a workaround to this problem?
Thanks in anticipation.
December 25, 2014 at 10:50 pm
jgdil01 (12/24/2014)
In a nutshell, I'm trying to copy a DB from a 2005 version of SQL to the 2014 version (on different servers) using the Copy DB wizard. I'm hitting what seems to be compatibility issues i.e. can't backdate the compatibility of the 2014 DB to any earlier than 2008.Does anyone know if there is a workaround to this problem?
Thanks in anticipation.
Quick thought, normally one can work with three versions, current and two earlier, for 2014 that would be 2008,2012 and 2014. In order to reach 2005, one has to use either 2012 or 2008 as an "intermediate stop".
😎
December 27, 2014 at 7:14 am
Just my 2 cents worth - recently I was tasked with copying a database from 2000 to 2014 and used the same technique as described above. I was able to go from 2000 to 2008 R2 and then from 2008 R2 to 2014 after making some minor adjustments.
Petr
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply