SSMA How to convert table schema of a new table faster

Question

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>-->

Answer 1

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.