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
- Dozens more answers to tough SQL Server questions from Mich Talebzadeh are available here.
- The Best Sybase Web Links: tips, tutorials, scripts, and more.
- Ask the Experts yourself: Our SQL, database design, SQL Server, DB2, Sybase, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
This was first published in February 2004