I have an application which downloads data from one database, does some formatting, and moves it into my proprietary database format on SQL server or Oracle.
In the past, I've always downloaded, dumped to Paradox .db tables, formatted, and batch moved into to the server from the Paradox .db tables. The reason for the intermediate step of moving to the Paradox .db tables is that once the data is downloaded, it needs to be portable so that for instance a client running the download portion in finland can download, send on to me and I can import.
I have embarked on creating a new version of this process, and have elected to use ADO so that I can be rid of the BDE (It's been causing me headaches in deployment and also running on Multi-Proc machines). As far as the Download portion goes, this is easy, simply run my query and then the TadoDataset supports TADODataset.SaveToFile and I can either save it as the binary file type or XML. Importing, seems to be a bit more of an Issue, I can use an ADOTable, or Dataset and LoadFromFile, which moves it into the Set, but not into the Server. In the BDE World, I suppose this is where batchmove would come in....
Is the best way to get the data into the server simply to cycle the dataset, executing an Insert statement at each row? Or, is there some sort of shortcut to move the entire dataset that I'm missing?
TIA for any assistance.
In the past, I've always downloaded, dumped to Paradox .db tables, formatted, and batch moved into to the server from the Paradox .db tables. The reason for the intermediate step of moving to the Paradox .db tables is that once the data is downloaded, it needs to be portable so that for instance a client running the download portion in finland can download, send on to me and I can import.
I have embarked on creating a new version of this process, and have elected to use ADO so that I can be rid of the BDE (It's been causing me headaches in deployment and also running on Multi-Proc machines). As far as the Download portion goes, this is easy, simply run my query and then the TadoDataset supports TADODataset.SaveToFile and I can either save it as the binary file type or XML. Importing, seems to be a bit more of an Issue, I can use an ADOTable, or Dataset and LoadFromFile, which moves it into the Set, but not into the Server. In the BDE World, I suppose this is where batchmove would come in....
Is the best way to get the data into the server simply to cycle the dataset, executing an Insert statement at each row? Or, is there some sort of shortcut to move the entire dataset that I'm missing?
TIA for any assistance.