Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1456
  • Last Modified:

IQ migration from Solaris to Linux


What is the best way to migrate Sybase IQ database from SUN Solaris to Linux?

2 Solutions
Joe WoodhousePrincipal ConsultantCommented:
There isn't very much in IQ-land that is platform-specific.

Raw partitions work differently under Linux compared to Solaris. Read the Installation Guide and Release Notes for IQ on Linux carefully, there are some things you have to set up first before installation.

The other thing to consider is that native IQ backups can't cross platforms, so alas, you cannot simply backup on Solaris and restore on Linux. Do you have the ability to recreate your IQ database from upstream data? If so, just install & recreate on Linux.

If not, you'll have to think about some kind of data unload or extract followed by a load. You have a few options here so it's worth testing & timing them as I can't predict which will be fastest. You could set up Open Client connections from IQ on Linux to IQ on Solaris and attempt one INSERT ... LOCATION command per table, but that's the slowest way to load IQ. If you have disk space, extract each table to file (fixed width is faster to load but takes potentially a lot more disk space) and then load from each file.

The schema part is pretty easy. If you don't already have scripts to recreate your schema, you can use Sybase's PowerDesigner to reverse-engineer your current schema. If you don't already have a licensed copy you can download a 30-day eval from the Sybase site.

Most of your effort will go to migrating the data; installation is fast, recreating all objects is fast, it's moving the data that's slow.

Good luck!
Hi CS,

Joe has a good point that it is difficult to predict which will be the fastest way of loading IQ.  The question comes down to whether it is faster to extract the table to disk, and then load it via load table, or use insert..location.  

I have had good success with cross platform migrations by scripting the extract and load of each table - what I do I have a script that migrates a list of tables so I can have multiple instances of the script running in parallel with other instances, each migrating a subset of tables.  

Each script processes a list and does the following for each table in its "input list":

1.)  extract schema for the source table and apply it to the target database.
2.)  extract the table's data in ascii format using delimiters to local disk.
3.)  load table "using client file" across the network to the target database.
4.)  clean up and move on to the next table.

At the end of the job, check row counts on all source and target tables to be sure they match.  

Check out the attached sp_iqclonetable procedure, you can use this to extract schema and reverse DDL.   (or use PowerDesigner, as it is a more complete solution.)


- David sp-iqclonetable-15.sql
CHANAuthor Commented:
thanks for the clarification Joe & David. I appreciate it.

Warm Regards,
I didn't see any issues regarding the differences in endian structure format  differences between Sun and Linux? Linux stores data in the opposite endian format as Sun. From my research the data would have to be moved using ; BINARY WITH NULL BYTE ? Did none of you run into this when moving the data from Sun to Linux Sybase IQ?
Joe WoodhousePrincipal ConsultantCommented:
I had understood endian to be more a matter of hardware than of O/S. For example simply changing O/S but remaining on the same hardware wouldn't have this issue.

We don't know enough here to know if that's the case. Good catch of a potential issue though!

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now