Porting Data from one database to another

Mauddib

I have some very large tables, some information from which i need to move from one database to another database.

I have a smaller table which is a list of "Entry No.". These numbers correspond to the entries that need to be moved from one table to the other.

What is the fastest way to do this as the tables are huge. I COULD say in the onbeforeexportrecord() to check if this entry is listed in the smaller table. But that means going through ALL the records which will take ages.

I tried a dataport where the table im exporting from was a sub data item to the smaller table. This exported fine (XML format) but in Navision 3.6 you cant then import this data with XML.

GaMBe

kriki

And if you let your dataport work on the records in the smaller table?
In the OnBeforeExport-trigger, you get the record of the bigger table and in the dataportfields, you put the fields of the bigger table.