Forum Discussion

Mikki's avatar
Mikki
New Contributor III
2 months ago
Solved

How to export from and import to custom OS tables

Hi, For the v8 to v9 upgrade, it seems like we need to remove our custom tables and add them back after the upgrade. We have scripts to add the tables back but what is the process you follow to e...
Data Management
Data Sources
  • SimonHesford's avatar
    SimonHesford
    2 months ago

    Table Data Manager will work no need to write a script (unless you want to) 

Mikki's avatar
Mikki
New Contributor III
2 months ago

Would this still work if our custom tables do not start with prefix "XFC_"?

Thank you,

Praveen

  • rhankey's avatar
    rhankey
    Contributor III
    2 months ago

    TDM by design on works with tables named with a particular prefix.

    There are many way one could transfer custom tables over to a new App.  One method would be to have the old V8 DB temporarily restored to the V9 DB server alongside the new v9 DB so that you can use SQL statements to copy the Tables from the old to new DB.  This would definitely be the way I'd go if dealing with large tables or tables containing binary or other challenging data.  Beyond that, if you will find that there are at least as many export/import methods employing business rules as people who respond.