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 these recommendations:
Use a SQL Anywhere repository rather than a Microsoft Access or SQLite Persistent repository.
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
|
Sybase or ODBC |
Up to 10000 columns |
Load Table component |
ODBC |
When you are migrating a table with more than 3000 columns,
you may encounter performance issues moving large number of rows.
