Moving the Postmark Scan and Mailman Databases

Moving the Postmark Scan and Postmaster Databases

Updated November 1, 2023

SQL Requirement: Microsoft SQL Server 2016 or later (must run in compatibility level 130 or greater)

NOTE: For legacy KwikTag v5.4.1 and Postmark Platforms v2.5.0 and older the SQL database is called "KwikTag". The v2.6.0 and newer database was renamed to "PostmarkMaster". The Mailman Database is “Postmaster”

Moving a Database

1. Backup the existing database
2. On the new SQL Server
   1. Create an SQL Account (the name and password must match what is on the current database server) or add the Postmark Domain Service Account. The account must be a minimum of “DBO” on the Postmark Scan Database (KwikTag or PostmarkMaster and Postmaster).
3. Restore the backup to the new SQL Server

Run SQL Script

1. Copy the Rename Script below into a SQL Query Window on the new SQL Server
2. Make the following edits, (find and replace)
   1. Replace {DbServerName} with the new SQL Server name
      1. If there is an instance name, it must be included i.e., NewServer\InstanceName

Rename Script

USE [PostmarkMaster]

--USE [KwikTag]

UPDATE tblOrg

SET ServerName = '{DbServerName}',

DocSearchServer = '{DbServerName}',

DocJobServer = '{DbServerName}',

QueueServer = '{DbServerName}',

FulfillmentServer = '{DbServerName}',

KustomerServiceServer = '{DbServerName}',

WHERE OrgID = -900

UPDATE tblOrganization

SET ServerName = '{DbServerName}',

DocSearchServer = '{DbServerName}'

WHERE OrgID = -900

UPDATE tblImageTag SET ServerName = '{DbServerName}'

Update the Postmark Application Server Configuration

NOTE: All changes below assume that, if used, the Postmark Scan SQL Account, and Password have not changed. Please contact support@docsolid.com if you also intend to change the SQL Account. Depending on the version of Postmark that is installed, some of the websites listed may not be included on your server.

1. Open Internet Information Service (IIS) Manager
2. Expand down to the list of websites, below the “Default Web Site”
3. Select “APIV2”
   1. Open “Application Settings”
      1. Edit “pmkDbString” (dbstr)
         1. Change the “Data Source” to the new SQL location
4. Right Click on “APIV3
   1. Select “Explore”
      1. Open “appsettings.json”
         1. Edit “DefaultConection”
            1. Change “Data Source” to the new SQL location
         2. Save the file
5. Select “PMKSAPI’
   1. Open “Connection Strings”
      1. Edit “KTConnection”
         1. Change the “Data Source” to the new SQL location
6. Select “PMKSCCAPI”
   1. Open “Application Settings”
      1. Open “pmkDbString”
         1. Edit “pmkDbString” (dbstr)
            1. Change the “Data Source” to the new SQL location
7. Select “PMKSClient
   1. Open “Connection Strings”
      1. Edit “ApplicationServices”
         1. Change the “data source” to the new SQL location
8. Select “PMKSPrivateAPI”
   1. Open “Connection Strings”
      1. Edit “KTConnection”
         1. Change the “Data Source” to the new SQL location
9. Select “PostmarkScanWS”
   1. Open “ApplicationServices”
      1. Edit “pmkDbString”(dbstr)
         1. Change the “Data Source” to the new SQL location
10. Select “PostmasterWeb”
    1. Open “Connection Strings”
       1. Edit “PostmasterContext”
          1. Change the “Data Source” to the new SQL location
11. Select “PostmasterWebApi”
    1. Open “Connection Strings”
       1. Edit “PostmasterContext”
          1. Change the “Data Source” to the new SQL location
12. Restart IIS

Change Windows Services Configuration on the Postmark Application Server

1. Open Windows Explorer and navigate to, depending on the Postmark version
   1. {installDrive}:\Program Files\DocSolid\Postmark Scan\Windows Services
   2. {installDrive}:\Program Files (x86)\DocSolid\Postmark Scan\Windows Services
   3. {installDrive}:\Program Files (x86)\KwikTag \Windows Services
2. Edit “KTNotificationService.exe.config”
   1. Change “connectionStrings”
      1. “connectionString=”Data source=” to the new SQL location
   2. Save the file
3. Open Windows Service
   1. Depending on your version of Postmark
      1. Restart “KwikTag Notification Service
      2. Restart “Postmark Scan Notification Service