How to move TargetProcess from one server to another

1. Install the new instance of Targetprocess to Server2 using a new temporary database.

2. Verify that the application works with clean data.

3. At this point you have two options, depending on whether you move the database along with the app or not.

A. [If you are moving the database to Server2 as well ]

Restore the backup of the production database over that new database. To accomplish this, set the temporary database to Single User mode, right click the database name, select Properties and then Options:

B. [if your database remains on Server1 or if you have restored the backup over a different database]

Edit the web.config file for the new installation. By default it can be found at: c:\inetpub\wwwroot\TargetProcess2\wwwroot\.

Make sure the connection string in the new web.config file sets the correct database to Single User mode:

<property name="connection.connection_string">Server=.\sqlexpress2k8r2;initial catalog=TargetProcess2;user id=sa;password=sa;Language=English</property>

4. Move the following folders from Server1 to Server2:

[Targetprocess installation root]/wwwroot/upload

[Targetprocess installation root]/wwwroot/img/TermIcons

5. Enjoy using TargetProcess on the new server.

Using Windows authentication for database access

If you’ve been using Windows authentication to access the application database on Server1, it is highly recommended to keep using it for the new installation on Server2. In this case, the installer will set all the permissions correctly (saving you extra efforts on adding Network Service user to the database and granting this user write permissions to the upload and TermIcon folders).

Server=Server1;initial catalog=TargetProcess;Integrated Security=SSPI