Migrating to a New Server

By June 13, 2019Uncategorized

Server 

Backup the Power Practice program and the database. A quick way to do this is to:

– copy the c:\powerptx directory to a storage device.
– stop the mysql service (open the command prompt and type net stop mysql).
– copy c:\mysql\data\powerptx directory to a storage device.

Install the same version on the new server that is currently installed on the old server.

Open a command prompt on the new server and stop the mysql service by typing net stop mysql

Go into the C:\mysql\data folder on the new server and rename the powerptx folder to powerptxOriginal.

Copy the C:\powerptx folder from the old server and paste it over top the C:\powerptx on the new server.

Copy the powerptx folder from C:\mysql\data\ on the old server and place it into the C:\mysql\data folder on the new server.

On the new server, open the C:\powerptx\data\windent.ini file. Do a search for DBHostName and change it to the name or ip of the new server.

Start the MySQL service by typing net start mysql in the command prompt.

Make sure you can log into Power Practice and that the correct data is there

If the office is using Forms, you will need to re-install the PxForms Setup.

Workstations

If the drive path to the powerptx on the new server is different, on each workstation open up the C:\powerptx\station.ini and change the path for DBDirectory, ReportsDir, ClaimsDir, ApptBackupsDir. You may need to use a UNC path.

If the server name has changed, you will need to update the ODBC on all stations. Go into the powerptx directory. Double-click on Edit ODBC Settings.exe. On the System DSN tab, highlight the pptxmysql, click Configure. Change the Database Name to the new server name