How to move PassagePont's backend SQL DB to a new SQL server

How to move PassagePont's backend SQL DB to a new SQL server

To move PassagePoint to a new SQL server:

1) Do a full backup of the passagepoint DB on the current SQL server 

if you don't know which SQL server or what DB it is, see here:
https://support.stopware.com/portal/en/kb/articles/what-backend-database-am-i-running

2) Restore the backup on the new SQL server

if using SQL authentication, have SQL DBA 

1) create user/password on new SQL server with DBO rights
      - get new SQL server, username, password  from DBA

2) update SQL context file with info from above

To encrypt the password see here:
https://support.stopware.com/portal/en/kb/articles/how-to-encrypt-the-sql-server-password-in-the-sqlcontext-xml-file






If using windows Authentication, have DBA assign windows user to the new DB and assign DBO rights

With windows authentication, the user is found in the services tab