Migration IMC 7.2 with deported database to 7.3 with local database

[Thomas59]

Hello,

Since Windows 2016 is included in the list of Prerequisites / server requirements of IMC 7.2, 
I would like to know, what is the best way to migrate this environment : 
IMC 7.2 installed on Windows 2012 with deported SQL server 2008R2
to the futur environment
IMC 7.3 install on Windows 2016 with a local SQL server 2016 express

Some of you already have done this ?

[jguse]

Hello,

Can you please specify which exact version you are running at the moment? For example 7.2 E0403 or some other version - as I am a bit confused by your statement that Windows Server 2016 is in the list of prerequisites for 7.2? Server 2016 support was only added in iMC 7.3 E0605 version onwards.

If you are running 7.2 on Server 2012 with SQL 2007 R2, you have a number of steps to get migrated to the latest version (7.3 E0705P06) with Server and SQL 2016. This would first involve incrementally upgrading your installation to 7.3 E0605 - the last version to support Server 2008, and first version to support 2016 - and then migrating according to the Migration Guide. Once you have migrated to the new system on E0605, you can upgrade to E0705 and then E0705P06.

[thomas599]

Hello Justin,
" Can you please specify which exact version you are running at the moment? For example 7.2 E0403 or some other version - as I am a bit confused by your statement that Windows Server 2016 is in the list of prerequisites for 7.2? Server 2016 support was only added in iMC 7.3 E0605 version onwards. " 
=> You absolutly right, I was in a rush I didn't re-read my post, my mistake I wanted to say " Since Windows Server 2016 is NOT the list of prerequisites for 7.2.


" This would first involve incrementally upgrading your installation to 7.3 E0605 - the last version to support Server 2008, and first version to support 2016 - and then migrating according to the Migration Guide. Once you have migrated to the new system on E0605, you can upgrade to E0705 and then E0705P06." 
=> Thank you for guiding me, I will try this steps. Just a last question. Since this is a big upgrade, between 7.2 and 7.3 / SQL 2008 and 2016. will there be additional steps to make the database from 2008 to 2016 compatible ? Or IMC uses the same bases between these versions. 

Thanks. 

[jguse · Accepted solution]

Hello,

Thanks for the clarifications. iMC uses the same databases regardless of MSSQL Server version, and you can always migrate from an older SQL version to a newer one (the opposite is not recommended). When you restore an iMC DBMAN Backup taken from an iMC with older MSSQL version to a newer one, eg. 2008 to 2016, the databases will be upgraded automatically when restoring.

So for you the process would look like:

1) Upgrade iMC from 7.2 E0403 to 7.3 E0605 incrementally, as indicated by the respective Release Notes. This essentially means you need to upgrade E0403 -> 7.3 E0506 -> 7.3 E0605 first. Keep in mind the known issues, especially the SSL Cipher issue: https://support.hpe.com/hpesc/public/docDisplay?docId=c05353856&docLocale=en_US

Note that you can use the MSKBsC.exe from E0605 tools folder to detect and automatically remove the affected SSL ciphers from your server if they are present. Make sure it's from E0605 because that's the latest version of MSKBsC tool, prior versions did not support automatic removal.

2) Start up iMC on E0605 to make sure it's operational, and then perform the backup, new system setup, and restore, following all steps documented in the iMC Migration Guide: https://support.hpe.com/hpsc/doc/public/display?docId=emr_na-a00038008en_us&docLocale=en_US

3) Verify the migration was successful, then upgrade E0605 -> E0705 -> E0705P06.

In case you have any optional Modules, you'll need to upgrade those to a compatible version after upgrading the platform at every step of the way.

Hope that helps you to perform a smooth migration.