Migrate Database ManagedEngine from SQL Server 2012 to 2016

Migrate Database ManagedEngine from SQL Server 2012 to 2016

Hi Guys,

i have an existing manageengine system using the SQL Server 2012, and i have to migrate the version of SQL Server 2016, and change the user policy, so in the existing system, i use user 'sa' to connect SQL Server 2012 which using for manage engine database, and now i have to migrate this database from SQL Server 2012 to my new database server which is SQL Server 2016, using the new user to connect, such as 'helpdesk'.

The plan is :
1. Shutdown the service of ManageEnginePlus on windows,
2. Full Backup the database from SQL Server 2012
3. Restore the backup into SQL Server 2016
4. Configure the ManageEngine database using changeDBServer.bat connect to new hostname, new user, and new port
5. Done

Is it okay to follow the above steps? or any better idea to migrate it?

Thanks,
Yoga
                New to ADManager Plus?

                  New to ADSelfService Plus?