Migrating Wide Tables

Migrating tables with hundreds or thousands of columns consumes a lot of memory. To prevent errors while migrating wide tables with varying numbers of columns and rows from a source Sybase IQ database to a target Sybase IQ database, follow the recommendations described in this section.

  • Allocate a 1GB database space for the SQL Anywhere repository with all the other values remaining as system defaults.

  • Use the following techniques, components, and interfaces to migrate tables with large number of columns:

Number of Columns

Migration Techniques

Interface to Use

Up to 3000 columns

Insert Location component

Sybase

Up to 3000 columns

Load Table component

Sybase or ODBC

Up to 3500 columns

Migration wizard

Note:

The Migration wizard may fail to generate the migration projects, either due to memory limitations, or if you do not use a SQL Anywhere repository.

Sybase or ODBC

Up to 10000 columns

Load Table component

ODBC
Note:

When you are migrating a table with more than 3000 columns, you may encounter performance issues moving large number of rows.

Parent topic: Best Practices for Working with ETL Project Components