Symptoms
Are there any documentations on moving K2 unconsolidated databases hosted in SQL Server 2008 R2 instances to SQL Server 2012 instance?
Diagnoses
NA
Resolution
1. Backing up of keys and certificates are documented (http://help.k2.com/onlinehelp/k2blackpearl/icg/4.6.6/webframe.html#backing_up_keys_and_certificates.html),
2. Remember to install and configure the MSDTC component on the new database server: http://help.k2.com/onlinehelp/K2blackpearl/ICG/current/webframe.html#MSDTC.html
3. Firewall ports: http://help.k2.com/kb001318#
4. Give db_creator and securityadmin rights to installer account in new SQL Server. Also make sure Service account is the DBOwner for K2 database. If you have 14 databases then this will need to be done on each K2 database.
5. Check the DB Compatibility level. Always choose the latest compatibility available (eg. 2005 ?andgt 2012)
6. Make sure the SQL collation is correct as well. Latin1_General_CI_AS is the only supported collation, but the most important thing here is the collation must be CI (Case Insensitive). Remember to make a cross check in both DB Collation and SQL Server collation.
http://help.k2.com/onlinehelp/K2blackpearl/ICG/current/default.htm#TipsPractices.htm
7. Perform the steps on the KB article Scenario 4, Existing (in-place) K2 server configuration with moved database: http://help.k2.com/kb001356#Scenario4
