Changing a database server

These instructions detail how to change the computer that serves as your GainSeeker database.

1. Prepare the new server

• Perform a backup from the old server and restore it to the new server

or

• Detach the tables from the old server and reattach the tables to the new server.

Then:

• Set the permission structure on the new server to match that of the old server (for example: roles, schemas, and users).

2. Add a new Database Connection within GainSeeker and make it the default

Fig. 1

1. Log in to GainSeeker.

2. Open the GainSeeker System Administration module.

3. Click the Database Connections tab to open it (see Fig. 1).

4. Then, right-click on the Connections node.

5. In the New Connection dialog that displays, enter a name for the new connection. For example, you could label the connection "GainSeeker." Then, click OK.

6. Provide the needed information In the Pick Datasource dialog that displays (see Fig. 2). Then, click Test to test the values you entered.

7. Click OK on the Pick Datasource dialog when you are done.

8. On the Database Connections tab System Administration dialog (Fig. 1), right-click the name of the new connection that now displays in the Connections node. Then, click Default connection in the list that displays.

Fig. 2

3. Modify workstations

At each workstation that has GainSeeker installed, run GSSETUP.EXE with the ODBC command line parameter from your GainSeeker program folder (typically C:\Program Files(x86)\Hertzler Systems\GainSeeker or similar). The full command line will be similar to this:

"C:\Program Files(x86)\Hertzler Systems\GainSeeker\GSSETUP.EXE ODBC"

This will detect the new default connection and update the relevant ODBC DSN and Cms.ini settings to match.