Knowledgebase: PaperCut
Papercut External Database Migration
Posted by Matthew Ryan, Last modified by Zak Devlin on 11 October 2017 10:22 AM
Pre migration steps
1) Ensure the current implementation using the internal database is functioning correctly with no reported issues.
2) Backup Papercut from the admin console | Options Tab | Backup Tab | Export Now button. Rename backup to , this avoids typo's in later steps then copy it to the root of C drive E.G C:\ for simplicity in later steps. You can find the backup in the "./papercut mf/server/data/backups/" folder 

Migration process
1) Stop Papercut services on the server
2) Open the file ./papercut MF/server/ This file contains your database connection settings, and admin password, etc. Update the file appropriately by remarking out the internal DB and unremarking the external DB such as SQL. You will need to add the SQL server name and database name, the sql username and password for this database.
### Database Settings ####

# database.type=Internal

# MS SQLServer connection example
# IMPORTANT: The username below is a SQL Server user, not a Windows user.
3) Save the file file
Restore backup on server
1) Stop Papercut services on server
2) From the command prompt .\Papercut mf\server\bin\win perform the following commands
3) db-tools init-db -f
4) db-tools import-db -f "C:\" 
5) Restart Papercut services
6) Logon to admin console.

 Papercut KB Links:

Configuring Microsoft SQL Server

Configuring Microsoft SQL Server Express

(3 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name: