Q

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


This was first published in February 2004
This Content Component encountered an error

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchDataCenter

SearchServerVirtualization

SearchCloudComputing

SearchEnterpriseDesktop

Close