Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
SaveToStream, LoadFromStream |
Sat, Feb 7 2009 9:49 AM | Permanent Link |
Leslie | Hello,
I am thinking about using streaming for a more refined replication. (Some of the client apps needs to be sent only a small subset of the changes) If I understand right, with the use of TEDBDataSet.SaveToStream descendants it is possible save the resultset in one computer and replace the resultset of the same structured table(query ...) with LoadFromStream on a different computer. Is this really that simple or is there something more? I suppose indexes are not saved to the stream only the records. After/while loading the resultset from a stream will the indexes be automatically updated? Regards, Leslie |
Sun, Feb 8 2009 9:59 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Leslie,
<< I am thinking about using streaming for a more refined replication. (Some of the client apps needs to be sent only a small subset of the changes) If I understand right, with the use of TEDBDataSet.SaveToStream descendants it is possible save the resultset in one computer and replace the resultset of the same structured table(query ...) with LoadFromStream on a different computer. Is this really that simple or is there something more? >> No, that's pretty much the whole process. << I suppose indexes are not saved to the stream only the records. >> Correct. The column information and the rows are the only thing saved/loaded. The column information is used during the load to ensure that the columns are compatible with the target dataset that you're loading into. All of the columns in the stream must be available in the target dataset by their name (and they must be the same type), but not necessarily the same position as the source dataset. << After/while loading the resultset from a stream will the indexes be automatically updated? >> Yes. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |