Export tables from 2.6 to 4.0

Fiammenghi

Hi to all,
is there a tools that let me export proprietary tables, both structure and data,from my 2.6 db to 4.0 db without having to create (and then run twice) dataport for each table (more or less 150).

Many thanks in advance

Fabrizio

Marije_Brummel

You can make one dataport that contains all tables or do something with RecordRef's.

Why do you need this? I hope not that it is for an upgrade :?

Fiammenghi

Hi,
Yes it is a migration... we want to start with a freh copy of of the db regarding accounting info.. and with old datas for what we developped.

I hope there is another solution i/o dataports....

B. regards
Fabrizio

kriki

Well, you can open your 2.60-DB with a 4.0, thus converting it. Then you create a form (or report, or codeunit) in which you ask for a table ID. This object exports all with the help of the recordreference and fieldreference (eg. you do a write with the field ID and on the next line you put it's value). And on the other DB, you import it with an object that can read the output of previous program and put it in the right tables and right fields.
OF COURSE, DON'T DO THIS WITH MOST STANDARD NAVISION-TABLES. Do it only with customer-specific tables (if the structure doesn't change).