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

Last activity on October 1, 2023 - 11:21 5.4k Views 2 Replies Administration & User Management

Deleted User on May 3, 2018

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

Tags: #arisbusinesspublisher; #configuration

Bookmark

Notify Moderator

2 Replies

Runé Becker on May 8, 2018

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

Like

Sign in
or register to reply.

Notify Moderator
AC

Deleted User Author on May 9, 2018 as Reply to Runé Becker

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

Like

Sign in
or register to reply.

Notify Moderator

There are currently no upcoming events.