Need to Export Records to Remote Terminal
-
I need to Export Fields in a table into another Database Table on a Remote machine, at the moment I Export the records one by one and delete the records as I go along. This is very slow over a 28k connection that I need to use.(3 records per second or so, I am dealing with 1000s of records) I would love to take all the records at once, dump the on the remote machine and then delete the lot! I can make use of a Dataset to get all the records but how do I specify what and how to export this to another connection???:confused: Leon v Wyk
-
I need to Export Fields in a table into another Database Table on a Remote machine, at the moment I Export the records one by one and delete the records as I go along. This is very slow over a 28k connection that I need to use.(3 records per second or so, I am dealing with 1000s of records) I would love to take all the records at once, dump the on the remote machine and then delete the lot! I can make use of a Dataset to get all the records but how do I specify what and how to export this to another connection???:confused: Leon v Wyk
Well, a
DataSetcan be written to an implementation-independent XML file usingDataSet.WriteXml(). SinceDataSetis also marked withSerializableAttributeand implementsISerializable, you can serialize this normally to a file yourself. It also derives fromMarshalByValueComponent, which means that you can use it in remoting as a remote, pass-by-value object. See the documentation forDataSetfor what else is available.Reminiscent of my younger years...
10 LOAD "SCISSORS" 20 RUN
-
I need to Export Fields in a table into another Database Table on a Remote machine, at the moment I Export the records one by one and delete the records as I go along. This is very slow over a 28k connection that I need to use.(3 records per second or so, I am dealing with 1000s of records) I would love to take all the records at once, dump the on the remote machine and then delete the lot! I can make use of a Dataset to get all the records but how do I specify what and how to export this to another connection???:confused: Leon v Wyk
Doing them in a set wont speed anything up more for you. Best is to perhaps export the table to a temporary access database, zip the file , send it to other side, etc ,etc. Access tends to compress very well. Leon v Wyk wrote: at the moment I Export the records one by one and delete the records as I go along. This is very slow...I am dealing with 1000s of records :laugh: I can picture that :rolleyes: leppie::AllocCPArticle(Generic DFA State Machine for .NET);