Migrate Data Source to SQL Server

Migrate Data Source to SQL Server

To migrate to SQL:  

1.    Have SQL DBA create a clean database on SQL Server.  Have DBA create a user with DBO rights to the database, and get the username/password (SQL authentication) from the DBA (database administrator).  

2.    In Database tools => select Migrate data source  (see screenshot below)

3.    Set the JDBC Target Data Source Configuration (modify to reflect your SQL name, and DB):  
String with SQL instance:         jdbc:sqlserver://sql2014\sqlexpress;databaseName=ppglobal-migration  
String with NO SQL instance:           jdbc:sqlserver://sql2014;databaseName=ppglobal-migration  

4.    Select the "Test" button. You should see the "checking...." message.  

5.    Then select the “Migrate” button.      

6.    Have DBA check the database to make sure the schema is created and data is present.      

7)  Modify sqlcontext.xml to point to the new SQL server DB. see KB below:

8. Restart the PassagePoint service.



    • Related Articles

    • How do I move PassagePoint global to a different server?

      How do I move PassagePoint Global to a different server? Source Machine = Production server is the customer's server that contains the PassagePoint Global “config” folder and database Destination Machine = New server for the PassagePoint Global ...

    • How to connect to Microsoft SQL database and encyrpt user password

      Note: For windows authentication see KB article https://support.stopware.com/portal/en/kb/articles/sqlcontext-for-windows-authentication For SQL Authentication see instructions below. If TLS is required, see attachements. 1) Create a clean database ...

    • How to set up passagepoint to talk to an encrypted SQL server DB

      When Data at rest is required to be encrypted, STOPware recommends using SQL server, and using native SQL server data encryption. Once that is done on the SQL server side, on the passagepoint side, pls see attached sqlcontext.xml on how to configure ...

    • Auto delete visitors (Purge Data)

      In order to auto delete a scheduled task is set up, and that task is then set to delete records accordingly. Pls see attached "how to" doc.

    • data migration v13 to Global (4.5.x to global)

      data migration v13 to Global On the passagepoint v13 side, need to Move all pro to Enterprise SQL server. if data does not need to be deleted, anything in the v13.292.1 build is fine, however if data needs to be deleted and photos need to be deleted, ...