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
- 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.
Dig Deeper on Linux servers
Related Q&A from Mich Talebzadeh
Sybase expert Mich Talebzadeh explains how to log on in ASE. Continue Reading
Sybase expert Mich Talebzadeh gives fifteen reasons for why Sybase will definitely be around for years to come. Continue Reading
Sybase expert Mich Talebzadeh explains the syntax for user-defined Sybase functions. Continue Reading