Forum Discussion

sqldeven's avatar
sqldeven
Copper Contributor
Jan 18, 2021

SYBASE IQ to SQL Server 2019

Hi i Need to migrate SYBASE IQ to SQL Server 2019 so have following questions.

  1. As sybase IQ is columnar database and sql server row database so is this migration feasible ?

  2. read about the sql server columnar indexes so can they play any role in such scenario considering data will be frequently insert/update/delete as it is analytic database?

  3. How data migration can be done in this scenario?

1 Reply

  • bchaudha's avatar
    bchaudha
    Copper Contributor
    Batch mode on rowstore new feature might help to migrate from sybase IQ to mssql 2019 but you need to do POC with vendors 🙂

Resources