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 export and import the data back. Table Data Manager or write a script to save csv file to OS folder and load it back?
Thank you in advance,
Praveen
Table Data Manager will work no need to write a script (unless you want to)
Would this still work if our custom tables do not start with prefix "XFC_"?
Thank you,
Praveen
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.
