There appear to be no examples of dumping table data in the demo application, and the help and PDF files are not at all clear on how the TDADump feature works. Would it be possible to give a simple example of how to dump a table or query as a data file which can subsequently be loaded into a table with identical structure in another database?
Thanks.
TDADump - BackupToFile
TDADump is an abstract base class that cannot be used directly. Some our DACs - MyDAC, SDAC, PgDAC, and UniDAC have descendant classes. But ODAC does not have such class.
In ODAC you can save data into XML file by using the SaveToXML method of TOraQuery. Then load data into TVirtualTable using its LoadFromFile method. Then you can copy data to a table in the database using the LoadFromDataSet method of TOraLoader or the TCRBatchMove component.
You can also move data directly from one table to another using the TCRBatchMove component.
In ODAC you can save data into XML file by using the SaveToXML method of TOraQuery. Then load data into TVirtualTable using its LoadFromFile method. Then you can copy data to a table in the database using the LoadFromDataSet method of TOraLoader or the TCRBatchMove component.
You can also move data directly from one table to another using the TCRBatchMove component.