manually set to "ign" in SAPAPPL1.TSK

[Former Member]

For our R3load based import, we want to NOT import some tables (i.e. skip some tables).

One way to do that is to edit the XXXXX.TSK file (e.g. SAPAPPL1.TSK) before starting import:

D TABLENAME E ign

OR

D TABLENAME E ok

Which one is better in terms of making sure that table will be skipped?

Thanks!

[former_member709110]

Assuming you are using MigMon ...

Create a seperate section in the package list for those tables and use the option taskArgs=-o <options>

option contain only 'DTPIV' letters.

-o D : omit data; do not load data

-o T: omit tables; do not create tables

-o P: omit primary keys; do not create primary keys

-o I: omit indexes; do not create indexes

-o V: omit views; do not create viewsIf you want to combine several omit options, list these options without blank (e.g. u2018-o TVu2019).

And if you don't even plan to create the tables absolutely ... then i would simply edit the STR's and remove the entries for those table. (but you cannot do this if you have too many tables to omit)

Hope this helps

Regards,

Neel

[Former Member]

Yes, MigMon is used.

So the systax is as follows in import_monitor_cmd.properties?

taskArgs=-o D Tablename1, tableename2, talename3.

Thanks!

PS: export is finished.

[former_member709110]

No , thats not the correct way. Please refer to the section 5 Defining Groups of Packages in the MigrationMonitor.pdf. It explains how to do it.

You need to define a seperate group for those tables and use taskArgs = -o D

Regards,

Neel

[markus_doehr2]

During the export of the data add the tablename to the "negdat:" entries in the corresponding DDL file.

If the table is not created on the target system (even if empty) your import will fail.

Markus