Upgrading ETL

This section explains how to upgrade the following ETL products to DI Suite 1.2 ETL:

ETL 4.x
Tron 4.x, if none of the following features are used:
- UTL projects
- XML via SQL Transformer component
- XML via XSLT Transformer component
- Job Guard Calculation
- Job project pre-processing or post-processing
- Global variables
ETL Small Business Enterprise (SBE)
IQEEE

The upgrade procedure for ETL Server and ETL Development is the same for all the ETL products listed above. The only exception is that you need to obtain the new DI 1.2 Sybase ETL Server and DI 1.2 Sybase ETL Development licenses while upgrading all ETL products, except ETL 4.x.

Upgrading Sybase ETL Server

Go to the Windows Task Manager and click the Processes tab to check for any active GridNode.exe process. Make sure that the Show Processes From All Users option is selected.
If a GridNode.exe process is running, select it and click End Process.
Use the DI Suite installer to install the new version of ETL Server in the same installation directory as the existing one.
If you are upgrading from Tron 4.x, ETL SBE and IQEEE, obtain the new DI Suite 1.2 Sybase ETL Server licenses from the SPDC and copy it into the %SYBASE%\ETLServer42\licenses directory.

For information on how to obtain licenses from the SPDC, see the Sybase Software Asset Management User's Guide.

If you are upgrading from ETL 4.x, do not perform this task.
Start the new ETL Server.
- To start the ETL Server directly, enter:
```
GridNode
```
- To start the ETL Server as a service, enter:
```
GridNode --install
```
To verify whether the startup is successful, go to the Windows Task Manager and click the Processes tab to check if the GridNode.exe process is running.

Upgrading Sybase ETL Development

Go to the Windows Task Manager and click the Processes tab to check for the GridNode.exe process. Make sure that the Show Processes From All Users option is selected.
Select the GridNode.exe process or processes, if more than one is running, and click End Process.
If you are using Microsoft Access repositories that are located in the application directories, copy the database files and point the ODBC Data Source to the new location.
Use the ETL Development installer to install the new version of Sybase ETL Development in the same installation directory as the existing one.
If you are upgrading from Tron 4.x, ETL SBE and IQEEE, obtain the new DI Suite 1.2 Sybase ETL Development licenses from the SPDC and copy it into the %SYBASE%\ETLDevelop42\licenses directory.

See the Sybase Software Asset Management User's Guide.

If you are upgrading from ETL 4.x, you are not required to perform this task.
To reuse the configuration and repository settings in your new installation, edit the Windows Registry. See “Configuring registry settings”.
Start Sybase ETL Development.
Connect to an existing repository . In the Sybase ETL Development Repository Login window, select the repository you want to connect to and provide the user name and password that was used to connect to the repository in the earlier version.
Go to the Windows Task Manager and click the Processes tab to check if the GridNode.exe process is running.
Delete and re-create job schedules. See the Sybase ETL 4.2 Users Guide.

Configuring registry settings

Sybase ETL Development uses the Windows Registry to store configuration settings, such as preferences and repository connection details. See Sybase ETL 4.2 Users Guide.

Select Start | Run and enter regedit to open the Registry Editor. Click OK. The Registry Editor window appears.
Go to HKEY_CURRENT_USER\Software\JavaSoft\Prefs\ in the registry path:
- If you plan to uninstall the old version of Sybase ETL Development, rename the branch solonde\transform (TRON 4.x) and sybase\iqetl (IQ ETL 4.x) to sybase\sybetl in the Registry Editor.
- If you do not plan to uninstall the old version, export the settings to a .reg file, edit it to change all occurrences of the branch names, and import it to the registry:
  1. Select the following branch:
    - solonde\transform (TRON 4.x)
    - sybase\iqetl (IQ ETL 4.x)
  2. Select File | Export.
  3. Enter a file name for the registry file and click Save.
  4. Right-click the registry file and select Edit to open it in a text editor.
  5. Select Edit | Replace to change all instances of \company\product to \sybase\sybetl.
  6. Save the changes and exit the text editor.
  7. In the Registry Editor window, select File | Import. Select the modified registry file and click Open. A prompt appears stating that the registry file has been successfully entered into the registry. Click OK.
  8. Close the Registry Editor.