November Happy Hour will be moved to Thursday December 5th.

Migrating from SQL Server 2005 to 2008

Vote:
 

Hi, are there any issues or things we should look out for when migrating our CMS 6 / Community 4 sites from SQL Server 2005 to 2008? Does anyone know of any documentation available on this?

 

Cheers

Tim

#47528
Jan 31, 2011 17:28
Vote:
 

Hi Tim,

we've had the pleasure of upgrading a CMS6 site from 2005 to 2008 (by accident really) and haven't really experienced any problems in that regard. The only thing i've noticed is that the database-compatibility version will be retained to 2005 and I've never tried changing that - nor has it caused any problems leaving it as it is. But i guess it might become a problem in the future - when Microsoft creates a new feature in SQL Server which episerver starts using. - which requires a comparability-upgrade.

#47545
Feb 02, 2011 8:31
Vote:
 

There should be no problem migrating from SQL 2005 to 2008 as long as you keep the compatibility version set for 2005 (as Shamrez mentions). EPiServer does nothing wacky with the databases so its a simple question of SQL 2008 backward compatibility.

We've recently migrated a large site from 2005 to 2008 R2 on 64-bit with zero issues.

 

#47568
Feb 02, 2011 20:19
Vote:
 

Cheers guys, much appreciated

#47623
Feb 04, 2011 18:24
This thread is locked and should be used for reference only. Please use the Episerver CMS 7 and earlier versions forum to open new discussions.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.