Ask the Expert

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?

Requires Free Membership to View

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

This was first published in February 2004

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: