Migrating ETL 4.5 and 4.5.1 repositories in Sybase IQ to SQL Anywhere 11

Workaround:

1. In the SQL Anywhere 11 database, repositoryNew (repostiory49.db), drop the DS_CHUNK, DS_DATA, DS_OBJECT, and TRON_PERFORMANCE tables.

   You may use the tools provided during the installation of SQL Anywhere 11, which is included with ETL Server.

   To drop these tables using Sybase ETL Development:

   1. Start ETL Development and log in to the demo database.

   2. Select File | New | Project.

   3. From the Destination tab, add the DB Data Sink Insert component and enter these values:

      Property name	Value
      Interface	ODBC
      Host Name	repositoryNew
      User	dba
      Password	sql
      Destination Table	TRON_PERFORMANCE

   4. Click Save.

   5. Right-click the new DB Data Sink Insert component and select Execute SQL Commands.

   6. Enter:

      • Drop table DS_CHUNK

      • Drop table DS_DATA

      • Drop table DS_OBJECT

      • Drop table TRON_PERFORMANCE

   7. Click Execute.

   The tables are dropped. Close the project without saving it.

2. In the Repository Logon window, set up the repository connection:

   1. Click Add and enter myRepository_ETL49 as the name.

   2. Select ODBC as the interface.

   3. Select repositoryNew as the host.

   4. Enter dba as the user and sql as the password.

   5. Click Test Logon to test the connection. Click Yes when prompted to create repository tables.

3. Migrate your 4.5 or 4.5.1 repository using the steps described in “Migrating from an existing repository to a SQL Anywhere repository,” in Chapter 4, “Upgrading” in the ETL 4.9 Installation Guide.