Moving PDA Professional Server

Enter a topic name to show or a new topic name to create; then press Enter

.

Overview

Contents

Preparation

Move System Files Folder

Move Database

Reinstall Plato DBCC

Reinstall ADT Interface

Configure Client PC

This document describes how you can move a PDA Professional server install from one server to another. It comprises of the following components:

1. Move System Files Folder
2. Move Database
3. Reinstall Plato DBCC
4. (Optional)Reinstall ADT interface

Preparation

Before attempting to move the data, make sure:

1. Install SQL Server on the new server (you can upgrade the SQL version if needed i.e. if the old install was SQL 2000, if desired new server can be installed with SQL 2005)
2. Print a list of users currently in the system
3. All users are logged of the system
4. There is a good backup of the databases and system files
5. (optional) Shut down Plato Interface services
6. Shut down Plato DBCC service
7. Shut down SQL Server service (this will allow you to copy database files)

Move System Files Folder

1. Copy all the files from PDA Professional server folder to the new server. Maintain the same folder structure. (if defaults were used at the time of installation, it will be c:\Program Files\PDAPro).
2. On the new server share the PDA Professional system folder as PDAProSystem (if defaults were used at the time of installation, it will be c:\Program Files\PDAPro\Production\System).
3. Grant appropriate user group read-write access to this share.

Move Database

1. If the defaults were used, data folder was under PDA Professional folder and does not required to be copied separately. If the SQL data and log were installed to a different folder, copy them to the new server
2. Attach the following databases to SQL Server, using SQL tools:
1. PlatoPDA
2. PlatoSystem
3. PlatoPatients
3. Create all PDA Professional user from the list printed earlier using SQL tools. Give them the same password as the username. (They will be prompted to change the password when they logon the first time). Make them member of PDAUsers (in PlatoSystem and PlatoPDA database) and PlatoUsers (in PlatoPatients database) role.
4. Following users will not be in the list, create them too (and make members of above role):
1. PDAAdmin
2. Administrator (contact CPR Technologies to set password for this user)
3. CPRTInternalUser, make him a member of ‘securityadmin’ server role, and in each of the 3 databases make him a db_accessadmin, db_owner, db_securityadmin along with PDAUsers. (contact CPR Technologies to set password for this user)

Reinstall Plato DBCC

Using the setup, reinstall Plato DBCC on new server. If you no longer have the setup program for it, contact CPR Technologies. Once installed configure Plato DBCC.

Reinstall ADT Interface

(optional)

If ADT interface was installed, reinstall it from the setup program. If you no longer have the setup program for it, contact CPR Technologies. Once installed do not configure it again, simply copy the PlatoGenericADTInterface.xml from the old server to new one.

Configure Client PC

For version 4.x, change the PDA Professional shortcut to point to new server. For version 5.x change the server information in the logon dialog, information tab.

Related

InstallInstructionsForSQLServer