Share via

How to migrate large Sybase database using SSMA for Sybase

Tahir Khalil 61 Reputation points
2024-11-04T17:31:34.44+00:00

We are on Sybase/SAP ASE database of various sizes the larges one contains about 1TB of data. We are testing the migration it to on-premise MS SQL Server 2022 Linux, using SSMA for Sybase.

Our concern is to move the full data during the downtime which is at max 4 hours. We have segregated the tables to do a kind of partial migrations before cut off for historical of non-critical data but still quite large amount of data is available for real time migration. I have two questions:

  1. Do we have any mechanism to partially migrate data based on some date column? (per table)
  2. What is the suggested solution or way for data migration for large tables using SSMS?

Thanks

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,223 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
542 questions
0 comments
Accepted answer
  1. ZoeHui-MSFT 38,956 Reputation points
    2024-11-05T08:23:44.78+00:00

    Hi @Tahir Khalil,

    Do we have any mechanism to partially migrate data based on some date column? (per table)

    It doesn't seem to be possible with the SSMA tool.

    You can set project conversion, migration, and type mapping options. I didn't find way to base in the date column to migrate.See Migrating SAP ASE databases to SQL Server

    What is the suggested solution or way for data migration for large tables using SSMS

    Migrating from large Sybase to SQL Server is a complex process, you may also consider using ETL tools such as SSIS.

    Remember to back up the database before the migration.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.