The Entity Sync stuff is definitely not meant for large sets of data, but rather for trickling regular updates over the line. Part of the reason for this is that it loads all data into memory for sorting records by time and interleaving records from multiple tables (which can't be done with a normal database query) and other such operations.
You can, however, do an export to a file with and entity sync ID (from WebTools) and it pulls the data from relevant tables for initial loading into another system, which can then be setup for Entity Sync going forward.
-David On Feb 20, 2008, at 12:28 PM, Jeff Burton wrote:
I'm running into a problem where an initial entity sync (pull from server to POS) in order to load starting data is too time consuming and doesn't seem to be the best method for the task. I see there's an offline entity sync service and wonder if this may be more appropriate approach. What's the quick and dirty explanation of how this is setup and operates? Thanks.
