There is a new comment on your post!
If this comment helps you, consider marking it as best reply.
AC

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

by Runé Becker
Badge for 'Mastermind' achievement
Posted on Tue, 05/08/2018 - 09:11

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

0
by Deleted User Author
Posted on Wed, 05/09/2018 - 14:37

In reply to by rbe

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

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock