SSMA How to convert table schema of a new table faster

Maheen, Aziq Ahamed 0 Reputation points
2023-05-14T10:38:52.76+00:00

Hi

I am using SSMAforSybase 9.3 for SQL 2022. When i run SSMAforSybaseConsole.EXE script

refresh-from-database with object-type="Schemas" takes a long time loading all objects to include new table. Is there anyway i can refresh only the new table faster. I tried below option but errors

FATALERR One or more objects specified as a command params were not found in metabase: testdb.dbo.test1

    <!-- alternate convention for RefreshFromDatabase command -->
    <!-- Example 3: Refresh an object in a category (say Procedures) -->
    <!--<refresh-from-database>
      <metabase-object object-name="$SybaseDb$.dbo.Testproc" object-type="Procedures" />
    </refresh-from-database>-->
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.
506 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 34,591 Reputation points
    2023-05-15T07:03:07.27+00:00

    Hi @Maheen, Aziq Ahamed,

    I'm not familiar with SSMA.

    However, Sybase support for OLE DB and ODBC, so you could try using OLE DB or ODBC component to extract data in SSIS.

    You may have a try with SSIS.

    Regards,

    Zoe Hui


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

    0 comments No comments