Migrate Aris 7.2 Publisher and Designer databases from SQL 2008 to SQL 2016

Dear Marcel,

Why would you want to migrate to MS SQL Server 2016 for such an old ARIS version which supported at the time of its release MS SQL Server 2008.

If IT policies force you to replace the old MS SQL Server version I would rather put the whole environment into a VM including its old OS, probably Windows Server 2008.

Cheers

Rune

Hi Rune, thanks for your reply. We have to decommission all our SQL versions up to 2012 a.s.a.p. and after that we have to say goodbye to W2K8, so a vm with this version is not possible.

I think i will take the following steps to migrate the databases to a new sql server:

backup database and restore on new server.

Create same account on new sql server and give it DB Owner permissions an SA and change the database locations in "lockservice.cfg" and "businesspublisher.xml".

Regards Marcel