Interbase XE Update

From KeystoneIntranet
Revision as of 14:01, 10 January 2024 by Jquinn (talk | contribs)
Jump to navigation Jump to search

(Updated 5/1/2016)

This procedure should be followed whenever InterBase is upgraded to a new version on a Keystone system. This particular set of instructions assumes an upgrade from an older version of InterBase to XE7. The command lines listed will need to be modified to use the correct InterBase root path for a specific system (see table below.) Passwords also need to be substituted.


IB Version OS "bitness" IB Root Path
7 32/64 C:\Program Files\Borland\InterBase
2007 32/64 C:\Program Files\Borland\InterBase
2009 32/64 C:\CodeGear\InterBase
XE/XE3/XE7 32 C:\Program Files(x86)\Embarcadero\InterBase
XE/XE3/XE7 64 C:\Program Files\Embarcadero\InterBase


1. Verify that no users are currently logged in to Keystone.

2. Shut down the following Keystone services if they are running, using the Windows Services Administrative tool:

  • Device Server
  • Device Aggregator
  • Web Server
  • Mobile Server
  • QC REST Server
  • GPS Server
  • GPS REST Server

3. Verify that the ccasib6 process is NOT running using the Windows task manager. If it is running and you are confident that all users are logged out of Keystone, use the End Process option to terminate the process.

3a. Add up the total size of all the Keystone IB files and verify that there is twice this number in available free space on the drive you are using.

4. Copy the Keystone IB files to a temporary directory as a backup in case something goes wrong.

5. Run the readmeta.sql (rename) SQL script on each Keystone IB file as follows: 

"<IB Root Path>\bin\isql" 127.0.0.1:d:\ccgh\data\ccwsys.ib -user sysdba -password <password> -i readmeta.sql
"<IB Root Path>\bin\isql" 127.0.0.1:d:\ccgh\data\ccwdoc.ib -user sysdba -password <password> -i readmeta.sql
"<IB Root Path>\bin\isql" 127.0.0.1:d:\ccgh\data\ccw001.ib -user sysdba -password <password> -i readmeta.sql
...repeat for remaining companies

6. Backup Keystone IB files using the old InterBase version of GBAK as follows: 

"<IB Root Path>\bin\gbak" -b -g -t -user CCWIN -password <password> 127.0.0.1:d:\ccgh\data\CCWSYS.ib d:\ccgh\data\CCWSYS.ibk
"<IB Root Path>\bin\gbak" -b -g -t -user CCWIN -password <password> 127.0.0.1:d:\ccgh\data\CCWDOC.ib d:\ccgh\data\CCWDOC.ibk
"<IB Root Path>\bin\gbak" -b -g -t -user CCWIN -password <password> 127.0.0.1:d:\ccgh\data\CCW001.ib d:\ccgh\data\CCW001.ibk
...repeat for remaining companies

7a. If you are performing an upgrade to InterBase on the same server:

  • Rename the extension of the original IB files to ".old"
  • Uninstall the old version of InterBase and delete the IB root folder and all subfolders within it
  • Delete the file GDS32.DLL located in the Windows System folder (C:\Windows\System32 or C:\Windows\SysWOW64 for 64-bit Windows)

7b. If you are moving to a new server:

  • Copy the backup files created in step 6 to the new server

8. Install InterBase XE7 (32 or 64 bit) and the latest service pack.

8a. Verify that the file GDS32.DLL exists in the Windows System folder (C:\Windows\System32 or C:\Windows\SysWOW64 for 64-bit Windows). If it does not exist there, copy the file GDS32.DLL from the InterBase root folder.

9. If you are moving to a new server, install Keystone.

10. Create InterBase users needed by Keystone as follows: 

"<IB Root Path>\bin\gsec" -user SYSDBA -password <password> -add CCWIN -pw <password> 
"<IB Root Path>\bin\gsec" -user SYSDBA -password <password> -add CCWVIEW -pw <password> 
"<IB Root Path>\bin\gsec" -user SYSDBA -password <password> -add CCWUSER -pw <password> 
"<IB Root Path>\bin\gsec" -user SYSDBA -password <password> -add CCWSYS -pw <password> 
"<IB Root Path>\bin\gsec" -user SYSDBA -password <password> -add CCWEXT -pw <password>

NOTE: This step is not required when Keystone is installed in step 9.

11. Restore the Keystone IB file backups using the InterBase XE7 version of GBAK as follows: 

"<IB Root Path>\bin\gbak" -r -g -t -user CCWIN -password <password> d:\ccgh\data\CCWSYS.ibk 127.0.0.1:d:\ccgh\data\CCWSYS.ib 
"<IB Root Path>\bin\gbak" -r -g -t -user CCWIN -password <password> d:\ccgh\data\CCWDOC.ibk 127.0.0.1:d:\ccgh\data\CCWDOC.ib 
"<IB Root Path>\bin\gbak" -r -g -t -user CCWIN -password <password> d:\ccgh\data\CCW001.ibk 127.0.0.1:d:\ccgh\data\CCW001.ib 
...repeat for remaining companies

12. Restart any Keystone service applications that were shutdown in step 2, using the Windows Services Administrative tool.

13. If you are moving to a new server, you will need to reactivate Keystone the first time it is run.

(Last updated: 5/1/2016 6:20PM by PTM)

Using GBAKS to backup as of 2024 

@ECHO off
setlocal
:PROMPT
SET /P AREYOUSURE=Are you sure you want to BACKUP (Y/[N])?
@echo off
IF /I "%AREYOUSURE%" NEQ "Y" GOTO END
@echo on

"C:\Program Files\Embarcadero\InterBase\bin\gbak" -b -g -t -user CCWIN -password ch5941pm 127.0.0.1:c:\ccgh\data\CCWSYS.ib c:\ccgh\data\CCWSYS.ibk
"C:\Program Files\Embarcadero\Interbase\bin\gbak" -b -g -t -user CCWIN -password ch5941pm 127.0.0.1:c:\ccgh\data\CCWDOC.ib c:\ccgh\data\CCWDOC.ibk
"C:\Program Files\Embarcadero\Interbase\bin\gbak" -b -g -t -user CCWIN -password ch5941pm 127.0.0.1:c:\ccgh\data\CCW001.ib c:\ccgh\data\CCW001.ibk
"C:\Program Files\Embarcadero\Interbase\bin\gbak" -b -g -t -user CCWIN -password ch5941pm 127.0.0.1:c:\ccgh\data\CCW002.ib c:\ccgh\data\CCW002.ibk
"C:\Program Files\Embarcadero\Interbase\bin\gbak" -b -g -t -user CCWIN -password ch5941pm 127.0.0.1:c:\ccgh\data\CCW003.ib c:\ccgh\data\CCW003.ibk
"C:\Program Files\Embarcadero\Interbase\bin\gbak" -b -g -t -user CCWIN -password ch5941pm 127.0.0.1:c:\ccgh\data\CCW004.ib c:\ccgh\data\CCW004.ibk
"C:\Program Files\Embarcadero\Interbase\bin\gbak" -b -g -t -user CCWIN -password ch5941pm 127.0.0.1:c:\ccgh\data\CCW005.ib c:\ccgh\data\CCW005.ibk


@echo off 
:END
endlocal
pause
Retrieved from "http://in.compucrete.com/index.php?title=Interbase_XE_Update&oldid=906"