NetResults ProblemTracker
Moving Workgroups

To move a workgroup, click on the Move button on the Button Bar. Select a workgroup from the pulldown menu, select one of the following move operations described below, then click on the Continue button.

If you have manually applied any custom security to your workgroups (such as file system permissions or IIS application settings), you will need to re-apply these changes to this workgroup after it using one of the following move operations. A Web Server Security Overview can be found in the Installation Help Guide.

Move Workgroups within the same Web Server machine

This operation should be used if you want to change the physical location of the workgroup within the web server machine where the workgroup is currently located.

The workgroup name, location, and web site will be displayed in the Current Configuration section. Enter the path of the new location and / or select a different web site in the New Configuration section. Enter Host Name or IP Address and the Port Number. Add a history comment. Click on the Continue button to proceed.

A confirmation page will be displayed. Click the Back button to make any necessary changes to the location and / or web site. Otherwise, click on the Move Workgroup button, then click on the OK button to complete the move operation.

Move Database from one machine to another

This option allows you to move the database to another machine while still keeping the remainder of the workgroup files in the same location. This operation cannot be performed for Access databases.

The workgroup name, database type, database name, and database location will be displayed in the Current Configuration section. Enter new values for any of the following fields in the New Configuration section: Database Name, Location (Server Name), User Name, Password, Physical Path (for SQL Server only). You must add information in the history comment field to proceed. Then, click on the Continue button.

A confirmation page will be displayed. Click the Back button to make any necessary changes to the location and / or web site. Otherwise, click on the Move Workgroup button, then click on the OK button to complete the move operation.

After the workgroup files have been moved, the database needs to be moved into the new machine using the import / export tool for your database type. The latest procedure can be found in the Frequently Asked Questions section of our web site at:

http://www.netresultscorp.com/pt_faq_howdoi.htm#SQLmove4x

Move / Populate Workgroup based on the PTAdmin Database

This option allows you to move all of the workgroups and settings in your ptadmin database to another machine. For example, if you need to move your entire ProblemTracker to a new machine, you can move your Workgroup Management System information to the new machine without having to re-enter information.

Complete the following steps before selecting the option to move / populate workgroup based on the ptadmin database:

  1. Install ProblemTracker on the new server machine
  2. Copy your ptadmin database from your old server to the new server. The ptadmin database can be found in your installation directory. By default, the path is C:\Inetpub\wwwroot\ProblemTracker\ptadmin\Database\ptadmin.mdb, where C:\Inetpub\wwwroot\ProblemTracker is the installation directory.
  3. Copy your user management database from your old server to the new server. The user management database (ptcommon.mdb) can be found in your installation directory. Be default, this is located at C:\Inetpub\wwwroot\ProblemTracker\ptcommon\Database\ptcommon.mdb, where C:\Inetpub\wwwroot\ProblemTracker is the installation directory.

Click on the Move button on the Button Bar. Select a workgroup from the pulldown menu, select the option move / populate workgroup based on the Workgroup Management System database, then click on the Continue button.

Existing properties of the selected workgroup will be displayed. You have an option to change the workgroup location, virtual web site, host name or IP address and the port number for this workgroup on the new server. If you don't need to change anything accept the default values. Now click Continue button.

New properties for this Workgroup will be displayed. Click Move Workgroup to actually move/populate the Workgroup.

After successful completion, you need copy the Attachments folder from the old server to the new server for this workgroup. The Attachments folder can be found in the installation directory. By default, the path is C:\Inetpub\wwwroot\ProblemTracker\workgroup\Attachments where workgroup is ptdev, ptweb, etc.

Important Note:
For Workgroups with an Access database, you will need to complete one more additional step:

Perform all the above steps for each of the Workgroup that you wish to move to the new server.