Migrating to Sybase ETL

This section explains how to directly migrate the following supported versions of ETL to DI Suite 1.1.

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 or post-processing
- Global variables

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 a directory different than the earlier installation.
Copy the .ini files from the etc directory of the earlier installation to the new installation directory.
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.
If GridNode is running, you can safely uninstall the older version of ETL Server.

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 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 a directory different than the earlier installation.
Copy the .ini files, except for components_*.ini, in the etc directory from the old to the new installation directory.
To reuse the configuration and repository settings in your new installation, you must edit the Windows Registry. For information on how to move the configuration and repository settings from the old installation to the new installation, 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. For information on creating and deleting job schedules, see the Sybase ETL 4.2 User’s Guide.
If GridNode is running, you can safely uninstall the older version of Sybase ETL Development.

Configuring registry settings

Sybase ETL Development uses the Windows Registry to store configuration settings, such as preferences and repository connection details. For more information on customizing preferences and repository connection details, see Sybase ETL 4.2 User’s 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, and do any one of these tasks:
- 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. To do so:
  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.