If you move your GainSeeker database to a new server, use the following instructions to point GainSeeker to the new database location.
|
Contents [Hide] |
Use one of the following methods to accomplish this task:
Perform a backup from the old server and restore it to the new server
Detach the tables from the old server and reattach the tables to both the old and new servers.
Set the permission structure on the new server to match that of the old server (for example: roles, schemas, and users).
In the System Administration module:
Create a new Database Connection that points to the GainSeeker
database on the new server.
For instructions, see To
begin editing database connections and Creating
a new database connection.
Set this new Database Connection as the default connection
for all GainSeeker users.
For instructions, see Setting
the default connection.
At each workstation where the GainSeeker client is 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 Database Connection and update the relevant 32-bit ODBC Data Source and Cms.ini settings to match.
After each workstation has been updated, GainSeeker users can resume normal GainSeeker use.
After following the steps above, all GainSeeker workstations should now be attached to the GainSeeker database on the new database server.
Removing the GainSeeker database from the old database server ensures that all new data and any new changes to GainSeeker will only happen on the new database server.