SnowConvert AI - Sybase IQ¶

The first step for migration is getting the code that you need to migrate. There are many ways to extract the code from your database. However, we recommend using the extraction scripts provided by Snowflake.

All the source code for these scripts is open source and is available on GitHub.

Prerequisites¶

  • Sybase IQ client utilities installed and accessible, specifically iqunload (or iqunload.bat on Windows).

  • Sufficient privileges for the user in the target database to extract DDL.

  • Disk space in the output directory for the consolidated SQL and split files.

  • A valid Sybase IQ connection string (examples below).

Installing the scripts¶

Go to https://github.com/Snowflake-Labs/SC.DDLExportScripts/

image

From the Code option, select the drop-down and use the Download ZIP option to download the code.

Decompress the ZIP file. The code for Sybase IQ should be under the “Sybase IQ” folder.

When the script is done, the output folder will contain all the DDLs for the migration.

Follow the Usage instructions to modify the files and run them on your system.

You can then compress this folder to use with SnowConvert AI

zip -r output.zip ./output
Copy