Interbase XE Update - Revision history

Jquinn at 14:26, 10 January 2024

2024-01-10T14:26:14Z

Jquinn at 14:03, 10 January 2024

2024-01-10T14:03:57Z

← Older revision		Revision as of 14:03, 10 January 2024
Line 146:		Line 146:
	"C:\Program Files\Embarcadero\InterBase\bin\gbak" -r -g -t -user CCWIN -password ch5941pm c:\ccgh\data\CCW005.ibk 127.0.0.1:c:\ccgh\data\CCW005.ib		"C:\Program Files\Embarcadero\InterBase\bin\gbak" -r -g -t -user CCWIN -password ch5941pm c:\ccgh\data\CCW005.ibk 127.0.0.1:c:\ccgh\data\CCW005.ib
	"C:\Program Files\Embarcadero\InterBase\bin\gbak" -r -g -t -user CCWIN -password ch5941pm c:\ccgh\data\CCW006.ibk 127.0.0.1:c:\ccgh\data\CCW006.ib		"C:\Program Files\Embarcadero\InterBase\bin\gbak" -r -g -t -user CCWIN -password ch5941pm c:\ccgh\data\CCW006.ibk 127.0.0.1:c:\ccgh\data\CCW006.ib
			(Add more lines for more databases as needed)

Jquinn at 14:03, 10 January 2024

2024-01-10T14:03:14Z

@@ Line 103: / Line 103: @@
-**Using GBAKS to backup as of 2024**
+*Using GBAKS to backup as of 2024
 <pre>
 @ECHO off
@@ Line 120: / Line 120: @@
 "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

Jquinn at 14:02, 10 January 2024

2024-01-10T14:02:03Z

← Older revision		Revision as of 14:02, 10 January 2024
Line 102:		Line 102:
	(Last updated: 5/1/2016 6:20PM by PTM)		(Last updated: 5/1/2016 6:20PM by PTM)

	Using GBAKS to backup as of 2024
			Using GBAKS to backup as of 2024
	<pre>		<pre>
	@ECHO off		@ECHO off

Jquinn at 14:01, 10 January 2024

2024-01-10T14:01:33Z

← Older revision		Revision as of 14:01, 10 January 2024
Line 101:		Line 101:

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

			Using GBAKS to backup as of 2024
			<pre>
			@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
			</pre>

WikiAdmin: 1 revision imported

2023-07-14T12:58:50Z

1 revision imported

← Older revision	Revision as of 12:58, 14 July 2023
(No difference)

Intra>User: 1 revision imported

2017-01-10T00:01:48Z

1 revision imported

New page

<b>(Updated 5/1/2016) </b>

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.

{| border="3" cellspacing="0" cellpadding="3"
! 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 [[Media:Readmeta_sql.txt|readmeta.sql (rename)]] SQL script on each Keystone IB file as follows:
<pre>
"<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
</pre>

6. Backup Keystone IB files using the old InterBase version of GBAK as follows:
<pre>
"<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
</pre>

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:
<pre>
"<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>
</pre>
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:
<pre>
"<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
</pre>

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)

← Older revision		Revision as of 14:26, 10 January 2024
Line 113:		Line 113:
	@echo on		@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 <password> 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 <password> 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 <password> 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 <password> 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 <password> 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 <password> 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		"C:\Program Files\Embarcadero\Interbase\bin\gbak" -b -g -t -user CCWIN -password <password> 127.0.0.1:c:\ccgh\data\CCW005.ib c:\ccgh\data\CCW005.ibk
	(Add more lines for more databases as needed)		(Add more lines for more databases as needed)

Line 138:		Line 138:
	@echo on		@echo on

	"C:\Program Files\Embarcadero\InterBase\bin\gbak" -r -g -t -user CCWIN -password ~~ch5941pm~~ c:\ccgh\data\CCWSYS.ibk 127.0.0.1:c:\ccgh\data\CCWSYS.ib		"C:\Program Files\Embarcadero\InterBase\bin\gbak" -r -g -t -user CCWIN -password <password> c:\ccgh\data\CCWSYS.ibk 127.0.0.1:c:\ccgh\data\CCWSYS.ib
	"C:\Program Files\Embarcadero\InterBase\bin\gbak" -r -g -t -user CCWIN -password ~~ch5941pm~~ c:\ccgh\data\CCWDOC.ibk 127.0.0.1:c:\ccgh\data\CCWDOC.ib		"C:\Program Files\Embarcadero\InterBase\bin\gbak" -r -g -t -user CCWIN -password <password> c:\ccgh\data\CCWDOC.ibk 127.0.0.1:c:\ccgh\data\CCWDOC.ib
	"C:\Program Files\Embarcadero\InterBase\bin\gbak" -r -g -t -user CCWIN -password ~~ch5941pm~~ c:\ccgh\data\CCW001.ibk 127.0.0.1:c:\ccgh\data\CCW001.ib		"C:\Program Files\Embarcadero\InterBase\bin\gbak" -r -g -t -user CCWIN -password <password> c:\ccgh\data\CCW001.ibk 127.0.0.1:c:\ccgh\data\CCW001.ib
	"C:\Program Files\Embarcadero\InterBase\bin\gbak" -r -g -t -user CCWIN -password ~~ch5941pm~~ c:\ccgh\data\CCW002.ibk 127.0.0.1:c:\ccgh\data\CCW002.ib		"C:\Program Files\Embarcadero\InterBase\bin\gbak" -r -g -t -user CCWIN -password <password> c:\ccgh\data\CCW002.ibk 127.0.0.1:c:\ccgh\data\CCW002.ib
	"C:\Program Files\Embarcadero\InterBase\bin\gbak" -r -g -t -user CCWIN -password ~~ch5941pm~~ c:\ccgh\data\CCW003.ibk 127.0.0.1:c:\ccgh\data\CCW003.ib		"C:\Program Files\Embarcadero\InterBase\bin\gbak" -r -g -t -user CCWIN -password <password> c:\ccgh\data\CCW003.ibk 127.0.0.1:c:\ccgh\data\CCW003.ib
	"C:\Program Files\Embarcadero\InterBase\bin\gbak" -r -g -t -user CCWIN -password ~~ch5941pm~~ c:\ccgh\data\CCW004.ibk 127.0.0.1:c:\ccgh\data\CCW004.ib		"C:\Program Files\Embarcadero\InterBase\bin\gbak" -r -g -t -user CCWIN -password <password> c:\ccgh\data\CCW004.ibk 127.0.0.1:c:\ccgh\data\CCW004.ib
	"C:\Program Files\Embarcadero\InterBase\bin\gbak" -r -g -t -user CCWIN -password ~~ch5941pm~~ c:\ccgh\data\CCW005.ibk 127.0.0.1:c:\ccgh\data\CCW005.ib		"C:\Program Files\Embarcadero\InterBase\bin\gbak" -r -g -t -user CCWIN -password <password> c:\ccgh\data\CCW005.ibk 127.0.0.1:c:\ccgh\data\CCW005.ib
	"C:\Program Files\Embarcadero\InterBase\bin\gbak" -r -g -t -user CCWIN -password ~~ch5941pm~~ c:\ccgh\data\CCW006.ibk 127.0.0.1:c:\ccgh\data\CCW006.ib		"C:\Program Files\Embarcadero\InterBase\bin\gbak" -r -g -t -user CCWIN -password <password> c:\ccgh\data\CCW006.ibk 127.0.0.1:c:\ccgh\data\CCW006.ib
	(Add more lines for more databases as needed)		(Add more lines for more databases as needed)