[CR #552093] The following information is missing from the Sybase IQ ETL 4.5.1 Users Guide.
Excessive memory is consumed migrating tables with hundreds or thousands of columns. 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 these recommendations:
Use a SQL Anywhere repository rather than a Microsoft Access or SQLite Persistent repository.
Allocate 1 GB database for the SQL Anywhere repository with all the other values remaining as system defaults.
To migrate a table with up to 3000 columns, you can use the Insert Location component and select Sybase as the interface.
To migrate a table with up to 3500 column, you can use the Migration Wizard and select Sybase or ODBC as the interface.
Occasionally, 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.
To migrate a table with up to 3000 columns, you can use the Load Table component and select Sybase or ODBC as the interface.
To migrate a table with up to 10000 columns, you can use the Load Table component and select ODBC as the interface.
When migrating a table with more than 3000 columns,
you may encounter performance issues moving large number of rows.
