Export tables from 2.6 to 4.0

Fiammenghi
Fiammenghi Member Posts: 17
edited 2005-12-04 in NAV/Navision Classic Client
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

Comments

  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    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 :?
    Marije Brummel | Freelance Business Central Specialist
  • Fiammenghi
    Fiammenghi Member Posts: 17
    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
    kriki Member, Moderator Posts: 9,121
    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).
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories