I am trying to update a backend database by exporting existing tables from the old version of the data (called OLD_BE) as individual text files, and then reimporting these text files into tables into a new version (called NEW_BE). The tables in the new database have been modified slightly from the old version.
For most tables this process works fine and seemlessly, but there are two tables where the data won't import unless I manually delete the index columns in the text files before importing.
Is there any way of deleting (or ignoring) these columns when importing the data or, conversely, not even output the index data into the text files?
Any advice gratefully received.
JR
For most tables this process works fine and seemlessly, but there are two tables where the data won't import unless I manually delete the index columns in the text files before importing.
Is there any way of deleting (or ignoring) these columns when importing the data or, conversely, not even output the index data into the text files?
Any advice gratefully received.
JR
