How to exclude trigger in SQL Migration Assistant

Aziq Maheen 1 Reputation point
2021-12-04T06:16:53.707+00:00

I want to exclude trigger when using SSMA Console for migrating only Tables & Index from Sybase ASE to MSSQL. How to do it ?

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.
476 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Alexander Ivanov 491 Reputation points
    2021-12-04T17:03:21.203+00:00

    Hello,

    If you don't want triggers to be included, simply do not check the Triggers node in the Sybase Metadata Explorer.

    155022-image.png

    Regards,
    Alex.


  2. Alexander Ivanov 491 Reputation points
    2021-12-06T17:38:13.427+00:00

    Hello,

    Sorry, I didn't realize you were asking about the SSMA console. I don't think we have support for such a granularity of objects selection in the console. Once you specify that you want to convert a table - indexes and triggers will be included, unfortunately.

    Regards,
    Alex.

    0 comments No comments