Problem solve Get help with specific problems with your technologies, process and projects.

Loading an ASE database into an IQ database

I am just wondering what's the easiest way to get an ASE database loaded into an IQ database?

It all depends if you can afford downtime (offline) for your ASE database or not.

If it doesn't matter to have it offline for the time it takes, then BCP out the ASE database, then use the IQ equivalent (load table) to load bcped table in. This is fine and very fast indeed.

If an offline window is not tolerable, then you need to set up replication with both systems shadowing each other for a while. I would say, using replication to bring the empty IQ up to speed by turning updates into inserts, where first seen, via a set of staging tables.

For More Information

Dig Deeper on Linux servers

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.