Hello Community,
I still have Aris 7.2 Publisher and Designer connecting to on a old SQL Server.
I have to migrate the Aris databases from this old SQL server to SQL Server 2016.
What is the best way to do this?
Backup database on old SQL Server and do a restore on the new SQL Server 2016 and change the database locations in "lockservice.cfg" and "businesspublisher.xml".
And what is the best way to create the database user with the same permissions on the database on the new SQL Server 2016 ? Is there a tool for this?
I hope you can help me.
Thanks
Marcel
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